Skip to Content
avatar image
Former Member

Adding empty line

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 30, 2017 at 05:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 30, 2017 at 07:18 PM

    Good thanx :-)

    Add comment
    10|10000 characters needed characters exceeded