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