Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Question about non visible fields.

edited February 2003 in End User
Hello,

I am testing version 7 of ReportBuilder Enterprise for my company, but I
have found the following problem.

If I want to calculate with some database fields, but I don't want to show
them, how do I arrange that? If I set the fields on non visible, then they
will not be printed, but the space is reserved for these fields. I don't
want that to happen, I just want to calculate within my report without
showing te detailed data. From my calculations within the report I will show
the user my results!

I don't know if it is important for you to know that I am using multiple
sub-reports in one report, but just in case, I am using subreports.


Thanks in advance and best regards,


Mischa E.J. Hoogendoorn

Comments

  • edited February 2003
    Can you perform the calculations in SQL? This is one way to tackle the
    problem. Perhaps some stored procs on the database would help?

    If you don't wish to do that, then use TppVariables in the report (I think
    this is what you are doing already). Set them to Visible = False. Their
    OnCalc events will still fire even if they are not visible. Then you can
    display the values in the report conditionally by toggling the visible
    property. However, you want to get the behavior where you have left to right
    shifting of the layout components in the band? You say you are using
    subreports, does this mean that you want to shirnk the detail space used to
    zero and just have summary info printed?

    This is easy. Drop the variables in the summary band of the subreport. Then
    shrink the detail band of the subreport to zero height. Now the detail band
    of the subreport should not use any detail space, and only pritn the summary
    band with its calculations. The TppVariables do not need to be in the detail
    band in order to calculate on every traversal. The report engine tells them
    to fire, so they can be in any band in the subreport and they should fire
    correctly.

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited February 2003
    Thanks, this works! (sorry for the late reply, you are starting there the
    same time we go to home)

    Best regards,


    Mischa E.J. Hoogendoorn


This discussion has been closed.