The most recent content from our members.
Hej, I’m facing an issue when trying to retrieve values using an SQL query inside the Get Alternative Report hook. The report has multiple variants, and based on a business requirement, I need to dynamically select a specific report variant within this hook. However, the SQL query does not return any data from the report…
I'm creating a designer report for a customer, showing the total sales per month, grouped by the Store Location's name. I'm using the RSUM function to show a rolling balance, but the total does not reset with the new Store Location, it just continues by adding the previous store's rolling balance. Any suggestions? please…
Hi SunSystems Community! I’m trying to generate an XML file output from a report similar to Account Listing (FTAL1) using an XSL transformation. Here’s what I’ve done: Set the XSL Transformation file under Report Properties Set runXSLTransformation and outputToFileSystem parameters to True Stored the .xsl file in the same…
Hi I've created a report which generates from the SLJobRoutes IDO and based on the inputs users add to a filtering form. The report generates 1 page for every job listed (based on what the user inputs in the job number from and to filter). It also only generates it only for operation 10. So literally only 1 report is…
It looks like you're new here. Sign in or register to get started.