I have a report in SQL 2000 Reporting Services with several tables.
The only thing showing in these tables are the group footers because
the detail data is not needed.
I am needing to add a total for a column in each table and then add
those totals together in a text box.
When ever I do this I am getting the following errors:
The value expression for the text box 'textbox58' uses an aggregate
function on a report item. Aggregate functions can be used only on
report items contained in page headers and footers.
The value expression for the text box 'textbox37' uses an aggregate
expression without a scope. A scope is required for all aggregates
used outside of a data region unless the report contains exactly one
data set.
I've tried several different ways and still can't figure it out, PLEASE
HELP!!A few design suggestions. If you don't need the detail then don't return it.
Let SQL Server do the work. But, let's say you continue the way you are
today. What I do sometimes is to add a colum to the result set and make it
calculated, then using the expression editor make it the sum of the two
fields. This makes things a whole lot easier at times.
Once you have done this you can use the expression editor, base it on the
dataset and sum up the column.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jasper.frazee@.gmail.com> wrote in message
news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>I have a report in SQL 2000 Reporting Services with several tables.
> The only thing showing in these tables are the group footers because
> the detail data is not needed.
> I am needing to add a total for a column in each table and then add
> those totals together in a text box.
> When ever I do this I am getting the following errors:
> The value expression for the text box 'textbox58' uses an aggregate
> function on a report item. Aggregate functions can be used only on
> report items contained in page headers and footers.
> The value expression for the text box 'textbox37' uses an aggregate
> expression without a scope. A scope is required for all aggregates
> used outside of a data region unless the report contains exactly one
> data set.
> I've tried several different ways and still can't figure it out, PLEASE
> HELP!!
>|||Thanks for the Responce Bruce!
In my dataset there are 5 columns that will alwayse have the same
result and one column that has detail data that needs to be summed. If
I sum that one column in SQL I have to have the other columns in an
aggregate function as well. In SQL 2000 the "First" function is not
supported. Any ways around that?
Once I get the totals in each table on my report how can I grab those
totals and sum them in a textbox? It keeps telling me that "Aggregate
functions can be used only on
report items contained in page headers and footers."
Thanks A Lot!
Jasper
Bruce L-C [MVP] wrote:
> A few design suggestions. If you don't need the detail then don't return it.
> Let SQL Server do the work. But, let's say you continue the way you are
> today. What I do sometimes is to add a colum to the result set and make it
> calculated, then using the expression editor make it the sum of the two
> fields. This makes things a whole lot easier at times.
> Once you have done this you can use the expression editor, base it on the
> dataset and sum up the column.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <jasper.frazee@.gmail.com> wrote in message
> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
> >I have a report in SQL 2000 Reporting Services with several tables.
> > The only thing showing in these tables are the group footers because
> > the detail data is not needed.
> > I am needing to add a total for a column in each table and then add
> > those totals together in a text box.
> > When ever I do this I am getting the following errors:
> >
> > The value expression for the text box 'textbox58' uses an aggregate
> > function on a report item. Aggregate functions can be used only on
> > report items contained in page headers and footers.
> >
> > The value expression for the text box 'textbox37' uses an aggregate
> > expression without a scope. A scope is required for all aggregates
> > used outside of a data region unless the report contains exactly one
> > data set.
> >
> > I've tried several different ways and still can't figure it out, PLEASE
> > HELP!!
> >|||You can sum the numbers by summing =ReportItems("textbox1").Value +
ReportItems("textbox2").Value etc.
You need to know the names of the textboxes, so you might want to name the
textboxes with something more descriptive than textbox1 etc before you start
summing. :)
(Not sure if it's ReportItems or ReportItem, so you might have to try both.)
Kaisa M. Lindahl Lervik
<jasper.frazee@.gmail.com> wrote in message
news:1162417277.149051.147270@.f16g2000cwb.googlegroups.com...
> Thanks for the Responce Bruce!
> In my dataset there are 5 columns that will alwayse have the same
> result and one column that has detail data that needs to be summed. If
> I sum that one column in SQL I have to have the other columns in an
> aggregate function as well. In SQL 2000 the "First" function is not
> supported. Any ways around that?
> Once I get the totals in each table on my report how can I grab those
> totals and sum them in a textbox? It keeps telling me that "Aggregate
> functions can be used only on
> report items contained in page headers and footers."
> Thanks A Lot!
> Jasper
> Bruce L-C [MVP] wrote:
>> A few design suggestions. If you don't need the detail then don't return
>> it.
>> Let SQL Server do the work. But, let's say you continue the way you are
>> today. What I do sometimes is to add a colum to the result set and make
>> it
>> calculated, then using the expression editor make it the sum of the two
>> fields. This makes things a whole lot easier at times.
>> Once you have done this you can use the expression editor, base it on the
>> dataset and sum up the column.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <jasper.frazee@.gmail.com> wrote in message
>> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>> >I have a report in SQL 2000 Reporting Services with several tables.
>> > The only thing showing in these tables are the group footers because
>> > the detail data is not needed.
>> > I am needing to add a total for a column in each table and then add
>> > those totals together in a text box.
>> > When ever I do this I am getting the following errors:
>> >
>> > The value expression for the text box 'textbox58' uses an aggregate
>> > function on a report item. Aggregate functions can be used only on
>> > report items contained in page headers and footers.
>> >
>> > The value expression for the text box 'textbox37' uses an aggregate
>> > expression without a scope. A scope is required for all aggregates
>> > used outside of a data region unless the report contains exactly one
>> > data set.
>> >
>> > I've tried several different ways and still can't figure it out, PLEASE
>> > HELP!!
>> >
>sql
Showing posts with label group. Show all posts
Showing posts with label group. Show all posts
Thursday, March 29, 2012
Can't stop page breaks on my grouped list
All,
I've created a list and defined a group for monthly period. In the
list, I include several controls that show each month's summary values.
Unfortunately, each month's set of controls is appearing on separate
pages. The sections are small enough to fit two or three per page.
I've verified that the two page break properties are both set to False.
I've set the Keep Together property to False. What else am I missing?
Are their layout issues concerning margins or anything like that? This
is the first time I've tried to use grouped lists so I don't know what
to think.
I created the report with the report wizards and then modified it from
there. Maybe that will help.
Thanks,
DavidIt's me...the originator of this message.
I apparently have not found the list control's property that made it
serve as the Page field container that I chose in the New Report Wizard
(Matrix report). I would have thought the New Page After property.
Nevertheless, I created a new list control and copied my controls into
it. After defining my group, all worked as expected.
So if you're reading this and have a guess why the list control
mysteriously ejected pages, please respond. I'm interested.
David|||What was the property ? I am having a similar problem with the
occasional page in my report (200 pages) breaking about half way down
the page.
davidb@.mercurydata.com wrote:
> It's me...the originator of this message.
> I apparently have not found the list control's property that made it
> serve as the Page field container that I chose in the New Report Wizard
> (Matrix report). I would have thought the New Page After property.
> Nevertheless, I created a new list control and copied my controls into
> it. After defining my group, all worked as expected.
> So if you're reading this and have a guess why the list control
> mysteriously ejected pages, please respond. I'm interested.
> David
I've created a list and defined a group for monthly period. In the
list, I include several controls that show each month's summary values.
Unfortunately, each month's set of controls is appearing on separate
pages. The sections are small enough to fit two or three per page.
I've verified that the two page break properties are both set to False.
I've set the Keep Together property to False. What else am I missing?
Are their layout issues concerning margins or anything like that? This
is the first time I've tried to use grouped lists so I don't know what
to think.
I created the report with the report wizards and then modified it from
there. Maybe that will help.
Thanks,
DavidIt's me...the originator of this message.
I apparently have not found the list control's property that made it
serve as the Page field container that I chose in the New Report Wizard
(Matrix report). I would have thought the New Page After property.
Nevertheless, I created a new list control and copied my controls into
it. After defining my group, all worked as expected.
So if you're reading this and have a guess why the list control
mysteriously ejected pages, please respond. I'm interested.
David|||What was the property ? I am having a similar problem with the
occasional page in my report (200 pages) breaking about half way down
the page.
davidb@.mercurydata.com wrote:
> It's me...the originator of this message.
> I apparently have not found the list control's property that made it
> serve as the Page field container that I chose in the New Report Wizard
> (Matrix report). I would have thought the New Page After property.
> Nevertheless, I created a new list control and copied my controls into
> it. After defining my group, all worked as expected.
> So if you're reading this and have a guess why the list control
> mysteriously ejected pages, please respond. I'm interested.
> David
Thursday, March 22, 2012
can't seem to get my GROUP BY ordering right
I have the following query, which works, but the ordering isn't quite
right, can anyone help?
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
to_char(date_created,'DD-MON-YYYY')
the output is shwon as follows:
02-APR-2006 - 1
03-APR-2006 - 1
04-APR-2006 - 4
05-APR-2006 - 8
06-APR-2006 - 11
08-MAR-2006 - 2
16-MAR-2006 - 2
17-MAR-2006 - 2
20-MAR-2006 - 3
21-MAR-2006 - 1
22-MAR-2006 - 1
but I would rather it was more logically ordered for a report, as so:
06-APR-2006 - 11
05-APR-2006 - 8
04-APR-2006 - 4
03-APR-2006 - 1
02-APR-2006 - 1
22-MAR-2006 - 1
21-MAR-2006 - 1
20-MAR-2006 - 3
17-MAR-2006 - 2
16-MAR-2006 - 2
08-MAR-2006 - 2
i.e. reverse order of date, and calendar month (not by month starting
letter)
TIA for any help and advicedid you try using DESC (for descending)?|||Kevin,
try
ORDER BY date_created DESC|||Also I suspect you're going to have to order desc by year/month/day
instead of d/m/y|||whooops.. forgot the mention that bit.. yup.. if I add DESC then the
order is reversed by DD, then MON, then YYYY... but that means that the
MAR dates appear before APR, as alphabetically, and in reverse order, M
comes before A.
I guess I should have mentioned that bit, eh' thanks for the quick
replies btw|||What if you try this (let me know if it helps..)
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
date_created desc
"Kevin Blount" wrote:
> I have the following query, which works, but the ordering isn't quite
> right, can anyone help?
> SELECT
> to_char(date_created,'DD-MON-YYYY') as date_joined,
> COUNT(user_id) AS user_count
> FROM
> project_users
> GROUP BY
> to_char(date_created,'DD-MON-YYYY')
> ORDER BY
> to_char(date_created,'DD-MON-YYYY')
>
> the output is shwon as follows:
> 02-APR-2006 - 1
> 03-APR-2006 - 1
> 04-APR-2006 - 4
> 05-APR-2006 - 8
> 06-APR-2006 - 11
> 08-MAR-2006 - 2
> 16-MAR-2006 - 2
> 17-MAR-2006 - 2
> 20-MAR-2006 - 3
> 21-MAR-2006 - 1
> 22-MAR-2006 - 1
> but I would rather it was more logically ordered for a report, as so:
> 06-APR-2006 - 11
> 05-APR-2006 - 8
> 04-APR-2006 - 4
> 03-APR-2006 - 1
> 02-APR-2006 - 1
> 22-MAR-2006 - 1
> 21-MAR-2006 - 1
> 20-MAR-2006 - 3
> 17-MAR-2006 - 2
> 16-MAR-2006 - 2
> 08-MAR-2006 - 2
> i.e. reverse order of date, and calendar month (not by month starting
> letter)
> TIA for any help and advice
>|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144353616.181845.72600@.e56g2000cwe.googlegroups.com...
> whooops.. forgot the mention that bit.. yup.. if I add DESC then the
> order is reversed by DD, then MON, then YYYY... but that means that the
> MAR dates appear before APR, as alphabetically, and in reverse order, M
> comes before A.
> I guess I should have mentioned that bit, eh' thanks for the quick
> replies btw
>
I think you should have mentioned that this isn't a SQL Server query at all.
Oracle?
Anyway, try:
ORDER BY MIN(date_created)
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks David, using ' MIN(date_created) DESC ' worked a charm (just '
date_created DESC ' didn't work at all for some reason).
I must confess, I saw SQL in the group name, but missed the SQLSERVER
part.. but then it's tricky finding a general group for queries..
unless someone knows of one?|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144354904.773319.110340@.i40g2000cwc.googlegroups.com...
> I must confess, I saw SQL in the group name, but missed the SQLSERVER
> part.. but then it's tricky finding a general group for queries..
> unless someone knows of one?
There are specific groups for Oracle:
comp.databases.oracle.server
comp.databases.oracle.misc
For others check out http://groups.google.com
Whatever the product you are using, *always* state your version number.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
right, can anyone help?
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
to_char(date_created,'DD-MON-YYYY')
the output is shwon as follows:
02-APR-2006 - 1
03-APR-2006 - 1
04-APR-2006 - 4
05-APR-2006 - 8
06-APR-2006 - 11
08-MAR-2006 - 2
16-MAR-2006 - 2
17-MAR-2006 - 2
20-MAR-2006 - 3
21-MAR-2006 - 1
22-MAR-2006 - 1
but I would rather it was more logically ordered for a report, as so:
06-APR-2006 - 11
05-APR-2006 - 8
04-APR-2006 - 4
03-APR-2006 - 1
02-APR-2006 - 1
22-MAR-2006 - 1
21-MAR-2006 - 1
20-MAR-2006 - 3
17-MAR-2006 - 2
16-MAR-2006 - 2
08-MAR-2006 - 2
i.e. reverse order of date, and calendar month (not by month starting
letter)
TIA for any help and advicedid you try using DESC (for descending)?|||Kevin,
try
ORDER BY date_created DESC|||Also I suspect you're going to have to order desc by year/month/day
instead of d/m/y|||whooops.. forgot the mention that bit.. yup.. if I add DESC then the
order is reversed by DD, then MON, then YYYY... but that means that the
MAR dates appear before APR, as alphabetically, and in reverse order, M
comes before A.
I guess I should have mentioned that bit, eh' thanks for the quick
replies btw|||What if you try this (let me know if it helps..)
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
date_created desc
"Kevin Blount" wrote:
> I have the following query, which works, but the ordering isn't quite
> right, can anyone help?
> SELECT
> to_char(date_created,'DD-MON-YYYY') as date_joined,
> COUNT(user_id) AS user_count
> FROM
> project_users
> GROUP BY
> to_char(date_created,'DD-MON-YYYY')
> ORDER BY
> to_char(date_created,'DD-MON-YYYY')
>
> the output is shwon as follows:
> 02-APR-2006 - 1
> 03-APR-2006 - 1
> 04-APR-2006 - 4
> 05-APR-2006 - 8
> 06-APR-2006 - 11
> 08-MAR-2006 - 2
> 16-MAR-2006 - 2
> 17-MAR-2006 - 2
> 20-MAR-2006 - 3
> 21-MAR-2006 - 1
> 22-MAR-2006 - 1
> but I would rather it was more logically ordered for a report, as so:
> 06-APR-2006 - 11
> 05-APR-2006 - 8
> 04-APR-2006 - 4
> 03-APR-2006 - 1
> 02-APR-2006 - 1
> 22-MAR-2006 - 1
> 21-MAR-2006 - 1
> 20-MAR-2006 - 3
> 17-MAR-2006 - 2
> 16-MAR-2006 - 2
> 08-MAR-2006 - 2
> i.e. reverse order of date, and calendar month (not by month starting
> letter)
> TIA for any help and advice
>|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144353616.181845.72600@.e56g2000cwe.googlegroups.com...
> whooops.. forgot the mention that bit.. yup.. if I add DESC then the
> order is reversed by DD, then MON, then YYYY... but that means that the
> MAR dates appear before APR, as alphabetically, and in reverse order, M
> comes before A.
> I guess I should have mentioned that bit, eh' thanks for the quick
> replies btw
>
I think you should have mentioned that this isn't a SQL Server query at all.
Oracle?
Anyway, try:
ORDER BY MIN(date_created)
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks David, using ' MIN(date_created) DESC ' worked a charm (just '
date_created DESC ' didn't work at all for some reason).
I must confess, I saw SQL in the group name, but missed the SQLSERVER
part.. but then it's tricky finding a general group for queries..
unless someone knows of one?|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144354904.773319.110340@.i40g2000cwc.googlegroups.com...
> I must confess, I saw SQL in the group name, but missed the SQLSERVER
> part.. but then it's tricky finding a general group for queries..
> unless someone knows of one?
There are specific groups for Oracle:
comp.databases.oracle.server
comp.databases.oracle.misc
For others check out http://groups.google.com
Whatever the product you are using, *always* state your version number.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Can't seem to fix the column width
I have a matrix report. I put a rectangle with two text boxes - inside
the column group. Works great!
However - now I can't seem to fix the width of the columns. It just
grows and ignores the property. I have tried to set it for each
individual cell in that matrix. And I have tried to specify the size..
Any idea?
ThxI am not sure when the column width grows. Does this happen when authoring
the report or when you render it? Would you please add some more detail
reproduction steps to your description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407150710.6351cec1@.posting.google.com...
> I have a matrix report. I put a rectangle with two text boxes - inside
> the column group. Works great!
> However - now I can't seem to fix the width of the columns. It just
> grows and ignores the property. I have tried to set it for each
> individual cell in that matrix. And I have tried to specify the size..
> Any idea?
> Thx|||The reproduction step is:
Create a matrix.
Add a field to the column group textbox.
Fix column width - by selecting Cannot Grow.
Fix the Cell width - by selecting cannot Grow.
Works great!
Now add a rectangle inside the column group textbox...
The 'Cannot grow' fails...|||CanGrow only applies to vertical growth, not horizontal growth. However, the
only thing that grows horizontally is autosized images and matrices (per
column group instance).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407181543.300fff7c@.posting.google.com...
> The reproduction step is:
> Create a matrix.
> Add a field to the column group textbox.
> Fix column width - by selecting Cannot Grow.
> Fix the Cell width - by selecting cannot Grow.
> Works great!
> Now add a rectangle inside the column group textbox...
> The 'Cannot grow' fails...
the column group. Works great!
However - now I can't seem to fix the width of the columns. It just
grows and ignores the property. I have tried to set it for each
individual cell in that matrix. And I have tried to specify the size..
Any idea?
ThxI am not sure when the column width grows. Does this happen when authoring
the report or when you render it? Would you please add some more detail
reproduction steps to your description.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407150710.6351cec1@.posting.google.com...
> I have a matrix report. I put a rectangle with two text boxes - inside
> the column group. Works great!
> However - now I can't seem to fix the width of the columns. It just
> grows and ignores the property. I have tried to set it for each
> individual cell in that matrix. And I have tried to specify the size..
> Any idea?
> Thx|||The reproduction step is:
Create a matrix.
Add a field to the column group textbox.
Fix column width - by selecting Cannot Grow.
Fix the Cell width - by selecting cannot Grow.
Works great!
Now add a rectangle inside the column group textbox...
The 'Cannot grow' fails...|||CanGrow only applies to vertical growth, not horizontal growth. However, the
only thing that grows horizontally is autosized images and matrices (per
column group instance).
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407181543.300fff7c@.posting.google.com...
> The reproduction step is:
> Create a matrix.
> Add a field to the column group textbox.
> Fix column width - by selecting Cannot Grow.
> Fix the Cell width - by selecting cannot Grow.
> Works great!
> Now add a rectangle inside the column group textbox...
> The 'Cannot grow' fails...
Monday, March 19, 2012
Can't see any data when I browse the cube :(
Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ' I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.micr
osoft.com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ' I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ' I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.micr
osoft.com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ' I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.
Can't see any data when I browse the cube :(
Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ? I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.
Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.microsoft. com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ? I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ? I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.
Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.microsoft. com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ? I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.
Thursday, March 8, 2012
Can't remove empty file group - no files in sysfiles
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.
Can't remove empty file group - no files in sysfiles
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
TelaanIs this the primary filegroup? If so, you can't remove it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245241.370186.158990@.g47g2000cwa.googlegroups.com...
Hi,
I've dropped all the files in my index filegroup (not default) but I
get this message when I try to remove the filegroup itself.
Server: Msg 5042, Level 16, State 8, Line 1
The filegroup 'xxxxx' cannot be removed because it is not empty.
Sysfiles isnt' listing the deleted files and sysfilegroups is showing
that there are 0 files in the filegroup. I've confirmed this by
looking at the properties of the database through EM. I've tried
cycling the services but I still can't drop the filegroup. Does anyone
know why I can't remove the filegroup? Any help would be greatly
appreciated.
I'm running SQL Server 2000 sp3
Thanks!
Telaan|||Nope. Just an additional filegroup I used to put indexes in.|||When you emptied the files, did you use the EMPTYFILE option with DBCC
SHRINKFILE?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"telaan" <telaan@.hotmail.com> wrote in message
news:1127245751.943569.313230@.g44g2000cwa.googlegroups.com...
Nope. Just an additional filegroup I used to put indexes in.|||does the file group is is a default file group?.|||If you are going to drop a filegroup, then you should make another group the
default.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127295464.994452.116930@.o13g2000cwo.googlegroups.com...
does the file group is is a default file group?.|||Thanks for the replies. The filegroup wasn't default but I've found
the problem by running the profiler to find out what system table still
had the filegroup referenced. It was the sysindexes table holding old
stats. You can find by running this query.
select name,id from dbo.sysindexes where groupid = 2 --id of filegroup
you want to drop.
I dropped the stats and was able to drop the filegroup.
Friday, February 24, 2012
Can't manage a remote SQL Server
I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?
What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?
What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Can't manage a remote SQL Server
I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Can't manage a remote SQL Server
I have a SQL Server running on a new W2k3 Server, and a group in the AD
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
received the Sys Admin roles at this SQL Server. However, this members can't
access this SQL Server using the Service Manager nor stop/pause this server.
The others operations, suck as creating a new DB is ok for this group. Any
help?What is the exact error message they get?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Tuesday, February 14, 2012
Cant install SQL Server 05 EE, VB 2005, or Visual Web Dev 2005
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
EE = Express Edition or Enterprise Edition?
I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.
>
EE = Express Edition or Enterprise Edition?
>
>
I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.
>
Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||pine (mrehpine@.gmail.com) writes:
Hm, if the install is that fresh, then it the easiest way would be
to start over again, and then start with installing .Net Fx followed
by SQL Server, and then Visual Basic and Visual Web Developer. (But
avoid the other junk you usually cram in. :-)
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
whenever i try to install SQL server EE, it is telling me that it has
found beta components. but i don't have any beta versions of SQL. I
tried uninstalling my Vb 6.0 thinking its causing the error, but same
thing happened.
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
When i downloaded the exe files for SQL, .net 2.0, VB and VW, i did
select the SAVE option and saved them on my external mini hard drive so
I can install it at home. Does that make any difference? could that
cause the error?
pretty clear that i am a newbie with this stuff and i never thought
that it would be this hassle to install them heheheh any help, in a
detailed way if possible, would highly be appreciated.
thanks so much!
mannypine (mrehpine@.gmail.com) writes:
Quote:
Originally Posted by
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
EE = Express Edition or Enterprise Edition?
Quote:
Originally Posted by
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.
Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.
Erland Sommarskog wrote:
Quote:
Originally Posted by
pine (mrehpine@.gmail.com) writes:
Quote:
Originally Posted by
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.
>
EE = Express Edition or Enterprise Edition?
>
Quote:
Originally Posted by
The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?
>
I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.
>
Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||pine (mrehpine@.gmail.com) writes:
Quote:
Originally Posted by
hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.
Hm, if the install is that fresh, then it the easiest way would be
to start over again, and then start with installing .Net Fx followed
by SQL Server, and then Visual Basic and Visual Web Developer. (But
avoid the other junk you usually cram in. :-)
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Sunday, February 12, 2012
Can't group on Month part of the date.
Hi everyone,
I have a report with Period field that I use on a graph as Category
field (horozontal axe.) I want to group on the month part of the
Period. In my sql query Period is DATETIME. I found a similar topic
here and used this expession to group on month:
=DatePart("MM", Fields!Period.Value)
I also sorted by Period to preserve date-order.
I am getting the following error in preview:
The group expression for the grouping 'chart1_CategoryGroup1' contains
an error: Argument "Interval" is not a valid value.
Here is a format of my Period as it comes from SQL Server:
2004-02-29 00:00:00.000
Any ideas what is wrong?
Thanks in advance!
StanI just found my problem.
this
=DatePart("MM", Fields!Period.Value) shoild be like that:
=DatePart("M", Fields!Period.Value)
One single m!
Stan|||There is another problem. My data runs from February, 2004 to October,
2005. When I group on month my graph shows only 12 months. I don't see
data from the mid-end 2005!!! Is this s bug or a feature of RS'
Stan|||You need to group on the combination of year and month - otherwise data
from both Feb 2004 and Feb 2005 will be grouped together (and similarly
for other months, of course).
Something like =DatePart("yyyy", Fields!Period.Value) & " " &
DatePart("m", Fields!Period.Value)
You may need to convert this to a string, with a leading zero for the
month, for it to work correctly.|||Thanks! I did just that. In Group On expression for the Period in my
graph I entered:
=Year(Fields!Period.Value)*100 + Month(Fields!Period.Value)
so that I group on a combination of year and month.
Stan
I have a report with Period field that I use on a graph as Category
field (horozontal axe.) I want to group on the month part of the
Period. In my sql query Period is DATETIME. I found a similar topic
here and used this expession to group on month:
=DatePart("MM", Fields!Period.Value)
I also sorted by Period to preserve date-order.
I am getting the following error in preview:
The group expression for the grouping 'chart1_CategoryGroup1' contains
an error: Argument "Interval" is not a valid value.
Here is a format of my Period as it comes from SQL Server:
2004-02-29 00:00:00.000
Any ideas what is wrong?
Thanks in advance!
StanI just found my problem.
this
=DatePart("MM", Fields!Period.Value) shoild be like that:
=DatePart("M", Fields!Period.Value)
One single m!
Stan|||There is another problem. My data runs from February, 2004 to October,
2005. When I group on month my graph shows only 12 months. I don't see
data from the mid-end 2005!!! Is this s bug or a feature of RS'
Stan|||You need to group on the combination of year and month - otherwise data
from both Feb 2004 and Feb 2005 will be grouped together (and similarly
for other months, of course).
Something like =DatePart("yyyy", Fields!Period.Value) & " " &
DatePart("m", Fields!Period.Value)
You may need to convert this to a string, with a leading zero for the
month, for it to work correctly.|||Thanks! I did just that. In Group On expression for the Period in my
graph I entered:
=Year(Fields!Period.Value)*100 + Month(Fields!Period.Value)
so that I group on a combination of year and month.
Stan
Cant get windows authentication in Mixed Mode to work .... any ideas?
Hey all,
I've got SQL 2K running in mixed mode. I created a windows acct (mytest) in the administrator group, and then created a corresponding SQL account (mytest) using the windows authentication. In the EM it comes up as a "Windows User" type of acct. (The account is not a domain account but a workstation one).
I've configured my app to use that account for access to the database but I get the following error message when I send the connection request to the datasource:
Connection Failed:
SQL State:28000
SQL Server Error: 18456
Login failed for user myworkstation\mytest
I can connect just fine using the sql accounts, but it doesn't want to play nice when I need the windows authentication portion to work.
What exactly am I doing wrong?
Any input is greatly appreciated !
Regards,
TammyA couple of things come to mind...
1. If mytest is a member of the workstation Administrators group, then you do not (necessarily) need a separate SQL account for it. The BUILTIN\Administrators account permits all members of the local Administrators group to have access (in the default config anyway).
2. If you have denied access to the BUILTIN\Administrators group, then myWorkstation\mytest will not have access (Deny trumps permit).
3. Just a head check: you said that myworkstation\mytest was NOT a domain account (when you set it up). You didn't by chance login under the domain?
Just my $ .02. It's not much, I'll grant you, but it was what I could come up with.
hmscott|||Mr. Scott !
I'm such an idiot ....
I had forgotten that I denied access to the builtin Administrator account. I turned it back on and VOILA !
Mr. Scott - 1
Tammy - 0
Gracias !
Originally posted by hmscott
A couple of things come to mind...
1. If mytest is a member of the workstation Administrators group, then you do not (necessarily) need a separate SQL account for it. The BUILTIN\Administrators account permits all members of the local Administrators group to have access (in the default config anyway).
2. If you have denied access to the BUILTIN\Administrators group, then myWorkstation\mytest will not have access (Deny trumps permit).
3. Just a head check: you said that myworkstation\mytest was NOT a domain account (when you set it up). You didn't by chance login under the domain?
Just my $ .02. It's not much, I'll grant you, but it was what I could come up with.
hmscott
I've got SQL 2K running in mixed mode. I created a windows acct (mytest) in the administrator group, and then created a corresponding SQL account (mytest) using the windows authentication. In the EM it comes up as a "Windows User" type of acct. (The account is not a domain account but a workstation one).
I've configured my app to use that account for access to the database but I get the following error message when I send the connection request to the datasource:
Connection Failed:
SQL State:28000
SQL Server Error: 18456
Login failed for user myworkstation\mytest
I can connect just fine using the sql accounts, but it doesn't want to play nice when I need the windows authentication portion to work.
What exactly am I doing wrong?
Any input is greatly appreciated !
Regards,
TammyA couple of things come to mind...
1. If mytest is a member of the workstation Administrators group, then you do not (necessarily) need a separate SQL account for it. The BUILTIN\Administrators account permits all members of the local Administrators group to have access (in the default config anyway).
2. If you have denied access to the BUILTIN\Administrators group, then myWorkstation\mytest will not have access (Deny trumps permit).
3. Just a head check: you said that myworkstation\mytest was NOT a domain account (when you set it up). You didn't by chance login under the domain?
Just my $ .02. It's not much, I'll grant you, but it was what I could come up with.
hmscott|||Mr. Scott !
I'm such an idiot ....
I had forgotten that I denied access to the builtin Administrator account. I turned it back on and VOILA !
Mr. Scott - 1
Tammy - 0
Gracias !
Originally posted by hmscott
A couple of things come to mind...
1. If mytest is a member of the workstation Administrators group, then you do not (necessarily) need a separate SQL account for it. The BUILTIN\Administrators account permits all members of the local Administrators group to have access (in the default config anyway).
2. If you have denied access to the BUILTIN\Administrators group, then myWorkstation\mytest will not have access (Deny trumps permit).
3. Just a head check: you said that myworkstation\mytest was NOT a domain account (when you set it up). You didn't by chance login under the domain?
Just my $ .02. It's not much, I'll grant you, but it was what I could come up with.
hmscott
Subscribe to:
Posts (Atom)