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

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

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

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

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