i have to generate report Through the class(Without RDP/query),
and have to export the report in excel using dialog box,
if anyone have any idea please tell me i am new in ax
Hmm, what would be the source of the data if you've just excluded both options?
want to generate it directly from tables
Such a thing isn't supported. It's also a very bad idea. Don't do it.
Is there any idea to generate ssrs report and export it to excel without previewing it
or can i export data from table directly using filters using a class, will it work ?
thanks in advance
Sure, you can use "File" as the print destination. It can be done from code too - here is an example:
SrsReportRunController controller = new SrsReportRunController();
SysUserLicenseCountRDPContract rdpContract = new SysUserLicenseCountRDPContract();
// Define report and report design to use
// Use execution mode appropriate to your situation
// Suppress report dialog
// Explicitly provide all required parameters
// Change print settings as needed
settings = controller.parmReportContract().parmPrintSettings();
// Execute the report
If you want to export data from a table to Excel, you can use the data import export framework.
Writing custom code to do such things is possible, of course, but if you don't have to, don't do it. Not only you would have to spend time designing it, developing, testing and debugging, but you'd also have to keep maintaining it.