imchi
June 12th, 2008, 04:15 PM
Hi,
I have a Crystal report where the detail rows are grouped by a certain column. The detail row is suppressed. By design, the user is supposed to click on the group footer and get into the listing of detail rows.
The rows in the master page look like this:
<name> <summary of value1> <summary of value2> <summary of value3>
<another name> <summary of value2> <summary of value2> <summary of value3>
etc.
The rows in the detail drilldown page for <name> look like this:
<name> <value1a> <value2a> <value3a>
<name> <value1b> <value2b> <value3c>
etc.
Now, since <name> is always the same for all detail rows, the user wants the detail page to look like this:
<name>
<value1a> <value2a> <value3a>
<value1b> <value2b> <value3b>
etc.
In other words, make <name> the header of the page.
I tried formatting the <name> in CR by choosing the option "Suppress if duplicated". This did allow me to have the name as the header of the detail page (actually, it's printed out only in the first row).
However, on every other line the value that would be occupied by <name> is still filled out with space and an endline character. So, the data lines alternate with empty lines.
This is what I see:
<name>
<value1a> <value2a> <value3a>
<... empty row ...>
<value1b> <value2b> <value 3b>
<... empty row ..>
etc.
How do I get rid of the empty rows, or is there an alternative way of creating the header?
Thanks in advance.
I have a Crystal report where the detail rows are grouped by a certain column. The detail row is suppressed. By design, the user is supposed to click on the group footer and get into the listing of detail rows.
The rows in the master page look like this:
<name> <summary of value1> <summary of value2> <summary of value3>
<another name> <summary of value2> <summary of value2> <summary of value3>
etc.
The rows in the detail drilldown page for <name> look like this:
<name> <value1a> <value2a> <value3a>
<name> <value1b> <value2b> <value3c>
etc.
Now, since <name> is always the same for all detail rows, the user wants the detail page to look like this:
<name>
<value1a> <value2a> <value3a>
<value1b> <value2b> <value3b>
etc.
In other words, make <name> the header of the page.
I tried formatting the <name> in CR by choosing the option "Suppress if duplicated". This did allow me to have the name as the header of the detail page (actually, it's printed out only in the first row).
However, on every other line the value that would be occupied by <name> is still filled out with space and an endline character. So, the data lines alternate with empty lines.
This is what I see:
<name>
<value1a> <value2a> <value3a>
<... empty row ...>
<value1b> <value2b> <value 3b>
<... empty row ..>
etc.
How do I get rid of the empty rows, or is there an alternative way of creating the header?
Thanks in advance.