Date displayed correctly in subreport but not in main report

jharrington · December 5, 2019, 2:43pm

I am trying to modify the SO Pick List by adding a column to the SOPickL_QtyOnhand subreport. In the subreport dataset I have linked in the PartLot table to pull in the ExpirationDate. When I supply the necessary parameters for the subreport and preview it, the ExpirationDate is displayed as expected; however, when the main rdl is previewed (SOPickL.rdl) it shows all the data in each column correctly, except for the ExpirationDate column. There is shows #error. Since this is a subreport, there is no formatting on the SOPickL.rdl, so I am perplexed.

ckrusen · December 5, 2019, 2:50pm

You sure all those parameters are passed to the sub-report?

for testing, add fields to the sub, to show each parameter.

jharrington · December 5, 2019, 3:05pm

Yep, all the parameters are being passed correctly.

ckrusen · December 5, 2019, 4:07pm

Does the sub-report use data from generated by the RDD? Or does it have its own query, pulling straight from the DB?

jharrington · December 5, 2019, 4:18pm

Generated by the RDD.

ckrusen · December 5, 2019, 4:29pm

You don’t accidentally have a default value set for any of the params in the subreport, particularly the GUID.

jharrington · December 5, 2019, 5:58pm

That is a very good question as I am known to add a default value and forget to revert it back to none, but in this case they are all set to none in the subreport.

ckrusen · December 5, 2019, 6:02pm

Any of them set to allow a null, blank, or multiple values?

jharrington · December 5, 2019, 6:06pm

No, none of them.

ckrusen · December 5, 2019, 7:39pm

Just this one Order? This one part?

Or on every instance when that that sub-report? shows?

jharrington · December 5, 2019, 9:52pm

It happens on every instance when the subreport is shown.

ckrusen · December 6, 2019, 2:16am

Is the field in the sub-report an expression or just the value from the dataset?

Try using an expression to format the date as a string.

For debugging, you could make that expression just do a test for NULL, or extract just the year, etc… to make sure there is valid data when it is processed as a whole report(not just the sub-report)

jharrington · December 12, 2019, 4:48pm

Calvin:

Sorry for the delay in getting back to you. I ran this report again from within Epicor in order to produce a new GUID in the Ice.SysRptLst to use in SSRS as the old one expired. Once I did this and added the new TableGuid to the report in SSRS, the date started to appear correctly! I have absolutely no idea what changed, but I did not make any changes to the report itself. Perhaps there was some corruption in the prior TableGuid???

At any rate, I appreciate your time and assistance for this issue. It is most appreciated.