Search results for query: *

Hello, We store a number of images as blobs in a table that we can access through crystal reports. Our database was just upgraded from 9.2.0.5 to 9.2.0.7. Since then, when trying to use these images in reports, the field type shows up as string[3999] and when trying to refresh the report, we...

Pepito, Did you ever get this solved? I'm running into the same issue stinsman described when exporting to pdf, and copying the dll doesn't seem to do it... tia, mp

Thanks for the suggestions. I don't think either of these solutions will work. I didn't mention that the details sections of both the main report and the subreport have two columns. It seems that pulling the subreport into the Report Footer will not work, since multiple columns are not...

I have a report with two groups and two details sections. The second details section contains a subreport that is actually an index of the accounts in the report. That second details section is suppressed 'not OnLastRecord', so that it will only print out once, at the end of the report, after...

I am running into the same issue. Brian's suggestion is awesome, except that my details section has two columns (formatted with multiple columns), and as far as I know, there is no way to have multiple columns in the group header. This means that the first cell in the right column is blank for...

Spoke to soon. I do have one more question. How do I handle the first record of the report where previous() is null? The evaluation of the if statement fails - it doesn't like isNull(previous({STUDENT_ALL_V.STUDENTID})) - which is really what I need - a way to determine if there *is* a...

Ooops! I see my error, and it's working fine now. Thanks all!

Thanks for the help. I don't need anything complex, so the first formula seems like it should work fine. However, I'm getting strange results. My formula looks like: WhilePrintingRecords; numbervar mycounter ; if {STUDENT_ALL_V.STUDENTID} <> previous({STUDENT_ALL_V.STUDENTID}) then...

Hi, I've got a report with a suppression formula on the detail section. Basically, I only want one record per person to appear on the report, and this is working fine. However, I am using the Special Field 'Record Number' on the report, and it seems that the suppressed records are being...

Sorry if I wasn't clear. There are 15 different *possible* rows in the cross tab, depending on a the values of a combination of fields from the database, so I have a formula with a multi-part if-statement that saying: if blah and blah then &quot;type A&quot; else if blah and blah then...

Hi, I have a cross-tab report with 15 different rows. The rows' labels are printing out alphabetically, but I want to specify the order in which they should appear (which is not alphabetically). I created a formula specifying that order, and am using that formula as my sort order, but the...

Hi, I am working on a report that will produce a flat file of data. The fields are fixed length within the report. I need to append a trailer record with summary information as the last line of the report. I currently have this data in the report footer, and it is displaying properly in the...

Is there a way to construct 'or' clauses (instead of 'and') in the select expert without having to manually edit the formula in the record selection editor? Some of our non-technical users don't want to have to manually edit the formulas, but there does not seem to be a less manual way of doing...

Jim, Thanks. I added WhilePrintinRecords immediately before the EvaluateAfter... The formulas are in different detail sections, but I don't think that is the problem. For example, I modified formula2 to simply return the output of formula1, which is does properly. However, as soon as I add...

Hi, I've got a formula (formula2) which needs to be evaluated after formula1 to return the correct results. Formula2 looks something like this: evaluateAfter({@formula1}); if {ACCOUNTS.STATUS} = 'LAST' then (local stringvar returnval := ' '; if not isNull({ACCOUNTS.FIRSTNAME}) then...

Hi, Thanks to all of you for your suggestions. I handled this by creating the running total and suppressing where count>1. I believe that Ido's suggestion using grouping would have worked, too - but this gave me a chance to use running totals! Thanks again.

Hi, I have a table that records various 'statuses' about people. So, the table stores the personId, status, dateInserted, etc., and a person can have multiple status records. What I need to do is to display only the most recent status record per person (ie, by the max(dateInserted) for that...

Hi, I have created a manual cross-tab report (because I needed % calculations, and hard-coding the columns seemed to be the only way to do this). That part worked great. I have approximately 70 columns, so the designer, they are in the group footer, on multiple lines (since they would not fit...

Hi, I need to create a report of grades for courses the were offered in a particular year. I need the report to be a table with the grades as the rows, and the courses as the columns. For each course, I want 2 columns: one column with the number of students who received the grade, and...

Hi, I am a new Crystal Reports user. I need to generate a report and export the the report so that the fields are fixed length, ie, the length of each field matches its length in the database view it is being pulled from. The resulting text file will be used as a data source file for an upload...