Adding empty line

[Former Member]

Hi,

I'd like to add empty cell in a subreport according to the data.

Example of Data:

ID Name

1 Joe

2 John

5 Bill

Example of output in crystal repport:

1-Joe 2-John 3-<Empty> 4-<Empty> 5-Bill

Any idea?

Best regards,

Hugo St-Louis

[former_member292966 · Accepted solution]

Hi Hugo,

Crystal can't insert a record into a report if that record doesn't exist. To work around this, have a lookup table that has all of the IDs. Link the lookup table into the report or in a view using an Outer Join. Now you should get a record for each ID regardless if they are assigned to a person or not.

Good luck,

Brian

[Former Member]

Good thanx 🙂