grouping problems -- sql server reporting services

toolman
7/18/2006 11:01:07 AM

How are your groups defined? All on the same field or separate fields?
If on all the same field, what differentiates group1 from group2 from
group3? If you could provide examples of your data it'd be much easier
to visualize what you need.

[quoted text, click to view]

newbie00100
7/18/2006 8:15:02 PM

hi,

i have a dataset storing the yearly sales volume of last year, let it be
group 1
the group2 would be the monthly sales volume of last month,
the group3 would be the quarterly sales volumn of last quarter
group2 and group3 both retrieve data from group1
go i want the structure to be like
group 1 start

group 2 start
group 2 end

group 3 start
group 3 end

group 1 end

and i also want to ask how do I filter the records of last month/last
quarter, without modifying the stored procedure? the filter on the group
options seems to filter a column but not a record.

thanks for answering

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : grouping problems