Adding date & date range paramters to an existing SSRS report

(0) Share

Report

Posted on by Mav

Hi folks,

I have a SSRS report which is working absolutely fine , below 2 parameters need to be added to this report.

1. Created Date

2.Created Date range

(please note that Created date is available in my dataset.)

Kindly let me know how can i quickly achieve this, can this be achived by merely making some GUI changes or due to these 2 paramters i now have to create contract, DP & other RDP classes for my report.

Thanks in advance.

Mav

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

If it's available in the data set = query, I would assume that the user can add this range via the "Records to include" part of the report printing dialog.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

Thanks for the prompt reply .

I notice that user can choose 1 date in the criteria for records to include, please share how does user enter a range.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

I figured range can be by using date..date .

Only issues i see with user going to select records to include screen is

1. The query has link to sysuserinfo table, so when user go to records to include they are able to see sysuser info , is there any way i can prevent user not to see tables they dont have access to in that records to include list.

2. User may disagree as they want it to be simple, readily served & may sight going to record to include window, using .. for range etc as too technical for them, so any other suggestion.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

1. All users definetely have access to their own user info / profile so that's why they can see that table. Anyway they see the table NAME in the "records to include", they don't see the data. However if they have access to the data of the table they can anyway bring fields from that table into form grids via personalization.

2. This query approach that was suggested is free (out of the box, no development), simple, and works the same way everywhere in the system (as well as in user filters on every form / grid). It's definetely not very technical, but you need to show it one time for your users. All AX / D365 users (except perhaps timesheet / production work users) should know how to filter records - including date ranges. It's much more flexible than starting to develop new dialog fields and handling ranges in code whenever someone wants to filter by new field.

Was this reply helpful? Yes No