Report Field for Subtotal

Forum Forums SI5 Reporting Report Field for Subtotal

This topic contains 4 replies, has 2 voices, and was last updated by  Jordan Clark 2 years ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #6751 Reply

    Jordan Clark
    Participant

    I know this is pretty basic, but I haven’t messed with report designed in years.

    I need the field for sub total cost & price by manufacturer in a custom pick list report.

    Anyone?

    -THANKS!

    #8959 Reply

    Seth Enos
    Moderator

    Attached is a mock up of this report. You will need to unzip it and import. The screen shot below shows the basics.

    – Add your labels and fields to the GrpDynamicFooter1 section
    – For the Cost and Price fields, make sure the OUtputFormat is set to “c” (for currency) and that SummaryGroup is “GrpDynamicHeader1” and SummaryType is set to “SubTotal”

    [attachment=351]picklistscreenshot.jpg[/attachment]

    #8960 Reply

    Jordan Clark
    Participant

    Perfect. I couldn’t find the right formula. Thank you very much!

    BTW I was getting an error code on Line 29 “hide page number”. I don’t think SI5 has this command, so I just eliminated the parsing. It worked fine in SI 2015.

    #8963 Reply

    Seth Enos
    Moderator

    Oh, sorry, didn’t even read what section this post was in. SI5 is dead to me. :)

    #8969 Reply

    Jordan Clark
    Participant

    LONG LIVE LEGACY! (we are in transition (: )

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: Report Field for Subtotal
Your information:





<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">