Good morning Mega-Minds! I’ve created a method in a Dashboard button click event that creates a new quote with a selected ProjectID, and then it adds parts to the quote. I also want it to automatically run the SSRS report for the quote as a PDF, then copy that PDF to a folder. I’ve got the quote cre…

Because you are using the adapter that byte array is not a base64 encoded string, so you don’t need to do toString or anything else just cast to a byte array. File.WriteAllBytes(@serverFile,(byte[]) rptRow["SysRptList_RptData"])

Please don’t ever connect to the database from the client. That is a supremely bad idea particularly for security, upgradability , maintenance, and everything in-between. You can accomplish the same by running a BAQ.

How would you run a BAQ from that code block?

There are a ton of examples of this in the forum. [image] Grid Property Changed ERP 10 That sounds amazing…and a little over my head…So I am already populating the grid with a dynamic query and BAQ. How would I say BAQ Data View instead? DynamicQueryAdapter dqa1 = new D…

Thanks Jose! I get that I can create a BAQ to get the info I need from the database table. But how do I get the PDF of the SSRS report? Ultimately, all I’m trying to accomplish is running the report with the new quote number that’s created and then generate a PDF file that can be placed in the quote…

You need to the the bytes out of the RptData field and write them to a file like you are doing.

Jose answered that here: Trigger ARInvoice Generation from API - not totally getting it

As I am following along, I am able to get the RptData and convert it to a base64 string and then when I plug that into the base64 guru converter from Jose’s video, it shows me the PDF file that I was trying to get. So far so good. Is there an easy/preferred way to take those bytes and attach them t…

[image] dr_dan: For some reason, I was not having any luck actually getting the file to write to the C:\ path I specified The BPM is running at the server, so you’re trying to write to a server file location that the app server does not (and should not) have rights to. The only safe place to …

There’s a lot of steps in that video that just won’t work for what I’m trying to do. I need it done all programmatically because this will be for Project Managers who don’t have enough tech experience to copy, paste, convert, etc. I just need code that will run the report, which I’ve got, and then …

Create PDF From SSRS Report And Get File

Epicor ERP 10

josecgomez (Jose C Gomez) March 30, 2022, 3:54pm 4

There are a ton of examples of this in the forum.

Topic		Replies	Views
Auto Generate/Save Report PDF Epicor ERP 10 ssrs , reports	23	12748	November 18, 2019
API to pull in PDF of report Epicor ERP 10 e10 , customization , rest , reports	36	3703	August 5, 2025
REST API - Generate Report Epicor ERP 10 e10 , epicor	5	5884	June 1, 2022
Quote save pdf to disk when quoted Epicor ERP 10 e10 , quote	3	1521	April 21, 2020
Printing SSRS from c# customization Epicor ERP 10 e10	4	2658	May 4, 2022

Create PDF From SSRS Report And Get File

Related topics