list footer

[barrysaab]

I have list report with relational data source, and i have columns product line,product name,order number.my requirement is to break the list on every order number and and on that list footer should appear like  total sales,and i want footer to appear in every new list with each order number.could you guys please help me.thanks in advance

[PRIT AMRIT]

Does your list report has any 'Measure' column?

I mean Order No, Product Line, Product Name, Measure(Amount)? Or you are not displaying the Amount for each Product Name in the report?

[barrysaab]

Thanks Prit,i do have measure columns such as quantity and revenue.

[PRIT AMRIT]

Then you can straight away apply the grouping and it would automatically create footer under each Order NO and the summary for that... What's the issue?

[barrysaab]

Thanks Prit,actually what i want is break the list rows like i want to add few lines of additional textual information between the rows.when i apply section on order number and add list footer and overall footer ,the list container is still intact ,the rows simply doesn't give enough space.sorry if i couldn't explain it clearly.

[PRIT AMRIT]

Do you mean, for every Product Line you would like to add some Textual Info. with another row?

Can you try something below?

Create another Data Item 'Text' with an expression

Case when
[Product Line] ='X'
then 'Msg a'
[Product Line] ='Y'
then 'Msg b'
[Product Line] ='Z'
then 'Msg C'
----
---
----
end

The place this 'Text' item beside Product Line in your report and also section it. You would see another row with textual info for that prodcut line. You may format it to look better.

---------------
If your Textual Info. is the same for all the Product line, Unlock the report, drag a 'Block' object and place it under the sectioned Data Item. You may also insert a table. I believe this should give you enough space? You can do a bit of formatting to show the list container is not intact?

[barrysaab]

Thanks,Prit.much appreciated.