Circle Chart showing percent values automatically

Hi. I have used Circle-Charts in Access Reports. They were able to show
percent values by default, without having the percent values calculated or
delivered by SQL queries.
I am trying to get RSrv doing this also, but no success. Is it possible? Or
do I have to deliver the percent values to the diagram?
I actually am using RSrv without any SP.
Thanks, MarkusYou have to calculate the percentage value. The default data point label for
pie charts would be the absolute value rather than the percentage.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
news:389ADD61-DBAD-43C4-8576-8D31D819534C@.microsoft.com...
> Hi. I have used Circle-Charts in Access Reports. They were able to show
> percent values by default, without having the percent values calculated or
> delivered by SQL queries.
> I am trying to get RSrv doing this also, but no success. Is it possible?
> Or
> do I have to deliver the percent values to the diagram?
> I actually am using RSrv without any SP.
> Thanks, Markussqlsql

choose default value from DropDownList and SqlDataSource

Hello everyone

I'm really new to Data Presentation Controls and I already hate them couse I think they are way too complicated. Becouse of that i have already met wall many times. My last one sounds like this.

I'm triing to put a default value from, lets say SqlDataSource1 in a DropDownList that is created by SqlDataSource2. I know how to get value from SqlDataSource1 but I don't know how to use exactly that value as my default value in DropDownList.

Two more question.

1. Is it possible to have two different select statements in a SqlDataSource?

2. A SqlDataSource may contain an insert statement, select statement, update and delete. If I bind this SqlDataSource to a control how can I specify which of those statements will be used?

Thanks in advance

There are tutorials that cover all these topics in detail.

You bind the value to the dropdownlist's selectedvalue property.

1) Yes, but I don't recommend it.

2) By the command that is clicked within the presentation data control (Formview, detailview, gridview, etc).

I highly suggest you start with the tutorials. From those you learn the basics of how the data controls work. After you've mastered the data controls (Which really only takes an hour to learn the basics, and after a few days you've master them), then you can use them, or not. You always have the option of handling everything yourself. Do your own data retrieval, populate your controls, etc.

Choose a default hierarchy in a dimension

Hi all,

I explain my case. In a Article dimension I have 3 hierarchies (Natures, Staven, Service). When I browse my cube in bids with this exemple :

on rows axis I drag and drop article dimension

on columns axis I drag and drop a time dimension

on data area I made the same operation with a mesure

Then wen I expand article dimension the hierarchy I saw is Natures. I don't want it. I want Service one. How can i do that?

In advance thanks for your help.

Christophe

The first hierarchy you create in BIDS will be your default hierarchy. IE: The Top/left-most hierarchy you see in BIDS.|||

Hi,

Thanks for your reply. It's impossible to change that?

Christophe.

|||Hey,

