Dividing lines between questions in report

Hello
I'm using SQL Server Reporting Services 2000. I have a report with the
following details:-
Subtopic Question Answer Total %age Details %age
The query behind the report groups results on subtopic and question.
What I would like to do is put in a dividing line every time the question
changes. This will not be every line, however, since there can be up to 4
answers for each question. I am hiding duplicate questions, so the
question text only shows on the first line, although there may be 4 lines
for each question altogether.
When I try to add a separating line it adds one after every line, so for
each question there will be up to 4 lines. I only want a line to appear
when the question changes.
Can anyone help with this? It's driving me bonkers!
Many thanks
Denise CrawleyIf you include a group footer, you can create the line there.
"Denise" wrote:
> Hello
> I'm using SQL Server Reporting Services 2000. I have a report with the
> following details:-
> Subtopic Question Answer Total %age Details %age
> The query behind the report groups results on subtopic and question.
> What I would like to do is put in a dividing line every time the question
> changes. This will not be every line, however, since there can be up to 4
> answers for each question. I am hiding duplicate questions, so the
> question text only shows on the first line, although there may be 4 lines
> for each question altogether.
> When I try to add a separating line it adds one after every line, so for
> each question there will be up to 4 lines. I only want a line to appear
> when the question changes.
> Can anyone help with this? It's driving me bonkers!
> Many thanks
> Denise Crawley
>|||Thanks very much, that's exactly what I was looking for.
On Wed, 8 Feb 2006 13:07:29 -0800, daw wrote:
> If you include a group footer, you can create the line there.
> "Denise" wrote:
>> Hello
>> I'm using SQL Server Reporting Services 2000. I have a report with the
>> following details:-
>> Subtopic Question Answer Total %age Details %age
>> The query behind the report groups results on subtopic and question.
>> What I would like to do is put in a dividing line every time the question
>> changes. This will not be every line, however, since there can be up to 4
>> answers for each question. I am hiding duplicate questions, so the
>> question text only shows on the first line, although there may be 4 lines
>> for each question altogether.
>> When I try to add a separating line it adds one after every line, so for
>> each question there will be up to 4 lines. I only want a line to appear
>> when the question changes.
>> Can anyone help with this? It's driving me bonkers!
>> Many thanks
>> Denise Crawley