@ssrs
1 Topic
Need Help with SSRS Report Builder Date Parameters (Paginated Report)
I'm not having any issues using dates between my start date and end date. However I have a request to only show items outside of my start and end date. Can't figure out how I can accomplish this. My Parameters are FromIssuesCreated & ToIssuesCreated DEFINE VAR vFromIssuesCreated1 = IF(PATHLENGTH(@FromIssuesCreated) = 1, IF(@FromIssuesCreated <> "", @FromIssuesCreated, BLANK()), IF(PATHITEM(@FromIssuesCreated, 2) <> "", PATHITEM(@FromIssuesCreated, 2), BLANK())) VAR vFromIssuesCreated1ALL = PATHLENGTH(@FromIssuesCreated) > 1 && PATHITEM(@FromIssuesCreated, 1, 1) < 1 VAR vToIssuesCreated1 = IF(PATHLENGTH(@ToIssuesCreated) = 1, IF(@ToIssuesCreated <> "", @ToIssuesCreated, BLANK()), IF(PATHITEM(@ToIssuesCreated, 2) <> "", PATHITEM(@ToIssuesCreated, 2), BLANK())) VAR vToIssuesCreated1ALL = PATHLENGTH(@ToIssuesCreated) > 1 && PATHITEM(@ToIssuesCreated, 1, 1) < 1 EVALUATE SUMMARIZECOLUMNS('Issues'[Created], 'Issues'[DateIssueIdentified], 'Issues'[ISMS], 'Issues'[IssueStatement], 'Issues'[IssueType], 'Issues'[ActivityID], 'Issues'[RelatedToContractorPerformance], 'Issues'[RepeatOccurrence], 'Issues'[using_related], 'Issues'[TitleActivity], FILTER(VALUES('Issues'[Created]), (vFromIssuesCreated1ALL || 'Issues'[Created] >= DATEVALUE(vFromIssuesCreated1) + TIMEVALUE(vFromIssuesCreated1)) && (vToIssuesCreated1ALL || 'Issues'[Created] <= DATEVALUE(vToIssuesCreated1) + TIMEVALUE(vToIssuesCreated1))))Solved763Views0likes1Comment