Search results for query: *

Thanks so much for your assistance. It works perfectly for my application.

Page one has the Page Header, Detail rows and Page Footer. The grouping is done in the code and the data is stored in a data table as a string delimited by '~'. The report then parses the data to form each unique Detail row. There can be from one to hundreds of rows per group. The Detail...

I am working with Crystal v9. I have Oracle 10g datasource. Trying to "insert a blank page" after page one of the report for duplex printing. I have the following formula in in Section Expert.Page Header/Footer.Suppress: if remainder (pagenumber,2) = 0 then 'even page formula = true else...

I placed your formula in the Record Selector and it worked....did not fix the issue but I think it is much better than what I had. Well, I found out that HCID was not unique in the table so I changed the Record Selector to pull from FILENAME and IMPORT_LINE_NO, which will always be a unique...

Well, when I place a 'live' HCID in the @HCID (formula = "276A73984"), BILL_FREQ displays. If I leave the 'live' HCID in place and run the procedure to create the letters all data changes in the header information EXCEPT the BILL_FREQ. In other words, BILL_FREQ is hard-coded to the value...

Yes, all the rows imported to the table have data in them and each row has a value in the BILL_FREQ column.

Thank you for the response. As I am new to coding I can use all the insight into programming tips that I get. Nonetheless, the retrieval of rows is not really my problem right now. There is one field in the row of data that is not populating and I have no idea why. If I retrieve all rows into...

It shows up blank on preview unless I place a 'live' HCID in the formula. However, the field that does not show up actually populates. This is good and bad. Good because I can see the field in preview. Bad because it populates that same value for every record when it actually prints. The HCID...

I am using CR v8.5 Dev and v9 Pro. I have created a letter using information from Oracle 10g datasource in letter header. I run a print procedure that creates one letter per record in the data. In order to run the procedure I have to set a record selector with one of the fields in the table. I...

I am not a programming guru by any means. Now that I have said it: I have a SQL statement I use in Crystal Reports that allows me to keep the address block togehter(no spaces) when there is no information populating the 'Careof' field. I need to reproduce this statement in a Microsoft Word mail...