grouping problems

how to i make a report like this?
group 1 start
group 2 start
group 2 end
group 3 start
group 3 end
group 1 end
i keep trying, but can only make a report like this:
group 1 start
group 2 start
group 3 start
group 3 end
group 2 end
group 1 end
i am using sql server 2000 reporting services, Visual studio .NET 2003
thanks for answeringHow 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.
newbie00100 wrote:
> how to i make a report like this?
> group 1 start
> group 2 start
> group 2 end
> group 3 start
> group 3 end
> group 1 end
> i keep trying, but can only make a report like this:
> group 1 start
> group 2 start
> group 3 start
> group 3 end
> group 2 end
> group 1 end
> i am using sql server 2000 reporting services, Visual studio .NET 2003
> thanks for answering|||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
"toolman" wrote:
> 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.
> newbie00100 wrote:
> > how to i make a report like this?
> >
> > group 1 start
> > group 2 start
> > group 2 end
> > group 3 start
> > group 3 end
> > group 1 end
> >
> > i keep trying, but can only make a report like this:
> > group 1 start
> > group 2 start
> > group 3 start
> > group 3 end
> > group 2 end
> > group 1 end
> >
> > i am using sql server 2000 reporting services, Visual studio .NET 2003
> > thanks for answering
>