Sage 100

 View Only
Expand all | Collapse all

It's Friday afternoon and I'm admittedly brain-dea

Doug Higgs

Doug Higgs08-24-2018 14:24

Kathryn Scofield

Kathryn Scofield08-24-2018 14:36

  • 1.  It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-24-2018 14:21
    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?


  • 2.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-24-2018 14:24
    SO_SalesOrderHeader.ShipExpireDate


  • 3.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-24-2018 14:27
    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.


  • 4.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-24-2018 14:35
    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.


  • 5.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-24-2018 14:36
    Way beyond my pay grade!


  • 6.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 06:34
    If the parameters aren't available, you could get the effective selection by using Min(SO_SalesOrderHeader.ShipExpireDate) and Max(SO_SalesOrderHeader.ShipExpireDate)


  • 7.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:00
    I've needed the parameters before on a report, as well. There should be some way for those to be accessible - please, Sage?


  • 8.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:07
    You can enable the 'print report settings' ckbox on the report printing screen.


  • 9.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:13
    @BrettZimmerman - Would this work when Sage filters the information prior to building the work table? Thinking aloud.


  • 10.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:20
    Not sure I know what you mean. It's filtering based on the report settings/selection.


  • 11.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:25
    @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.


  • 12.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:37
    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.


  • 13.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 09:49
    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


  • 14.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 12:26
    @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.


  • 15.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 12:31
    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.


  • 16.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 14:21
    @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.


  • 17.  RE: It's Friday afternoon and I'm admittedly brain-dea

    Posted 08-25-2018 15:20
    @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.