Lounge - RDLC Report print at the page footer - Asked By Emilio Pérez on 31-Oct-11 07:19 AM

How can i add a table at page footer? I cant add table at the end of the report but i can add tables at the body of the report. If i add a table at the body, i am not able to print this table at the bottom of the page. Is that posible? I mean, i did this in crystal reports with less problems...

Thanks!
Jitendra Faye replied to Emilio Pérez on 31-Oct-11 07:40 AM
Yes you can add table in crystal report footer as you are adding.

youyr problem is that you are not able to print that table.

this is because of Bottom margin, first set proper margin for that report, after that try to print.

Emilio Pérez replied to Jitendra Faye on 31-Oct-11 08:18 AM
Thanks for reply me.
I dont understand... i cant add a table at the page footer (right button -> insert and i cant add a table). But i can add a table at the body (right button -> insert -> table).
The report has margin (2,2,2,2).
One example about what i want:

title
----

register 1
register 2

(after these 2 registers i want to show a table at the end/bottom of the page)

total 1
total 2
total 3

thanks!
Emilio Pérez replied to Jitendra Faye on 31-Oct-11 08:32 AM
Thanks for reply me.
I dont understand... i cant add a table at the page footer (right button -> insert and i cant add a table). But i can add a table at the body (right button -> insert -> table).
The report has margin (2,2,2,2).
One example about what i want:

title
----

register 1
register 2

(after these 2 registers i want to show a table at the end/bottom of the page)

total 1
total 2
total 3

thanks!
Reena Jain replied to Emilio Pérez on 31-Oct-11 09:47 AM
hi,

I am doing it like this. Just try it in your scenario and let me know

1. Create a new table in your database called TableOfContents.
Create three fields in this table:
· Grouper (String data type)(Ensure this field is at least as large as your longest group field value)
· Page (Number data type)
· DateTime (DateTime data type)

2. Assign rights to write to, delete, and update this table to any users of this report. The TableOfContents table will be updated as the report changes.

3. On a grouped report (for this example the report is grouped on the ProductName field), in the 'Insert' menu, click 'Subreport'.
Name this subreport 'Table Of Contents'.
Connect this subreport to the new TableOfContents table and insert the TableOfContents.Grouper and TableOfContents.Page fields in the Details section.
Sort this subreport by the TableOfContents.Page field.

4. Insert the 'Table of Contents' subreport in the Report Header section.

5. Right-click the gray area to the left of the Report Footer, and then click 'Insert Section Below'.
There will now be 'Report Footer a' (RFa) and 'Report Footer b' (RFb).

6. In the Main report, on the 'Insert' menu, click 'Subreport'.
Name this subreport 'UpdateTOC'.
In the 'Database Expert' dialog box, browse to your Table of Contents data source, then double-click 'Add Command'.
The 'Add Command to Report' dialog box will appear.
Emilio Pérez replied to Reena Jain on 31-Oct-11 10:09 AM
I have to do this with my RDLC report right? I'm not using crystal reports.
Emilio Pérez replied to Reena Jain on 31-Oct-11 10:10 AM
I have to do this with my RDLC report right? I'm not using crystal reports. I think you are thinking of crystal reports and i'm using RDLC reports (reporting).