Show blank row - control by user.

[ngcn]

hi all,

I have this report which enable user to control whether they want to leave a blank space(row) after a certain data row in report. User can control by insert a blank item (a data which don't have Item_Desc, Qty, UOM).

But, the problem is I can't show this blank item unless user enter something in the description(Item_Desc1 field).

Here is my table structure :- Primary Key rjCode & TradeCode & GItemCode & DItemCode & RevNo. Other fields in this table : Alias, Item_Desc1, Item_Desc2, Qty, UOM.

Can anyone help me ?

Thanks
ngcn

 

[synapsevampire]

How does "User can control by insert a blank item (a data which don't have Item_Desc, Qty, UOM)" occur?

Is this from another application?

Consider posting technical information rather than text, especially given the language barrier.

Crystal version
Database used
Example data
Expected output

You can test for the existence of a null or blank data and take action, such as have a 2nd detail section consisting of the equivalent to the blank space needed, which would be suppressed unless some unless some criteria is met.

-k

 

[ngcn]

synapsevampire,

Thanks for your reply. I tried to explain again, I am using CR8.5, SQL 7 & VB6 for the report.

The situation is like this : There is no blank space after the detail section in the CR because I won't know when the user want to leave a space after an detail item. The user can control by saving a blank item (after whichever item they like) from VB. When the report detected an blank item, it'll show it (as a blank space).

example :
Alias Description Rate Qty Amt
A). UVW
1. abc 18.23 25 455.75
2. def 125.00 11 1375.00
(blank item from database)
B). XYZ
1. klm 5.10 150 765.00
.
.
.

There is no prolem getting this blank item from database, but It won't appear unless user enter a description for that item. For table structure, please refer to my original post.

Thanks a lot for any help

regards,
ngcn