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 bkrike 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: *

  • Users: clydejones
  • Content: Threads
  • Order by date
  1. clydejones

    Can't see the report

    Hi All, We're using CR9.0 and want to view the report via the web. Presently, we can see the viewer but not the report. Any ideas? Thanks In Advance, Clyde
  2. clydejones

    Executing a Stored Procedure That Expects Parameters

    Hi All, I have a stored porcedure with parameters, however the parameter values may or may not be provided. I have this stored procedure attached to a crystal report and everything works fine, but when I try to execute the stored procedure through the Query Analyzer or through SSRS, I get...
  3. clydejones

    User Session Expired Question

    Hi All, We have a frustrating and interesting problem. We upgraded from Crystal 8.0 to 9.0. We have an application that views reports via the IE browser. Some of our machines can view reports and some get "User Session Expired". Has anyone else run across this? I have looked at the "User...
  4. clydejones

    Trouble printing ID Cards

    Hi All, We are trying to print an ID card with an ID Card printer. We are using CR9.0 and an ASP with the RAS to do this. The problem is at the client's site, when we run the report thought the ASP application we see the report as an 8.5x11 in report. It prints what we expect to see on the...
  5. clydejones

    Printing ID Card via the web

    Hi all, I am trying to print an ID card via the web with a Fargo printer. The only thing is that after the card prints three more cards go through. Where do I start? The rptServer.asp? What parameters? Can't seem to access the print options to tell it to only print one page either. I...
  6. clydejones

    Memo Fields

    Hi All, I know you can print a certain number of lines of a Memo field. But, here's the question. Let's say I have a memo field that will cover 50 lines across a report, but I only have room to print 25 of those lines on an OLE object form and need to print the other 25 lines on another page...
  7. clydejones

    Can't Seem To Log On to Subreports

    Hi Everybody, I have an ASP application that runs cr 9.0 reports. The code I am using to log on to the main report and subreports here at the office is: Set DatabaseTablesCollection = Session ("oRpt").Database.Tables For Each Table in DatabaseTablesCollection...
  8. clydejones

    Report Won't Show via the WEB

    Hi Everybody, I have an ASP application that is running CR 9 reports. The viewer shows but the report doesn't. Our client previously had cr 8.5 on this machine. Any suggestions? All are welcomed. Thanks, Clyde
  9. clydejones

    User Session Expired with Crystal 9

    Hey Everybody, From my ASP application, I am getting "User Session Expired" with cr9. I've made sure the correct "rptServer.asp", "SmartViewerActiveX.asp" and the "cleanup.asp" files are in their correct places. I'm trying to send a message back to...
  10. clydejones

    Printing Without Viewing the Report with ASP

    Hi All, I am using Crystal 9 and have a report that I would like to print without viewing the report via ASP. Is this possible? If so, any help would be appreciated. Thanks, Clyde
  11. clydejones

    Disappearing Report

    Hi Everybody, At one of our client's site, this one report keeps disappearing after we try to run the report. It acts like it wants to run, but disappears. The reports are on a 2003 server. Any ideas would be appreciative. Thanks, clyde
  12. clydejones

    Problem with DateTime value in <A href> </A>

    Hey EveryBody, I have an ASP page where I am getting a recordset and dynamically building a table. Everything works fine except the field I want to use as a link is a Datetime field. The only thing I get in the QueryString is the date not the whole DateTime Value. Here is an example of the...
  13. clydejones

    Adding a text file to a SQL database

    Hi All, Just found out I need to add a text file to a SQL database with my ASP program. Any ideas where I can get some sample code? I've been trying to do a search on bulkcopy but can find any ASP examples. Any help would be appreciated. Thanks, Clyde
  14. clydejones

    SubReport Names and Count with ASP

    Hi All, With ASP, how do you get the subReport count for the main report and how do you get their names? Any help would be appreciated. Thanks, Clyde
  15. clydejones

    Crystal 9 Upgrade Trouble With Logons

    Hi all, I have a bit of problem. We are upgrading to CR 9.0. Below is the code I used to logon to the CR 8.0 reports via ASP. All reports are connected by OLEDB(ADO) for SQL Server. serverName = "serverName" dbName = "" userID = "userID" password =...
  16. clydejones

    Program Not Responding

    Hi All, I have a Crystal Report ver 8.0 report attached to a SQL 2000 Server stored procedure. When I try to run the report. It just hangs and I get the "Program Not Responding" message when I close it. I don't even have any fields on the CR form! The stored procedure runs with...
  17. clydejones

    Upgraded from Crystal 8 to Crystal9

    Hi All, My company upgraded to Crystal 9 from Crystal 8. I've gotten crystal 9 reports that are not attached to a stored procedure to come up with the Asps that I used for crystal 8 by changing the rspServer.asp, AcitveXSmartViewer.asp and including the Cleanup.asp. However, I am now trying...
  18. clydejones

    DatePart Problem

    Hi All, I'm trying to make a date from the month and year of a parameter. Here is the formula: datePart("m",{?fromDate})&"-01-"&datePart("yyyy",{?fromDate}) January 1, 2003 was entered for the fromDate parameter, I was expecting 01-01-2003. However, I got...
  19. clydejones

    upgrading problems with crystal reports 9

    Hi All, Don't know if this is the right place to ask this question, but here goes. My company is upgrading to crystal developer 9.0 from crystal developer 8.0. Our reports were created connecting to MS SQL Server databases via OLEDB. The problems lies in trying to run the new reports...
  20. clydejones

    See Viewer but no Report with CR 9.0 via the web

    Hi All, I'm of need in a desperate way. We have upgraded one of our clients to CR 9.0 from CR 8.0. After changing the rptServer.asp, the SmartActivexViewer.asp and adding the Cleanup.asp. We are able to see the viewer, but no report. The viewer just hangs there like it's trying to bring up...

Part and Inventory Search

Back
Top