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 Chriss Miller 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: ciscowiz
  • Content: Threads
  • Order by date
  1. ciscowiz

    Reduce the # of Database Reads

    I am using CR9 integrated into a VB.NET web app. All of our reports have a main view/stored procedure and a view called v_pubinfo which supplies personal company info such as Name, Address, and the 'logoletter' which is a character (d,f,g,t,etc.). We use the logoletter in the page header of...
  2. ciscowiz

    Display Detail-A section once

    I am using CR9. My report is as follows GH1 >> CustomerID - SUPPRESSED GH2 >> TransactionID - Various fields Detail-A- Conditionally Suppressed Detail-B - Essentially another "Header" section with NO DATA. I want this section to show up only once, IF there is any data in Detail-C Detail-C -...
  3. ciscowiz

    Detail Section Overflowing into Group Footer with subreport

    Hello all - I am using CR9 with SQL Server 2000. My report is an invoice and has the details section split into A and B. B is suppressed based on a condition and A is to display the normal records. Group Footer is split as well with GF1-A holding a subreport. GF1-B essentially serves as a...
  4. ciscowiz

    Insert Null Image into SQL SERVER From VB.NET App

    I use SQL Server 2000 and VB.NET in my ASP.NET app. I am trying to insert data of type 'image', along with other data by using a stored procedure with parameter type of 'image'. I can insert the data just fine if I provide a legitimate path to an image. In other words, I know how to insert...
  5. ciscowiz

    Create A Unique Number for Reference of Invoice

    I am using SQL Server 2000 and CR9. While we do store Invoice Numbers in the DB and we have User Functions to Auto-Generate Numbers, I need this done in CR. I basically Just want to use the parameter, which is a date, and append an incremented number to the end of it. The Number needs to show...
  6. ciscowiz

    Manual Crosstab?

    I am using CR9 with SQL Server 2000. I need a report that I thought would be a cross-tab but I am getting way to many records returned. The columns are multiple instances of one field and a lone instance of another field which is probably the issue. The columns are for multiple instances of...
  7. ciscowiz

    String Parameter for an ID doesn't work with the {}

    I use CR9. I am passing a string parameter to my report that is for a uniqueidentifier in my SQL Server 2000 DB. The format of the uniqueidentifier is {00000000-0000-0000-0000-000000000000}. The report will return data just fine if the parameter is without the leading and ending {}, but if...
  8. ciscowiz

    Sort records based on formula with nested formulas

    I want to sort the records in my report by a formula which is comprised of other formulas. I want to sort on @Balance but it does not show up in the Record Sort Expert. @Balance = (@FinalCurrent + @Over30 + @Over60 + @Over90) @FinalCurrent = currencyvar xCur; xCur := (Sum ({@Past90}...
  9. ciscowiz

    Create A checklist type report

    I am using CR9 with MS SQL Server 2000. I have 2 views that pull back the correct data. The first view pulls back the Number of pages and the spreads they belong to, and it is always the same result set. v_view1 Result Set: Page Spread B01 F01_B01 B02 B02_B03 B03 B02_B03 B04 B04_B05 B05...
  10. ciscowiz

    Custom Sort Order Possible?

    I am using CR9 with MS SQL Server 2000. The data I am pulling back is for a newspaper and the field I want to sort on has values such as F01, F02, B01, B02, etc. F is for front, B is for back so in reality, the order should be F01, B01, F02, B02, etc. not B01, B02, F01, F02 as it is now. I am...
  11. ciscowiz

    Loss of Custom Font on export to PDF

    I use CR 9 with Windows 2000. I have a custom TrueType font I created to show our company logos. If the report is viewed and exported to PDF in the CR Designer, the logo shows up fine. If the report is viewed over the web via CE9, the logo shows up fine in the AcitveX viewer but on export to...
  12. ciscowiz

    On export to PDF, loss of custom font

    I use CR 9 with Windows 2000. I have a custom TrueType font I created to show our company logos. If the report is viewed and exported to PDF in the CR Designer, the logo shows up fine. If the report is viewed over the web via CE9, the logo shows up fine in the AcitveX viewer but on export to...
  13. ciscowiz

    Running Total won't display 0

    I am using CR9--I created a running total field to perform a count on a string field. On the "Evaluate" section of the running total I am using a formula where the field equals a specific string. It counts the instances of this string. Works fine unless there are no records to count. It...
  14. ciscowiz

    Text is being cut off in export to PDF

    Hello All, I am using CR/CE 9 with the activex viewer. When I export to PDF through the viewer, some text in the textboxes is cut off. If you click on the field in the activex viewer, the original textbox becomes highlighted in red and you can clearly see a couple letters spilling over which...
  15. ciscowiz

    Text is being cut off on export to PDF

    I am using CR/CE 9 with the activex viewer. When I export to PDF through the viewer, some text in the textboxes is cut off. If you click on the field in the activex viewer, the original textbox becomes highlighted in red and you can clearly see a couple letters spilling over which is exactly...
  16. ciscowiz

    Why can't I export to PDF with same results as in CR?

    I wrote about this earlier but maybe now that I have worked on it more someone can help. I am trying to export a Crystal Report v9 to PDF. The report uses a custom font for a logo. When the report is exported to PDF on Windows 2000, the logo shows up twice the size it should be. If it is...
  17. ciscowiz

    How can I Force the server to use specific print drivers?

    Heres the situation: I have a couple servers, one Windows 2000 and one Windows 2003. On the Win2003 machine, my crystal reports are converted to pdf successfully. On the Windows 2000 machine when I convert my reports to pdf my custom font does not render properly - it is too large. I...
  18. ciscowiz

    Export to PDF in .NET - Font Differences in OS's

    I am exporting reports to PDF using ASP and VB.NET but my custom font appears larger when rendered on a Windows2000 server than when it is rendered on XP/2003 server. I am thinking that since it renders properly on XP/2003 there must be different files being used between the OS's. I have tried...
  19. ciscowiz

    rpt converted to PDF - Font different between XP/2003 and 2000

    I have a custom font that is unicode/TTF I use on my reports to display a company logo. I display my reports using ASP/VB.NET with VS 2003 and CR9. When a report is viewed as a pdf in a browser window from a windows2000 server, regardless of client, the custom font appears much larger than it...
  20. ciscowiz

    Run Reports over web without Enterprise

    I developed a Web app using VB.NET and ASP.NET. I wanted to be able to display reports over the web without using Crystal Enterprise and I thought I had that accomplished until I shut down the services in the Crystal Configuration Manager (CCM) and my pages wouldnt display. The only references...

Part and Inventory Search

Back
Top