Skip to Content
avatar image
Former Member

There are different tables in footer

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 14, 2018 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...

    Add comment
    10|10000 characters needed 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.


  • Mar 14, 2018 at 01:13 PM


    I'm not sure I understand the issue.

    Please elaborate and attach screenshots if possible.


    Add comment
    10|10000 characters needed characters exceeded