Not Support error in Crystal Report 8
Hi,
ive got the attached report which takes quite a while to run but after about 2.5hrs, the reports errors and displays Not Support.
Its run in the past back now when Ive run it today, it chucks this error.
Any ideas?
Windows 2003, SQL 2005 and Goldmine Corporate.
Report-v2.rpt
ive got the attached report which takes quite a while to run but after about 2.5hrs, the reports errors and displays Not Support.
Its run in the past back now when Ive run it today, it chucks this error.
Any ideas?
Windows 2003, SQL 2005 and Goldmine Corporate.
Report-v2.rpt
What is the error message Screenshot?
Is this a GM standard report or did you create your own report?
mlmcc
mlmcc
ASKER
Running the report from my machine using the crystal designer software. Its a report Ive desgined myself and the error simply says Not Supported. I will run it again and get a screenshot for you.
The report uses two datasources, so one obvious guess would be that it has something to do with that, because there are some things that CR won't support/allow when you use multiple datasources. But if the report has been working with two datasources, then I don't know why you'd start getting an error now.
I suppose if nothing else, you could try making a copy of the report and removing one of the datasources and seeing if it will run with just one.
James
I suppose if nothing else, you could try making a copy of the report and removing one of the datasources and seeing if it will run with just one.
James
That is one thing that to the best of my knowledge you cannot do in an application is use 2 data sources in a report unless you use subreports.
mlmcc
mlmcc
That's not true. You can use multiple datasources
However in older versions of gm the crystal runtime had restrictions built in by crystal. This was a licensing issue and they would only allow gm tables in reports run from goldmine. When I have ever produced reports for clients that had foreign tables or used other datasources I used a crystal viewer to run the reports outside gm. I believe in this case it's your view
I would suggest you look for one or even try my version available from my web site.
However in older versions of gm the crystal runtime had restrictions built in by crystal. This was a licensing issue and they would only allow gm tables in reports run from goldmine. When I have ever produced reports for clients that had foreign tables or used other datasources I used a crystal viewer to run the reports outside gm. I believe in this case it's your view
I would suggest you look for one or even try my version available from my web site.
The issue through an application is attempting to change the data source location through code. Even though using multiple data sources worked Crystal didn't support it until CR9 and even then their support was limited to the data source type like all had to be MS SQL or MS Access.
Their recommendation has always been to use a subreport for the second data source. That may have changed with CR 2008 or 2011 which I havent used extensively.
mlmcc
Their recommendation has always been to use a subreport for the second data source. That may have changed with CR 2008 or 2011 which I havent used extensively.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Changed the view to contsupp and all is good. thank you GMG.
mlmcc