Main report type is precision design, sub report is auto design
how could i create a drillthrough report on precision design
Main report type is precision design, sub report is auto design
how could i create a drillthrough report on precision design
If you’re looking for documentation, read How to: Add a Report Drill Through Action on a Report (section To add a report drill through action (precision design)).
If you have some particular problem with it, please explain what it is.
Ok Martin, I am out of office now. Tomorrow I’ll check and tell if I had issues, thank you Martin
Hi Martin, Good Morning.
1.Click Go to report and then click the Specify a report Expression (fx) button to open the Expression dialog box.
Specify a report for the report drill through, like ReportProjectName.ReportDesignName.
In above mention i didn’t know what they telling…
My soln name is Customer Transaction
precision design name is CTBase
drillthrough had autodesign CTDetails
how i need to mention this (ReportProjectName.ReportDesignName) format for my report, i’m getting error.
2.To pass data to the drillthrough report, use the parameters that are listed in the
Use these parameters to run the report section.
Click the Value Expression (fx) button to open the Expression dialog box. Write an expression that conforms to Visual Basic syntax for the parameter value. For example, to use company as a parameter, set the Name field to AX_CompanyName and set the Value property to =Parameters!AX_CompanyName.Value and click OK.
In here i didn’t get any Name field like AX_CompanyName or nothing
could u suggest an answer for this 2 questions…
Thank you.
Please never say just " i’m getting error". Tell us what the error says and when exactly you get it.
Also, what exactly do you mean by “i didn’t get any Name field”?
While build the solution I’m getting
------ Build started: Project: CustomerTransaction, Configuration: Debug Any CPU ------
\SSRS Reports\Reports\CTBase : error AX3028: CTBase.PrecisionDesign1.: Could not resolve drillthrough target report CustomerTransaction.CTName.
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
You said that the precision design name is CTBase, but the message shows that it’s called PrecisionDesign1. CTBase is the name of the report, not the design.
So your target design is probably something like CTName.AutoDesign1, isn’t it?
I find the way from yourlink Martin, I did my report as Autodesign and finally convert into Precisiondesign, now its working perfectly…
Thanks for your kind help Martin, If i had further i get it to you…