tsql - Data parameter ranges for Start and End dates -
i have req include start , end date such user should pick date range.
start date includes null.
i created parameters date/time , allowed null in start date parameter.
also, placed filters in tablix these filters.
my issue when select start , end date range don't see data in report.
main dataset: select col1, col2, start_date, end_date, col3 table dataset 1: select distinct col1 table dataset 2: select distinct col2 table (col1in (@param1)) order col2 dataset 3: select distinct col1, col2, col3 table (col1 in (@param1)) , (col2 in (@param2)) group col1, col2, col3
any inputs/ideas/suggestions appreciated.
you'll need outer join against calendar table contains dates in query range. way, you'll see dates in results if there's no corresponding measure it.
Comments
Post a Comment