Hi everyone;
I have a little problem. I want create new Query based SSRS report.
This is my Query;
I want add dialog based display method to my SSRS report. What can I do for it ?
*This post is locked for comments
What do you mean with dialog based? You can add a display method by creating it in the table and right-clicking the Report dataset and choosing edit. A window will pop up where you can choose the query in first step (leave it as it is) and add your new display method in the second step.
After you did that you can assign the display method to a column just like any other field and use column visibility to hide it if a specific parameter is not set.
Hi Jens. This is sample dialog;
I want send this dialog values to my ssrs reports display method.
Ex.
display Amount QtySum()
{
select table1 where table1.sozlesmeNo == mydialogfield1;
return table.exField
}
and later i drag this method to my ssrs reports table. But i could not transfer data from field to method.
Your approach to achieve this is incorrect. If you want to custom parameter dialog besides the ranges present in your "LMKBuzProjCustIncomeAndExpenseQry", you need to implement this in Report Data provider.
From there you can use your custom parameter to be displayed in your report using report designer.
Yeah it's the wrong approach. Your display method should always be connected with a query datasource and whatever values you choose in your dialog should restrict the query of the whole report and not some random display method.
I understand. Can you send me example project or referance link ?
Please check the following link:
technet.microsoft.com/.../gg731917.aspx
Also you can look into SalesNotInvoice report for reference.
We don't know your requirement. Maybe a DataProvider is not necessary. If you build a normal query report you can already define ranges when calling it with the standard 'select'-query dialog. Eventually this is already good enough for your requirement since your dialog looks like a date range filter with two other filter options.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Martin Tocauer 4
Nayyar Siddiqi 2
