[RESOLVED] Data Report formatting

[carmenv]

Hello,

Is there any way to make a report to display blanks when number fields are having ZERO value ?

thanks

[dee-u]

One option that I could fine is to actually format your table fields before setting them to the report...

[Hack]

Moved To Reporting

[brucevde]

Use the DataFormat property of the rptTextBox control.
Select Custom from the list.
Set the FormatString to #;; ; or #;;"";

The FormatString is basically the same thing as the Format$ function, so use the different "formatting sections" to format accordingly. Section 3 is the formatting section for 0 values.

[jggtz]

Moderator :
Please delete this !

[carmenv]

That's great, thank you all, I'm starting to have hopes, because VB6 DataReport seemed very limited to me.

Another question: I have a group, and I want to print a group field only once, but on the same row with the first detail row. Is that possible ?

thanks again
Carmen

[brucevde]

because VB6 DataReport seemed very limited to me.
Compared to other report writers, DataReport is very limited. It has almost no "page" formatting functions.

It is not possible to suppress printing of a field based on a criteria. Other report writers have a "suppress if duplicated" function or suppress based on a formula.

The only work around I know is to add another column in your recordset. For every record this field is blank except for the first record of each Group.

[carmenv]

I understand....
That trick with the column should be fine.
I'm using a stored procedure to get the records, do you think it's possible to get that column in stored procedure ?
No need for details, I can do it if it's possible, I only need to know if it worth trying, or if I'd better use VB for it.
The report is very simple, a list o invoices values, grouped by customer, who's details I want to show only once

thank you