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 up for either option but I'm afraid I don't know how to do either. Can you give me a little more guidance on setting th is up in my report? Thanks in advance.

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

Well, I think I'm getting closer. I don't get any errors in the formula but when I generate the data for the report I get the following error: String length is less than 0 or is not an integer. Any ideas? Thanks.

I have one table called Regions. In that table I have the following boolean (checkbox) fields: Asia Australia Canadian Territories Central America China East North Central East South Central Eastern Canada European Union Mexico Middle Atlantic Mountain New England Pacific Puerto Rico South...

Basically, I created a formula for each checkbox to print the name of it: @Region_Asia if {Regions.Asia}=True then 'Asia' else '' I have about 10 more of those. I want to be able to list them separated by commas. Hopefully that's what you're asking. Thanks.

Yes, it would be based on a group called Alpha, which just groups by company name. Thanks.

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 should have gone on to say that I need a row for each record with their Name/Company/Address information to be exported for a mailing list. I've thought of the above scenario but that won't quite work because of the need for one row per record.

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

Sorry about that... GH1 - Product Code GH2 - Amount GH3 - Last_FirstName GH4 - Up to $99 GH5 - $100 - $499 GH6 - $500 - $999 GH7 - $100 - $1499 GH8 - $1500 - $4999 GH9 - $5000 - $9999 GH10 - Over $10000 In GH4-10 I placed the Name field and then in the Section Expert under Suppress, I created...

I must be doing something wrong. Here's the sections I've got: GH - Product Code GH - Amount GH - Last_FirstName GH - Up to $99 GH - $100 - $499 GH - $500 - $999 GH - $100 - $1499 GH - $1500 - $4999 GH - $5000 - $9999 GH - Over $10000 I have the name field placed in each of these groups. I...

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

Unfortunately, that is not the issue with this. It's like it's bunching the fields in the text box all together. The text box is plenty big to display the data. Thanks though....

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

That was it! Thank you soooo much!

Thanks LB -- That got me closer as I am now at least getting a number but it's not adding it correctly. It finds the first payment activity and then continues to add that amount to the total until it finds another entry for that activity and then it adds that amount to it until the next one...

When I add the formula: whileprintingrecords; currencyvar MyGrandTotal; MyGrandTotal = MyGrandTotal + MyTotal I get an error on the 'MyTotal' -- A Number, Currency Amount, Date, Time, DateTime or String is expected here. I declared that the MyTotal was a currencyvar in the reports so I don't...

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

@NickieP - the only option similar to that in CR9 is 'Maintain Column Alignment'. I tried that to no avail.... Not sure what's wrong...