I have created a new blank report for Subcontract shipping Label in SSRS. The standard label Epicor has uses two 4 x 6 labels on a 81/2 x 11 sheet. We are trying to print on a single 4 x 6 label maker printer and with even removing the second label on the report and changing the report size to 4 x 6, it still seems to recognize the second table on the report and shows me only every other poline.
So i made a new report and created a new Stored Procedure to create a dataset from.
The picture above shows that im currently using the @Packnum parameter to check my work, but the parameter i need to use to get Epicor to work with this report is the @TableGuid. Does anyone know how i can add this parameter to my report? Any information would be great.
When the report data is generated, the GUID for that report is stored in the Report Database. It seems to create a table for the report data, and the table/view is named appropriately from the source (I think this is from the sub report).
Here’s a report I just generated:
Depending on the archive period, this should contain the data related to that report.
If you query Information_schema in your db, you’ll find all the tables and views created for that report
Mr. Trevor: That Label uses two separate Tablix. Each row on the label uses a “Mod function” in a formula to have the left tablix show only even rows and the right tablix shows odd rows.
Remove the visibility formula from all your rows and the label will behave the way you expect.
This was very helpful, and I got my report working. I really appreciate it. I would like to still know if anyone knows how to add the TableGuid parameter. I would still like to be able to build reports in the future using it.
