Displaying a ReportNet list based on Conditional Formatting (I think!)

[JGirl]

Hi,

I have a report that has 5 lists. The first list is being sourced from the employee master table, and the other 4 lists are being sourced from tables that contain employee measures. The report is run with an employee number prompt, and the parameter from this prompt is what links the report lists together.

At the moment, if the employee has no measures in one of the lists, nothing is being displayed. If there are measures, then the appropriate rows are displayed. What i want to do is show the data where it exists, and when it doesnt, i want to show the text "No Data Available".

Is anyone able to give me (simple) instructions on how to do this?

J

 

[SivaSivaSivaSiva]

J,

1) Create a new report and select any column (Say ProductLine, ProductType)
2) Group on ProductLine.
3) Go to Query Explorer and Select Query 1.
4) Select the ProductType under Facts and change the Expression from the Properties to Count([Producttype]) and change the DataItem Name to vCount.
5) Now Drag and Drop the vCount from Facts to Dimension under ProductLine Level.
6) Go to Page Design and Add ProductLine Footer.
7) Insert Conditional Block control in ProductLine Footer.
8) Create one variable

Variable Name Expression
vHide vCount>0

9) Select the Conditional block Property in conditional block control and insert the variable vHide.
10) Set the Current Block Value to NO and Insert Text Item "No Message" inside the Conditional Block control.
11) Now Set the Current Block Value to YES and Run the report.


Regards,
Siva