Re: AUTO GENERATE PDF

Sirfyaad · 03-26-2023 05:50 AM

Hi,

I want to create a report like this, as shown in the image below.

I want that if the sticker complete date is equal to today, then its name and QTY should be auto-filled in this report.

rmsmeltz

To create a report that shows the name and quantity of stickers that were completed today, you can use the following formula in a virtual column:

SELECT(Sticker Table[Name], [Sticker Complete Date] = TODAY())

SELECT(Sticker Table[Qty], [Sticker Complete Date] = TODAY())

This formula uses the SELECT function to retrieve the names and quantities of stickers from the Sticker Table where the Sticker Complete Date is equal to today's date.

Then, you can create a report view that includes the virtual columns and use the SUM function to calculate the total quantity.

The report view should look something like this:

Sticker Report of =TODAY()

Name Putaway Qty
Rahul kumar 23
Vivek Yadav 20
Pinky khanna 50
Rajesh kumar vadav 12
Total 105

Note: Make sure to replace "Sticker Table" with the name of your actual table that contains the sticker data, and adjust the column names accordingly.

Sirfyaad

Please tell me which expression to put in report template.