Skip to Content
author's profile photo Former Member
Former Member

All data disappaers from report when fourth data table is added?!

I've designed a report in CR XI that relies on a stored proc and two additional linked sql tables. Everything works great in this configuration.

BUT, when I add one more data table (a fourth data source), no data appears in the report. The link between this newest table and the other tables is a good join: I've verified it in sql, in Access, etc...

I even attempted to "work around" the problem by adding a subreport that is based on the new sql table, instead of including the sql table to the main report. Unfortunately, the subreport approach yields the same problem of no data displaying in the report.

Is there some sort of limitation on how may data sources can be used in a CR report if one of the sources is a stored procedure??!

Thanks in advance for any assistance with this problem,

--Pete

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2008 at 04:11 AM

    4 data sources should not be an issue... When you add the fourth data source, how are you linking it to the others? can you create a report using just the new datasource, and does it return records ? You say you have a good join, you may want to verify that. Is if a left outer join to the main table ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.