Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FredHelm

    Automatic passing of parameter to SP Oracle possible?

    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
  2. FredHelm

    Extracting data from APS database directly

    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...
  3. FredHelm

    How to determine the CE service pack level?

    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
  4. FredHelm

    How to determine the CE service pack level?

    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...
  5. FredHelm

    SQL 2000 Query Engine Error

    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...
  6. FredHelm

    SQL 2000 Query Engine Error

    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...
  7. FredHelm

    SQL 2000 Query Engine Error

    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...
  8. FredHelm

    rptserver.asp - RenderTotallerHTML Deprecated function?

    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...
  9. FredHelm

    Crystal Report 10 with Web

    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...
  10. FredHelm

    Problem with CR9 and Kyocera KM6230 Printer

    Ido, Thank you very much. Your suggestion of turning on the option of downloading fonts as images in the printer driver worked. Fred
  11. FredHelm

    Procedure expects parameter which was not supplied

    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...
  12. FredHelm

    CPEAUT Error Occured on Server. 20609 : Creating data source failed.

    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...
  13. FredHelm

    Checking the Windows Registry for installed Crystal Reports Version

    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?
  14. FredHelm

    Problem with CR9 and Kyocera KM6230 Printer

    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...
  15. FredHelm

    Cannot print in Crystal 10

    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...
  16. FredHelm

    Problem opening 8.5 report in ver 10

    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...
  17. FredHelm

    "Failed to open rowset" when running 8.5 report in 9.0

    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...
  18. FredHelm

    Subreports - Change Subreport Links Resets all the time

    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
  19. FredHelm

    Running CR 8 and CR 10 on the same Machine

    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...
  20. FredHelm

    Crystal Reports 8.5 Vs 10

    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...

Part and Inventory Search

Back
Top