January 20, 2011 at 8:09 am
I am in the process of creating a report which has its data being pulled up from two databases ...
the problem is that the data has to be grouped based on the column 'Category' - and the details under each group is based on a different condition and I dont seem to find a way to do that...
how the report should look:
Sales---------- Return-----------Gross
CategroryName
Details1------------> (Cond1)------ (Cond2)--------- (Cond3)
Details2 -----------> (Cond4)
The information that needs to be displayed for Details1- sales is based on a special type of data and
same is the case for details1- return , details2 - return and so on......basically each information that needs to be displayed is different . I can write a special select statement for each of these values by creating multiple datasets but not sure if that the correct manner in which it should be done.
January 22, 2011 at 9:15 pm
You can replace the values ie green, blue or red below with another iif statement.
=IIF(Fields!PctComplete.Value >= 10, "Green", IIF(Fields!PctComplete.Value >= 1, "Blue", "Red"))
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply