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

Calc Doesn't Work

edited February 2002 in General
I am sure I am probably doing something wrong but...

I have a full name field which I calculate (lastname
+ firstname ...) in RB. I want to suppress repeated
values so I put in a counter of an Alpha field (upper
cased name which the table is sorted on). In the name
calculation I have if AlphaCount.value = 1 then
Name.visible = True else False. I get the first two
names (which are the same) showing up and the rest are
not. If I make the Alphacount visible, I can see that
the value is 1 for the first name, 2 for the second name
(which is correct as the first name is a repeat), then
1 for the next name, and so on working like I thought it
should. So I don't understand this! What is going on?
(I hope this makes sense.) Thanks.

Comments

  • edited February 2002
    Hi John,

    I think once the component is invisible the event firing is off. (in general
    one should not use an event of a component to change its own visibility, the
    band's BeforePrint event should be the right one)
    This feature isn't currently available for TppVariable (I don't know what
    component you used), but could be handled in assigning an empty String. But
    if you have the chance to concat the names in your datasource than you
    should it do there, in conjunction with the feature mentioned above.

    regards,
    Chris Ueberall;

    You know that you have the feature to suppress repeated values
  • edited February 2002
    Moving the "visibility" to detail band before print
    worked - thanks. I was using the dbcalc & setting it
    to count.

    BTW, why should I concatenate the names in the datasource
    rather than use RAP? Have I been missing something?

This discussion has been closed.