TOPIC: Question about Sub-Reports

Question about Sub-Reports 31 Aug 2016 22:34 #2400

  • ESomers
  • ESomers's Avatar
  • Offline
I am new to Logicity and and am trying to find out if the Free Version will run Crystal Reports that contain sub-reports. The sub-reports all access the same db, using the same login. When I execute the RRD or try to run the report through Logicity Desktop, I get 'Failed to Open Connection'. It uses the same db login as my other reports that run correctly.
The administrator has disabled public write access.

Question about Sub-Reports 01 Sep 2016 11:45 #2401

  • mholbrook
  • mholbrook's Avatar
  • Offline
Hello,
Is the ODBC name the same as well? If you have a full version of Crystal Reports would you mind going to the database drop down and then set location. Please take a screenshot of that window and upload it. Thanks!

Matt
The administrator has disabled public write access.
The following user(s) said Thank You: ESomers

Question about Sub-Reports 01 Sep 2016 16:17 #2404

  • ESomers
  • ESomers's Avatar
  • Offline
The DSN is the shown as the same when compared to another report without sub-reports. The DSN in the 'simple' report doesn't match the DSN in ODBC, but the report runs fine.
I added a second ODBC connection on the report machine that has the same DSN shown in the db info of the report with sub-reports, and points to the same SQL db/server. The report now runs fine in Logicity Desktop and Solution Builder.
Thanks for the help! :cheer:
Last Edit: 01 Sep 2016 16:20 by ESomers.
The administrator has disabled public write access.