I have a parent report with
inline CSV1
Descr Value
Verified 1
Not-Verified 0
inline CSV2
Descr value
ChartView 0
GridView 1
Report Parameters
Id supplied to report
Verified visible selected from inline CSV1
View visible selected from inline CSV2
Months visible multi-selected from Distinct list of 'FormattedDate' in 'dsMain'
Statuses visible multi-selected from Distinct list of 'Status' in 'dsMain'
I have a stored proc taking params 'Id' and 'Verified' from parent report to populate 'dsMain' datasource.
Stored proc to be called only when 'Id' or 'Verified' change and returning data including....
Id
Verified
Date(01-mm-yyyy)
FormattedDate(MMM yy)
Status (S1,S2,S3,S4,S5)
DataItem1
DataItem2
DataItem3
DataItem4
DataItem5.... etc
I have a sub-report 'Chart' displaying a clustered vertical barchart
'Chart' sub-report is only visible if 'View' parameter of parent report is value of ChartView(0)
'Chart' sub-report to use 'dsMain' from parent report and filtering on 'Months' and 'Statuses' and sorting by 'Date'
'Chart' is grouped on 'FormattedDate' and each series is derived for each value in 'Status', value is Count('Status')
I have a sub-report 'Grid' displaying a datagrid
'Grid' sub-report is only visible if 'View' parameter of parent report is value of GridView(1)
'Grid' sub-report to use 'dsMain' from parent report and filtering on 'Months' and 'Statuses' and sorting by 'Date'
I cannot work out how to access the data source 'dsMain' from the sub-reports.
I cannot work out how to stop the stored proc from being called whenever 'View', 'Months' or 'Status' gets changed by the user.
The key issue here is the cost of running the Stored Proc when it has all the necessary data to filter and populate the controls on either of the sub reports.
The only time the data source should be refreshed is if the 'Id' or 'Verified' parameters of the parent report is changed.
inline CSV1
Descr Value
Verified 1
Not-Verified 0
inline CSV2
Descr value
ChartView 0
GridView 1
Report Parameters
Id supplied to report
Verified visible selected from inline CSV1
View visible selected from inline CSV2
Months visible multi-selected from Distinct list of 'FormattedDate' in 'dsMain'
Statuses visible multi-selected from Distinct list of 'Status' in 'dsMain'
I have a stored proc taking params 'Id' and 'Verified' from parent report to populate 'dsMain' datasource.
Stored proc to be called only when 'Id' or 'Verified' change and returning data including....
Id
Verified
Date(01-mm-yyyy)
FormattedDate(MMM yy)
Status (S1,S2,S3,S4,S5)
DataItem1
DataItem2
DataItem3
DataItem4
DataItem5.... etc
I have a sub-report 'Chart' displaying a clustered vertical barchart
'Chart' sub-report is only visible if 'View' parameter of parent report is value of ChartView(0)
'Chart' sub-report to use 'dsMain' from parent report and filtering on 'Months' and 'Statuses' and sorting by 'Date'
'Chart' is grouped on 'FormattedDate' and each series is derived for each value in 'Status', value is Count('Status')
I have a sub-report 'Grid' displaying a datagrid
'Grid' sub-report is only visible if 'View' parameter of parent report is value of GridView(1)
'Grid' sub-report to use 'dsMain' from parent report and filtering on 'Months' and 'Statuses' and sorting by 'Date'
I cannot work out how to access the data source 'dsMain' from the sub-reports.
I cannot work out how to stop the stored proc from being called whenever 'View', 'Months' or 'Status' gets changed by the user.
The key issue here is the cost of running the Stored Proc when it has all the necessary data to filter and populate the controls on either of the sub reports.
The only time the data source should be refreshed is if the 'Id' or 'Verified' parameters of the parent report is changed.