Search results for query: *

I have a Crystal report (CR9) that has tables and one view in it. I've added the view via the Database Expert and linked it to one of the tables. I Verify the database but the SQL Query never joins the view into the report and I get an error that the field(s) from the view cannot be bound. If...

I'm using CR9. I have a report that displays the title of a meeting. In the database the meeting title field is limited in size so for those meetings with long titles we have put those titles in another table. My report displays the meeting title in the Page Header. I have a subreport that...

I am using CR 9.0. I have a database that has a table with a number of checkboxes to indicate a company's region or regions. I have created formulas for each checkbox to print the name of the region (ie North America). I now need to create a comma-separated list of the regions they have...

I'm using CR9 Pro with a SQL database. In my database I have a heirarchy of records like this: Headquarters (HQ) - an HQ record can have linked EMP (Employee records) as well as linked BREW (brewery records). BREW records that are linked to HQ records can also have linked EMP records. The...

Hello: I'm using CR9 with a SQL 2005 DB. My report is grouped in 7 sections for for different amounts of donations (up to $100, $101 - $500, and so on). It prints the person's name in that group if they meet the amount criteria and supresses it if it doesn't meet the appropriate criteria. I...

Using CR 9.0 I dropped a text box into my report and have added several database fields and some text to it. When I click off the field or generate the report that text box has scrunched up all the fields/characters so that you can't read them and it looks like a big blob.... Does anyone know...

I have read all of the previous posts on this topic and have followed the instructions to a 'T' and am still not getting the correct results hence this post.... I have a report in CR 9.... My main report includes company information in a group header and activity detail in the details section...

I'm using CR9 with a SQL Database and a custom view. When I export the data in my report a number of the fields are being duplicated in the export only. The display of the report is correct. If I just run the select statement for the view in SQL Management Studio it also returns the correct...

Is there a way in Crystal 9 to set the page number to a different number than the actual page number? I have a report that will be used after another report and need to set the beginning page number to something other than 1. TIA.

I have a report that is a multi-column report that is formatted to format the Groups as multi-column. I have a Page Footer that has a line and the page number. In Print Preview mode I see the line however when I send it to the printer, it doesn't print. I've tried adjusting the page size as...

I'm creating a simple letter report in CR 9.0 Professional and I have a text box that I've copied text from a Word doc into. After I click off the text box in the report designer all of the text smashes together on top of itself. If I double-click back onto the text box it displays correctly...

This post refers back to thread766-1436069. I'm using CR 9.0. I have a field that is multi-select and stores the codes separated by a comma. So, for example the field has the following: 301,302,303 There is a lookup table that stores the descriptions for those codes that I need to display...

I have a field that can have multiple values based on a lookup table. As the codes are selected they will be stored in different orders on different records -- ie Record A can have a value of 01,01.140,02 and Record B can have a value of 09,03,01.140. Because several of the codes start with...

I've got a report in CR9 that is a badge report. The badge stock is 4" x 8.5". The printer is an HP Laserjet 4250. I made my report as a one-column report. The problem is this badge stock moves into the printer from the middle of the paper tray (top of tray one). I can't figure out how to...

I'm using CR 9.0 Professional with a SQL Database. I have a multi-select field that stores codes (ie 1,2,3). I have another table that stores the code and the descriptions for that multi-select field. In my report I need to display the descriptions for those codes (ie One,Two,Three). I'm...

I am using Crystal 9.0 Professional. I have a report that is a subscription renewal notice that is a 8.5 x 14 form with four perforations (so four notices per sheet). When I print the report the first record prints correctly but the subsequent records creep up a little so that when the 4th...