Sage 100

It's Friday afternoon and I'm admittedly brain-dead. I hope one of you still has some reserved energy to help. I've modified an Open SO Report and would like to display the shipping dates selected by user from the Selection Screen on the report. Where are these parameters stored?

SO_SalesOrderHeader.ShipExpireDate

I think that's the data on the SO itself. What I'm looking for is the dates selected when you go to run the report.

Those values may be temporary variables stored in memory by the ProvideX front end program.... not saved in the field of an accessible table. Not sure if accessing that value is possible using Crystal. It may be possible to modify the ProvideX front end to expose the data in a Crystal work table.

Way beyond my pay grade!

If the parameters aren't available, you could get the effective selection by using Min(SO_SalesOrderHeader.ShipExpireDate) and Max(SO_SalesOrderHeader.ShipExpireDate)

I've needed the parameters before on a report, as well. There should be some way for those to be accessible - please, Sage?

You can enable the 'print report settings' ckbox on the report printing screen.

@BrettZimmerman - Would this work when Sage filters the information prior to building the work table? Thinking aloud.

Not sure I know what you mean. It's filtering based on the report settings/selection.

@BrettZimmerman Thanks for the info. Something I didn't know. It looks like the formula @settingslection5 can be moved into the report header or other group. When you check the print report setting box new formulas populate the work table.

Wow. Thanks for all of this. I'm going to jump back in and try. @PhilMcIntosh I tried that but it of course only displays what's actually in SO not the selected parameters. So if I selected a date range of 8/1/18 to 8/25/18 I might only get 8/3/18 to 8/24/18 as min/max values which I thought might be confusing.

Nice find, @DougHiggs. I was trying to find that Crystal piece that was creating the Report Settings cover/first page. However, it doesn't appear usable. I tried playing with it and couldn't leverage the respective formula field that you pointed out. Cast your vote: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP/Idea/Detail/38955

@BrettZimmerman @KathrynScofield Look at the first screen shot in my previous post. Make sure the 'print application report settings' is checked. Preview the report. Click the export button. Choose Crystal then application. Crystal opens with the data. You can then find the field you need and place it in the 'main' report.

That's what I was hoping to do but the .rpt that opens up is a temp .rpt and not the one within the Reports folder. I tried renaming it to the real .rpt but I got an 'engine' error, and it doesn't appear you can simply just copy that formula to the real .rpt.

@DougHiggs and @BrettZimmerman I got this to work sort of. I copied the formula to the report, saved it after hiding the report header section BUT the formula is static to the original generated preview. If I change the report selection for a different date range, that change is not reflected. Bummer. So close.

@BrettZimmerman I see what you mean. Yes. I am getting an error 88 after copying the temp report over the permanent report. It looks like we are stuck with the two pages of report settings before the report prints.