When we create a BAQ report and generate the print of the , the report name and the caption on the report comes with a name like “Baq Report ***” . How can we change this report name / caption (displayed on the PDF menu bar on the top) to a more sensible name like "Sales report " .
Did you ever find out anymore on doing this?
I am pretty sure you can edit the SSRS to change that field into anything you want.
1 Like
The PDF Filename is what I want to change on a preview.
I want to assign the UD15 Key2 as the file name before the PDF renders.
This name that is assigned means absolutely nothing to anyone…
Mike, I was JUST looking for this same thing. Not sure if this will work for you… it doesn’t for ME, but I’m SaaS and it may be a cloud/access thing. If you’re on-Prem, perhaps you can edit it…
From BAQ Report Designer > Load your target Report ID
Actions > Preview Classic Form
On the “Preview” screen there is an icon to “Generate for Design”.
After that, open your System Monitor… highlight the BAQ Report that was generated.
Actions > Design SSRS Report
SSRS Report Designer opens to show the details:
The highlighted text is (from what I can tell) what becomes the end PDF file name + (underscore) + the “Sequence” number in the first field of this form.
Again, this is all grayed out for me… but that could be because I’m a cloud customer. If you’re on-prem, you MIGHT be able to edit this??? I’d be interested to learn if that’s the case.
This is the only place I’ve stumbled on to anything that even closely resembles the end pdf file name.
I got this screen to pop up and same here that field is subdued.
I am going to chase this in the Report Data Definition and see what I can come up with.
The PDF name in the viewer is generated at runtime on the Client - the PDF itself (minus the file name) is stored on the SysRptLst table as a varbinary field. The generated name is built using the Description field and the RecSeq field from the SysRptLst record.
If you set the archive period to a day and then go to the System Monitor and select the generated report and request a preview from the SysMonitor, the PDF file name will include an additional “Counter”. the Name will be SysRptLst Description + Underscore + RecSeq + underscore + counter. I believe the counter is specific to the client workstation and the number of times that instance of the report has been viewed on that workstation.
You can manipulate the file name somewhat when using the Output to File option on the Report Style - search the forum for more information on that.
1 Like