You could recreate your hierarchies (if it's not too much of a pain). Or, I haven't tried this yet but assume it'll work, you could just change the order of your hierarchies in XMLA.

So, just script your dimension to a new query editor, search for your hierarchies, (you're looking for the <Hierarchies></Hierarchies> tags), and move the hierarchy you want to be default to the top of the list.

C

chng default loca where new DBs created?

Hello,
My workplace is upgrading Microsoft Access from 97 to 2002
which has the Access Data Project file that can create an
addhoc Sql Server DB on the Sql Server computer on the fly
from remote workstations. The wizard in the Access
2002 .adp file does not offer a location option where the
new Sql DB gets created on the Sql Server computer. The
problem is that these new DBs are getting created on the
server computer at a default location of
C:\Program Files\Microsoft Sql Server\MSSQL\Data
The problem is that the C drive on this server is only 12
gigs and will fill up quickly. The main MDFs reside on
the other drive of the server which has hundreds of gigs
of space. Does EM 2000 have a way to change the default
location where new DBs get created? Or is there a
registry setting I could change on the server?
Thanks,
RonIf you want to see it in EM, look at properties for the server, and click
the database tab. The defaults are in there.
Simon Worth
"Ron" <anonymous@.discussions.microsoft.com> wrote in message
news:745701c5266b$86508ff0$a601280a@.phx.gbl...
> Hello,
> My workplace is upgrading Microsoft Access from 97 to 2002
> which has the Access Data Project file that can create an
> addhoc Sql Server DB on the Sql Server computer on the fly
> from remote workstations. The wizard in the Access
> 2002 .adp file does not offer a location option where the
> new Sql DB gets created on the Sql Server computer. The
> problem is that these new DBs are getting created on the
> server computer at a default location of
> C:\Program Files\Microsoft Sql Server\MSSQL\Data
> The problem is that the C drive on this server is only 12
> gigs and will fill up quickly. The main MDFs reside on
> the other drive of the server which has hundreds of gigs
> of space. Does EM 2000 have a way to change the default
> location where new DBs get created? Or is there a
> registry setting I could change on the server?
> Thanks,
> Ron|||Ron,
In EM, open server properties windows and go to "Databse Settings" tab, at
the botton you can set "New database default location" for data and log.
AMB
"Ron" wrote:

> Hello,
> My workplace is upgrading Microsoft Access from 97 to 2002
> which has the Access Data Project file that can create an
> addhoc Sql Server DB on the Sql Server computer on the fly
> from remote workstations. The wizard in the Access
> 2002 .adp file does not offer a location option where the
> new Sql DB gets created on the Sql Server computer. The
> problem is that these new DBs are getting created on the
> server computer at a default location of
> C:\Program Files\Microsoft Sql Server\MSSQL\Data
> The problem is that the C drive on this server is only 12
> gigs and will fill up quickly. The main MDFs reside on
> the other drive of the server which has hundreds of gigs
> of space. Does EM 2000 have a way to change the default
> location where new DBs get created? Or is there a
> registry setting I could change on the server?
> Thanks,
> Ron
>

chng default loca where new DBs created?

Well, I changed the default location as advised (to F:
drive). I also restarted Sql Server. But the Access ADP
is still creating the Sql DB's on the C drive. Do I need
to reboot the server computer for the default location
change to take effect?

>--Original Message--
>Thank you all very much. I completely missed that.
>
>2002
an
>fly
the
12
>.
>Perhaps Access doesn't respect SQL Server's default setting?
Try below from Query Analyzer or OSQL.EXE:
CREATE DATABASE filepathtest
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Ron" <anonymous@.discussions.microsoft.com> wrote in message
news:7b4d01c52677$685a76d0$a401280a@.phx.gbl...
> Well, I changed the default location as advised (to F:
> drive). I also restarted Sql Server. But the Access ADP
> is still creating the Sql DB's on the C drive. Do I need
> to reboot the server computer for the default location
> change to take effect?
>
> an
> the
> 12|||>Perhaps Access doesn't respect SQL Server's default
>setting?

>Try below from Query Analyzer or OSQL.EXE:

>CREATE DATABASE filepathtest
Good idea. Well,l filepathtest went to the correct drive,
F instead of C. But when I create a new Access.adp either
on the same machine as Sql Server or from a remote
workstation, the new DB still ends up on the C drive. I
think Access does not respect Sql Server's default
settings.
Is there something that I could override in the .adp DDL
maybe? It would be a real nightmare if I had to manually
create a bunch of new adhoc DB's for Access2002 users
(since I would have to restrict them from doing it from
their .adp's).

>--Original Message--
>Perhaps Access doesn't respect SQL Server's default
setting?
>Try below from Query Analyzer or OSQL.EXE:
>CREATE DATABASE filepathtest
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>http://www.sqlug.se/
>
>"Ron" <anonymous@.discussions.microsoft.com> wrote in
message
>news:7b4d01c52677$685a76d0$a401280a@.phx.gbl...
need
The
the
gigs
default
>
>.
>|||The default database creation location set under Enterprise Manager is
saved in the local computer registry and ONLY applies to databases
created via EM on that computer.
If you create a database without using EM and without specifying a
location, the location will be the same as either the master or model
database files (I do not remember which db controls)
Carl Federl
Please post DDL (create table) with datatypes, primary and foreign keys.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||> Is there something that I could override in the .adp DDL
> maybe?
I don't know, don't do Access... :-)
I'd ask this in an Access group, perhaps they have some hints about some set
ting inside Access.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Ron" <anonymous@.discussions.microsoft.com> wrote in message
news:7bb901c52680$7266b450$a401280a@.phx.gbl...
>
>
> Good idea. Well,l filepathtest went to the correct drive,
> F instead of C. But when I create a new Access.adp either
> on the same machine as Sql Server or from a remote
> workstation, the new DB still ends up on the C drive. I
> think Access does not respect Sql Server's default
> settings.
> Is there something that I could override in the .adp DDL
> maybe? It would be a real nightmare if I had to manually
> create a bunch of new adhoc DB's for Access2002 users
> (since I would have to restrict them from doing it from
> their .adp's).
>
>
> setting?
> message
> need
> The
> the
> gigs
> default

childitem issues with xmlnamespaces and for xml path

I am having problems with the namespaces when using XML type data
inside a for XMLpath..
here is the first example
----
--
WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
select
'karl' as "name",
(select
'1' as "mine/one",
'2' as "mine/two"
for xml path('child'), type
)
for xml path('outer'), type
----
<outer xmlns="http://www.ratdog.com/example">
<name>karl</name>
<child xmlns="http://www.ratdog.com/example">
<mine>
<one>1</one>
<two>2</two>
</mine>
</child>
</outer>
----
you'll notice that it added the namespace to the "inner child" :),
which i'd rather it not do but at least its correct and it works.
however in the following example i put the "inner child" sql inside a
function as show :
----
create function dbo.testfunc()
returns XML
as
begin
return
(
select
'1' as "mine/one",
'2' as "mine/two"
for xml path('child'), type
)
end
WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
select
'karl' as "name",
dbo.testfunc()
for xml path('outer'), type
---
<outer xmlns="http://www.ratdog.com/example">
<name>karl</name>
<child xmlns="">
<mine>
<one>1</one>
<two>2</two>
</mine>
</child>
</outer>
---
and it puts the namespace as "", which i definately don't want.. i
don't want that clause in there at all
how can i get rid of it? or achieve a suitable workaround.
KarlNote that the function creates a document that has no namespace associated
with it. Since you include it in one that has the prefix, we have to
undeclare the default prefix.
So if you want to have the function have the same default namespace, you
need to use the WITH clause in the function.
And no, we currently do not remove the declarations on the inner level if
they are redundant...
Best regards
Michael
<klumsy@.xtra.co.nz> wrote in message
news:1144364933.977174.287100@.u72g2000cwu.googlegroups.com...
> I am having problems with the namespaces when using XML type data
> inside a for XMLpath..
> here is the first example
> ----
--
> WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
> select
> 'karl' as "name",
> (select
> '1' as "mine/one",
> '2' as "mine/two"
> for xml path('child'), type
> )
> for xml path('outer'), type
> ----
> <outer xmlns="http://www.ratdog.com/example">
> <name>karl</name>
> <child xmlns="http://www.ratdog.com/example">
> <mine>
> <one>1</one>
> <two>2</two>
> </mine>
> </child>
> </outer>
> ----
> you'll notice that it added the namespace to the "inner child" :),
> which i'd rather it not do but at least its correct and it works.
> however in the following example i put the "inner child" sql inside a
> function as show :
> ----
> create function dbo.testfunc()
> returns XML
> as
> begin
> return
> (
> select
> '1' as "mine/one",
> '2' as "mine/two"
> for xml path('child'), type
> )
> end
> WITH XMLNAMESPACES(DEFAULT 'http://www.ratdog.com/example' )
> select
> 'karl' as "name",
> dbo.testfunc()
> for xml path('outer'), type
> ---
> <outer xmlns="http://www.ratdog.com/example">
> <name>karl</name>
> <child xmlns="">
> <mine>
> <one>1</one>
> <two>2</two>
> </mine>
> </child>
> </outer>
> ---
> and it puts the namespace as "", which i definately don't want.. i
> don't want that clause in there at all
> how can i get rid of it? or achieve a suitable workaround.
> Karl
>

checking data and index linkages on msdb and master

Hi, I am running a maintenance plan daily, and under default configurations,
it's failing to Check data and index linkages on the "master" and "msdb"
database because it's not in single user mode. Am I not able to do this?
If so, do I need to change it to single user? Will that harm anything else?
_____
DC GIt's failing because you've set the job up to automatically repair minor
errors. You should not do this - always investigate integrity problems
before taking any corrective action (i.e. restoring from your backups)
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"DC Gringo" <glevine@.visiontechnology.net> wrote in message
news:ueA0bX0lDHA.1244@.TK2MSFTNGP11.phx.gbl...
> Hi, I am running a maintenance plan daily, and under default
configurations,
> it's failing to Check data and index linkages on the "master" and "msdb"
> database because it's not in single user mode. Am I not able to do this?
> If so, do I need to change it to single user? Will that harm anything
else?
> _____
> DC G
>