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

    Passing a datetime parameter to a Sybase 12 stored procedure

    Lisa, Thanks for the info. I was begining to think I had lost my mind. That may still be true but at least I know its not because of this. If I try using the version 8.0.0.10 of p2ssyb10.dll with Crystal 7 how do you think it will behave? What versions of Crystal have you tried it with? Mary
  2. mbpierce

    Passing a datetime parameter to a Sybase 12 stored procedure

    I have a Crystal Report template from CR v7 where I am trying to pass a datatime parameter to a Sybase stored procedure. When I attempt to verify the report in the designer I get an error. When I execute the stored procedure in the Sybase client it works. Any ideas. Mary
  3. mbpierce

    SetNthTableLogOnInfo -- Propagate Main Report only?

    By setting propogate to true in this method - job.SetNthTableLogOnInfo(0,info,propagate); it's telling the server to try to use the logon info for the other tables in the report. However, if the report has a subreport,my understanding is that it only propogates the logon info to other tables...
  4. mbpierce

    Excel Images are Disproportionately Resized

    We have begun testing reports in Crystal Reports version 8.5 and exporting to Excel. The formating for all my reports, that have images in the them, is hopelessly broke. The images are coming out disproportionately resized and in the wrong place. For example, one report has a small red bulltet...
  5. mbpierce

    Changing Subreport Names

    I have modified an existing subreport and then saved it with a new name using "save as". I then insert the new subreport into the main report. However, the subreport name as it appears in the main report layout, contains the name of the original (old) subreport. How can I change this...
  6. mbpierce

    Multithreaded Application Crashed IIS HELP!!

    Our VB app is housed on the IIS server? Sharky99 suggested we post our code so some of you experts can look it over. Well, its a lot of code. I'm not sure which part is the part you should see. As I mentioned before the VB application works great by itself. We have developed a VB multithreaded...
  7. mbpierce

    Multithreaded Application Crashed IIS HELP!!

    We have developed a multithreaded VB application that we want to call from and ASP page. By itself the VB application works great. When we call it from an ASP page it crashes IIS and we cannot figure out why. Any help, guidance or input would be greatly appreciated. Mary Pierce
  8. mbpierce

    Passing a data range as a parameter.

    I have a report that takes several parameters. Some have a range of multiple possible values. To get the number of default parameters for the specified parameter I am using GetNParameterDefaultValue function. I then use this value (equal to or less than this value) as the "index&quot...
  9. mbpierce

    How to switch from a query file to an ODBC data source?

    Is it possible to take an all ready designed report, that is based on a Query or Dictionary file, and convert it to get its data from an ODBC data source? I have about 30 reports that use query files and it turns out they are more trouble than they are worth and I would like to delete the query...
  10. mbpierce

    Field Width of One Character

    Is it possible to create a report in Crystal Reports and control the field width in the RPT file for a data item as having a width of 1 Character. If so where do I set that? Thanks Mary
  11. mbpierce

    Excel Reports Appear Blank in Excell 2000 (v9)

    I am generating Excel reports that when opened in Excel v9 appear blank. My report has over 30,000 records. However, it generates a 7MB file that opens fine in Excel v8. If I resave it then reopen it in Excel v9 it open fine. Any ideas?
  12. mbpierce

    MS Word Document as OLE Object in CR doesn't work

    I am trying to place a multipage MS Word document into the details sections of a report file. When I export the report to MS Word I get empty object boxes and none of my OLE objects appear. I have tried several variations of this test and get the same results every time. Oddly enough output to...
  13. mbpierce

    Alternatives to placing images with stored procedures, into CR

    After much research, we have determined that dynamically placing images into Crystal Reports via a stored procedure is not possible at this time. Brian J. Alves kindly shared this document with me: http://support.crystaldecisions.com/kbase/c2004946.asp which was very helpful, Thank You. We...
  14. mbpierce

    Placing Images with a Stored Procedure

    I am trying to place images into my report from an SQL database via a stored procedure. I keep getting a "not supported" error in the report designer when I do a preview. Does anyone know why?
  15. mbpierce

    Displaying a blob in CR

    Same here. We are using Crystal Reports version 7. The bounding boxes for the images show, but no image is produced. We have both gifs and jpgs and the content type is stored in the database as well. We are using and ODBC connection to an SQL database.
  16. mbpierce

    BLOBs Short How To on Displaying in CR from a DB

    I have been reading some past threads on BLOBs. I have found some very helpful tips but what I haven't found is a down and dirty "how to" sort of thing. I want to place some images as BLOBs into a database, say SQL for example, and then have them display in my report. I have seen...
  17. mbpierce

    NEED HELP PRINTING!

    Do you have a print server? In the Graphic Arts Industry we print huge files all the time. We use a third party software package called Color Central that runs on an NT server. It frees up our local machines right away and lets the server do all the work. This package is designed for...
  18. mbpierce

    Section Limit in Crystal Reports

    Yes, I have a report with 26 sections and each section has a single subreport in it. The report works as long as I don't put any more than 16 subreports in it. As soon as I add a 17th subreport I get an "index out of range" error. As I understand it the section codes are as follows...
  19. mbpierce

    Section Limit in Crystal Reports

    Does anyone know for sure if there is a limit to the number of sections a report can have? What is that limit? Is there a similar limitation to the number of subreports a report can have? I would greatly appreciate any feedback in this area. Kind Regards Mary Pierce

Part and Inventory Search

Back
Top