TOPIC: Reports Not updating

Reports Not updating 12 May 2015 17:32 #1948

  • Steve.Beck
  • Steve.Beck's Avatar
  • Offline
:( We have set up three separat reports in Crystal Reports and have configured actions for each in Solution Builder. We have the actions scheduled to run every night and they do run as scheduled. The problem is that the only thing that updates is the report date. The content of the reports doesn't change. We tried turing off the "Save Data with Report" option in Crystal Reports and made sure that each action has the the proper database login information, but then when we run the action in the Solution Builder, we always get a "Failed to open connection message"
The administrator has disabled public write access.

Reports Not updating 12 May 2015 18:29 #1949

  • bellis
  • bellis's Avatar
  • Offline
So you have them setup as 3 separate RRDs? And it errors in solution builder?

What type of database?
The administrator has disabled public write access.

Reports Not updating 12 May 2015 18:42 #1950

  • Steve.Beck
  • Steve.Beck's Avatar
  • Offline
Yes. One RRD for each report

the database is SQL Server 2012
The administrator has disabled public write access.

Reports Not updating 09 Jun 2015 19:35 #1970

  • mholbrook
  • mholbrook's Avatar
  • Offline
My best guess here would be it was only running before because it was never hitting a database just displaying saved data. Please ensure you have an odbc setup that is 32 bit(there is a difference in how you locate it) and that the datasource name EXACTLY matches the datasource name in the report. Thanks!!

Matt
The administrator has disabled public write access.