Hi,

I want help in SSRS report development.

My Requirement is as follows:

User will provide range of Excise Invoice Number "From - To"

I need to print all excise invoice report between provided range , each on separate page.

What I have designed is as follows

1. Header
2. Detail
3. Footer

Now what happen is Header is printed, Detail is Printed and footer is also printed for first invoice number, but for second invoice number header is printed of first invoice number, detail is of second invoice number and footer is again of first invoice number.


Can refer attachment...
what is the solution for this...

Dear Sachin,
Instead of using Header use before.field and for footer use after.field.

Dear Soumya,

I don't know replica of 'Before.field' and 'after.field' in SSRS report.

Seems that your grouping in the SSRS report is not correctly defined.

before/after field is called "group" in ssrs. just right click on the body in edit mode and insert.

Hi,

I defined group on "Invoice Number", but the thing is on the change of invoice number only detail layout is changing, not header and footer,

I have been used "Table" and "Matrix" both , but no effect.

You should include the header and footer in your group scope.

Hi,

I resolve this problem, what I did is , during creation of report , it ask us to separate fields in various section such as "Page", "Detail" and "Groups", I added grouping field 'invoiceNumber' to "Page" section, instead "Group", and I got the report as I want.