Print SSRS dynamic query ranges on the report with simple query

(1) Share

Report

Posted on by Basti Aurand

268

I want to print the query ranges which are entered by a user when running a query based report. As I understood from Martins explanations in https://dev.goshoom.net/2014/09/showing-dynamic-parameters/ this could be easily done in the DP class of the report. So I want to try to switch to the data source type "Report data Provider" instead of "Query":

Im just struggeling how I should add the two different DataSets to the DataProvider Class:

1. Tmp Table with query ranges as explained in the blog

2. My simple query called "...InventTransListQuery" which could be adjusted by the user in the report dialog

Do I have to create a second tmp table for the result of the simple query even when the data is copied 1:1?

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Layan Jwei 8,266 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Basti,

I'm not sure why you want two different datasets (can you please explain further)

you just need a tmp table, query, controller class and RDP class (ui builder and contract are optional based on ur requirement)
you just need to add [SRSReportQueryAttribute(queryStr(YourQueryName))] to your RDP class

maybe check if this link helps
https://medium.com/@RamzanLilla/how-to-create-ssrs-report-using-aot-query-in-dp-class-in-dynamics-365-fo-14f880b7e685

Was this reply helpful? Yes No
Basti Aurand 268 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Layan,

the report basis originally is only one dataset (-> Query with join: InventTrans and InventTransOrigin).

Due to display the query range values, which are defined by the user on the query, the second dataset is needed (tmp table with query ranges as described in Martins blog post).

Maybe you have a different solution?

Was this reply helpful? Yes No
Basti Aurand 268 on at

Like
a
(0)

Report
Copy link

Link copied!

Any ideas on this?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,992 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You'll indeed need a temporary table for the fields from InventTrans and InventTransOrigin that you're going to show in your report.

Was this reply helpful? Yes No