February 21, 2012 at 9:58 am
Hi everybody
This is a real 'end of the day, it's probably time I went home' type of question.
I have a dataset (Dataset1) which has the following data within it:
MEASURE VALUE
ONE GREEN
TWO RED
THREE AMBER
FOUR RED
In my report I have a basic table. I want to bring back the value of MEASURE ONE on the first line in the table and the value of MEASURE THREE on the second line of the table. When I have tried to reference the dataset in my table it always brings back all rows of data which is not what I want.
Can anyone provide pointers?
Cheers
BO
February 21, 2012 at 10:52 am
Apply a filter on the table itself?
February 21, 2012 at 11:01 am
If you need all rows for some reason (you have a chart or something else that uses all rows) then a filter as Martin suggests is probably the way to go. However, since you did not state that you need all the rows to be returned, why not just rewrite the dataset query to return only the data you need?
February 21, 2012 at 11:03 am
Brilliant - works perfectly!
Thanks Martin
February 21, 2012 at 11:05 am
Daniel Bowlin (2/21/2012)
If you need all rows for some reason (you have a chart or something else that uses all rows) then a filter as Martin suggests is probably the way to go. However, since you did not state that you need all the rows to be returned, why not just rewrite the dataset query to return only the data you need?
+1 on Daniel's point...never return more data than you need on the report. You will regret it later...
February 21, 2012 at 11:05 am
Daniel - I could re-create the datasets as you both suggest and may end up doing so in the end but wanted to see if there was a different method of doing it..
Cheers
BO
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply