Syntax for report variable

Howdy,

Reposting this topic within the correct forum (FR 4.0 - sorry about that ...)

I'm using FR 4.14.3 and I'm having problems with the syntax for displaying a report variable
(user created variable - not a system variable) within a memo.

I've attached screen shots for this report showing:
1. Setting the value of the variable within the OnBeforePrint event of a group header
2. Attempting to display the variable within a memo contained within a group footer
3. Runtime error coming from the attempted display of the group footer

At this point, I really think my problem is simply getting the "correct" syntax for the value of
the memo within the group footer - but I've tried several options (without success).

Any and all help is appreciated,

Marc B.

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 4:25PM
    have you tried using fr's built in expressionbuilder when editing the memo?
  • edited 4:25PM
    Howdy Gordk,

    Yes, I have. No success - but, Lol, I do receive a different error:

    I've attached screen shots for this report showing:
    1. Attempting to display the variable within a memo contained within a group footer
    2. Runtime error (NEW) coming from the attempted display of the group footer

    To be clear: my goal is to simply have the following displayed within a group
    footer: 1. String value of field using for grouping & 2. running total of rows within group.
    My problem is "appears" to be getting 1. to display (within the group footer - NOT the header).

    Thanks for any & all help,
  • gordkgordk St.Catherines On. Canada.
    edited 4:25PM
    what is the groupheader condition?
  • gordkgordk St.Catherines On. Canada.
    edited August 2013
    try this
    Total for Ship Type: [GroupShipType] = [Count(RepDetail)]
  • edited 4:25PM
    Howdy Gordk,

    Ah, excellent! Both a correct & simple solution - thanks for your time!

    To answer your earlier question (GroupHeader logic) and to show the
    solution, here are a couple of final screen shots (for the GroupHeader &
    GroupFooter logic).

    Thanks,

    Marc B.


  • gordkgordk St.Catherines On. Canada.
    edited 4:25PM
    glad it worked for you.
    here is a little trick if you create a lot of reports with similar categorized variables
    save the dictionary and load it when you design a new report and they will be available to use in the expression builder.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.