Skip to Content

There are different tables in footer

Mar 14 at 08:22 AM


avatar image
Former Member

Hello, I have a report with footer, details and header part. The question is- in footer, I have the same datasource, but there isn't all the tables. For example:

I use tables X,Y and Z in the details. But in the footer, there are only X and Z in the SAME datasource. Any ideas? Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Mar 14 at 03:29 PM

Hi Adhilash, I have a report with 3 basic sections In the third part (Footer)

For this report, I use database fields with tables which I have to use. I choose them as datasource after that linked them via joins and everything is ok. I can use the data I the whole report. For Example- I have Tables customers, sales, countries and products and I can call them as datasource. BUT in the footer part I have SUBREPORT. Where I double click it, then shows a new small form. There are info about countries, but there aren't info for sales. I want insert Sales from the database (the database is already connected) but I can't see Sales table there.

Summary: I can access all tables in the report, but I can't access the all tables when I look for them in Datasoutce
PS unfortunately I can't make screenshots from my working PS because we there is a restriction for sensitive data...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

You will not see table in SubReport Datasource as it has not been included in the SR. You need to go to database expert and then add table and join there.


Abhilash Kumar
Mar 14 at 01:13 PM


I'm not sure I understand the issue.

Please elaborate and attach screenshots if possible.


10 |10000 characters needed characters left characters exceeded