September 4, 2013 at 7:10 am
I have a report with say for eg 13 Charts
I have 3 parameters setup which are cascading
DataCentre
Instance
DriveLetter
So in my main dataset I have the following query
Select *
from xxxx
Where (DataCentre IN (@Datacentre)) and (Instance@(Instance)) and (DriveLetter IN (@DriveLetter))
I have 3 other datasets which give me ‘Datacentre’, ‘InstanceName’ and ‘DriveLetter’
So here is my issue ……….all instances have different amounts of drive letters for eg one instance may have 13 drive letters and another 11 drive letters
I set up 13 charts in design and use filters on each chart so that this can be as dynamic as possible
The problem I have is that when I select the instance which only has 11 drive letters i get an error of ‘Failed to evaluate the filtervalue of the chart 'Chart12'’ because there is no data to be passed to the 12th Drive Letter parameter
There must be a way of telling the chart to ignore that chart if the parameter has no data being passed to it......conditionally hiding the cahrt also gives me the same error.
September 5, 2013 at 6:11 am
The best way would be to not have hard-coded charts but to dynamically add the charts dependednt upon the data. To do this create a subreport which contains the chart given parameters for data centre, instance and drive.
On the main report use the data centre and instance as parameters and a query to return all drives for that combination of parameters. Add a table that holds a subreport passing across the data centre, instance and drive letter as parameters.
This would accommodate 0 to n drives.
September 5, 2013 at 7:15 am
Thanks for that Mark
I have managed to get round the problem but it has other flaws!
I will give your solution a try
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply