Hi,
Check out the following kbase article which will lead you to a white paper on how to use Oracle Stored Procedures.
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2001157&sliceId=&dialogID=16126945&stateId=1%200%2016124711
Fred
I had the exact same question as you. Your are going to have to use the CE SDK to gather the desired information as it is stored in the Binary field.
If you installed the Crystal Enterprise web samples, you can use Query Builder which uses the CE SDK and submit the following "Crystal...
I found another spot under c:\Program Files\Crystal Decisions\Enterprise10\Patches.
If anyone else has another location to check, could you kindly let me know?
Thanks
Hi,
I want to confirm that when I applied service pack 3 to my Crystal Enterprise 10 server that indeed it was applied correctly. If I log on to the Crystal Management Console and look under the Settings link, I notice the Product Version field. It did not change after applying the sp. Is...
I solved the problem. It seems that because I used table variables I believe the system procedure sp_sproc_columns could not enumerate the table variable columns because such a table only exists in memory at the time of execution of the stored procedure whereas a temp table physically gets...
Thank you for finding the article. It seems that it might solve the problem. I wanted to keep this post simple that's why I did not want to indicate that I have this error in CR 9, 10, and XI for the identical rpt file. All the parameter data types are varchar. My stored procedure is also...
This thread is in reference to thread 766-842225. "Query Engine Error: '22018:[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the nvarchar value '%' to a column of data type int.'"
Tom (misuser), how did you solve the problem?
A bit of background. I have a report based...
Do you display reports over the web using ASP? Did you start developing your code with the sample projects available on the Business Objects website? Have you started to dig deeper into the rptserver.asp to determine how an rpt makes its way to the web browser? I guess now rptserver.asp has...
Take a look at this pdf document to see if your crystal reports web server is setup correctly (the viewer virtual directory) and if your workstations have enough permissions to install the ActiveX plugin...
Jim,
This issue sounds familiar. Turn on the SQL Profiler. Using the SQLProfilerStandard template add one more event called RPC:Starting found under the Stored Procedures group. Remember to apply the login user and database filters otherwise you we log all events to your database server...
Are you using CR Version 7 installed on the web server? It seems odd that changing the record selection formula would cause a create datasource error message.
Are you using ASP to display your report over the web?
Which COM object interface are you using?
Are you manipulating the rpt...
I was planning on having InstallShield detect the appropriate version. The reason that the edition is important is because my program uses the RDC which is only available in the Developer and Advance editions.
Can installshield search for the file that you mentioned?
Did you get this one solved? I have a Kyocera Mita KM-5530 and the printer driver is installed on a Windows 2003. I am using the CR10 RDC to display the report in the ActiveX viewer. I am puzzled as to where to start to troubleshoot this problem. I have successfully printed to the printer...
When you log on to the server, logon as the anonymous user of the web site. If there are no printers available to print to then you might have found your problem. I am assuming that you are trying to do server side printing.
It is not much but I hope I have given you a push in the right...
This is not an error. Under the Options or Report Options menu items there are 3 checkboxes that should be considered. They are "Verify On First Refresh", "Verify Stored Procedures On First Refresh" and "Verify When Database Driver Upgraded" If you uncheck these, crstal should not be...
Depending on the version of the database driver, the outer join syntax might not be created correctly. Take a look at the database query sent to the database from CR. Under database, there is a Show Database Query option. If you can't see the database query you might want to try to logged the...
You might want to create parameter fields in your subreports and link to the main report through the parameter fields instead of the ones that crystal generates.
Fred
I don't have this exact set up, but I do have CR 8.5 and CR 9 on the same machine. My understanding is that CR 9 and 10 install in side-by-side mode.
I'll be curious if someone has installed CR7 and CR9 on the same machine and still has access to both? I just have not had the time to try...
Ido or anyone else,
In the news that you have read, was there any mention about the license resrictions for the next release of Crystal Enterprise (CE)? My understanding is that SQL Reporting Services has unlimited user licenses when it come to scheduling and viewing reports whereas the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.