Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mperera

    error with blobs in crystal 8.5 with oracle 9.2.0.7

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

    Problem Exporting to PDF/Registering DLLs

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

    page footer

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

    page footer

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

    Keep Group Together, except...

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

    suppressed records and record count

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

    suppressed records and record count

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

    suppressed records and record count

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

    suppressed records and record count

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

    ordering rows in cross tab report

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

    ordering rows in cross tab report

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

    trailer record in fixed-length fields report

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

    'or' statements in record selection

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

    problem with EvaluateAfter

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

    problem with EvaluateAfter

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

    displaying one record per person

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

    displaying one record per person

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

    exporting column headers in &quot;manual&quot; cross-tab report

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

    cross-tab report of course grades in&quot;spreadsheet&quot; style

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

    Exporting fixed-length fields?

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

Part and Inventory Search

Back
Top