"bjkaledas" <bjkaledas@discussions.microsoft.com> wrote in message
news:D0704272-4328-44F9-8902-55CE36C704A8@microsoft.com...
> Is it possible to display three different record values in one grouping
> header? For instance, I have End of Year values for three different
> records
> for a grouping called Burbank. I am grouping by Burbank, but I want to
> show
> the Year End value for Burbank in 2005, 2006, and a 2007 projection, but
> they
> are three separate records in my query. If statements will only grab the
> first year and subreports slow down the report a ton just for one value.
>
> Thanks,
>
> BJ

"bjkaledas" <bjkaledas@discussions.microsoft.com> wrote in message
news:AA264F47-3040-40C6-9C87-9805596376B0@microsoft.com...
> How would I interact with the select statement in my report though? I
> have
> the say 3 separate records in my SELECT statement of my dataset, but in
> the
> report I want to display them all in one row. It is almost like a Matrix,
> but I don't want to grow across. I want to preacknowledge that I have a
> value from 2005, 2006, and 2007 that I want to display from three separate
> records, but on one line of the report.
>
> "Ben Watts" wrote:
>
>> You could always use a case statemnt for each year in your select
>> statement.
>> "bjkaledas" <bjkaledas@discussions.microsoft.com> wrote in message
>> news:D0704272-4328-44F9-8902-55CE36C704A8@microsoft.com...
>> > Is it possible to display three different record values in one grouping
>> > header? For instance, I have End of Year values for three different
>> > records
>> > for a grouping called Burbank. I am grouping by Burbank, but I want to
>> > show
>> > the Year End value for Burbank in 2005, 2006, and a 2007 projection,
>> > but
>> > they
>> > are three separate records in my query. If statements will only grab
>> > the
>> > first year and subreports slow down the report a ton just for one
>> > value.
>> >
>> > Thanks,
>> >
>> > BJ
>>
>>
>>

"Ben Watts" wrote:

> You could always use a case statemnt for each year in your select statement.
> "bjkaledas" <bjkaledas@discussions.microsoft.com> wrote in message
> news:D0704272-4328-44F9-8902-55CE36C704A8@microsoft.com...
> > Is it possible to display three different record values in one grouping
> > header? For instance, I have End of Year values for three different
> > records
> > for a grouping called Burbank. I am grouping by Burbank, but I want to
> > show
> > the Year End value for Burbank in 2005, 2006, and a 2007 projection, but
> > they
> > are three separate records in my query. If statements will only grab the
> > first year and subreports slow down the report a ton just for one value.
> >
> > Thanks,
> >
> > BJ
>
>