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 1:51PM
    have you tried using fr's built in expressionbuilder when editing the memo?
  • edited 1:51PM
    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 1:51PM
    what is the groupheader condition?
  • gordkgordk St.Catherines On. Canada.
    edited August 2013
    try this
    Total for Ship Type: [GroupShipType] = [Count(RepDetail)]
  • edited 1:51PM
    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 1:51PM
    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