Display multiple details even if blank 1

[kurtgambino1]

My question is i have a stored procedure that populates my report but i need to print three lines on a report regardless if there is three records or not. If it is more than 3 records go to a new page. but i now the details can only show one record at a time so im not sure how to procede for example . in the ex below it returs two records for Kurt but i need to print 3 on the page but one will just have labels but no values how can i do this?

Name Amount
Kurt 100
Kurt 200

 

[Madawc]

Create a summary count for your lines, whatever they may be based on. (If you're not already familiar with Crystal's automated totals, see FAQ767-6524.) The lines will need to be part of a group.

Have two dummy detail lines, each corresponding to a single line. Suppress the first unless the summary count is 1 or 2. The second unless it is 2.

If you've not used Suppression for sections, you need to right-click on the field and choose Format Field. Choose the [Common] tab, and then the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.

@Count < 3

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP