December 25, 2008 at 9:16 pm
hi Friends,
Am working in ssrs 2005.. here am using cube. One of my field is state_name. Am using report parameter as state_name and i have paramaterized it from cube itself.
Task :
Task of mine is to get displayed state name in my report, when that state name is selected from report parameter.
Problem :
Some state_names have no records from cube itself.
The Problem is if i select a particular state_name from the parameter , and if it has no records.. then the report wont displaying my state_name ..
for that i used,
Parameters!DIMBRANCHMASTERStateName.Label. So this problem gets over...
but if i select "All" from the state_name parameter...
the state_name gets displayed as "All" in reports..
if i use,
Fields!State__Name.Value , it displays all state_names correctly in each page but it wont displaying the state_names which has no record...
i need a solution for that..
Will appreciate your replies..
Thanks and Regards,
Sabarinathan.C
December 26, 2008 at 6:17 am
Use a separate query which returns a full list of the state_names and utilize that.
December 26, 2008 at 8:09 am
Use an Expression, something like this:
=IIF(Fields!State__Name.Value Is Nothing, IIF(Parameters!DIMBRANCHMASTERStateName.Label = "ALL", "N/A", Parameters!DIMBRANCHMASTERStateName.Label), Fields!State__Name.Value)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply