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!

  • Congratulations Mike Lewis 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. mattlscc

    Scheduled report is returning blank pdf

    Have you validated the database query that gets generated for the specific parameters to confirm that data should come back... and then also validate that no record selection formulas were present to block data? Thanks, Matt
  2. mattlscc

    What is "Waiting:" under System Metrics Account Activity - Current Jos

    On our system we always have ~ 95 jobs listed under the "Waiting:" section of Current Jobs in the system metrics. Any idea what these jobs are? Can someone provide a query builder query that will return these jobs?
  3. mattlscc

    Lotus Notes error - File already exists

    thread73-1259995 I'm having almost the same issue as above mentioned thread. (except it is not from home through a VPN, it is directly on my laptop at work... and I don't seem to have the 5-6 times and then it works...keep getting the pop-up box.. also on Lotus Notes 7) Try to open Notes and...
  4. mattlscc

    Group header not repeating when group footer is pushed to next page...

    I already had the "Repeat Group Header on New Page" option checked... that is the weird part... seems like a bug in Crystal Reports to me. I also already had both the header and footer of groups 1, 2, and 3 suppressed... those groups do not display anything, just there for sorting purposes...
  5. mattlscc

    Duplicate Rows

    Could you give a quick layout of what your report is like, as far as header, groups, number of detail rows? Could it have something to do with "select distinct" option? Are you running with the same parameters / filters from BO?
  6. mattlscc

    Group header not repeating when group footer is pushed to next page...

    I apologize in advance if this is a repeat topic, but I could not find it anywhere using the Keyword Search... I am using Crystal Reports Version 11.5.8.939 I have a report with six groups... the basic layout idea is show below... RH PH G1_HEADER G2_HEADER G3_HEADER...
  7. mattlscc

    Exporting to TXT format removes data shown in preview tab

    Well, I never could figure this out... turns out my import will work just fine if I have "^ " (note the space character next to the "^" character). And by adding the extra space it will always show up. There must be a bug of some sorts that doesn't allow a single character on one line from a...
  8. mattlscc

    Exporting to TXT format removes data shown in preview tab

    No, I do have a suppression on that line which is this: WhilePrintingRecords; Shared booleanVar recordsFound; not (recordsFound); The recordsFound shared variable gets set in the sub reports Report Header section. WhilePrintingRecords; Shared booleanVar recordsFound; recordsFound := not...
  9. mattlscc

    Exporting to TXT format removes data shown in preview tab

    Well, I figured out the missing data of the first transaction... I had a shared variable that was to determine if no data came back which wasn't getting evaluated in time for the first group. Anyhow, I am still at a loss why a single character on a line in a sub report will not display in the...
  10. mattlscc

    Exporting to TXT format removes data shown in preview tab

    I have some patches, not sure if they are the latest or not... my version is 11.5.8.939 Yes, I have tried other characters besides "^", and it does not seem to matter... even when using "A" it still does not show when exporting from the parent report. Another possible clue to what is going on...
  11. mattlscc

    Exporting to TXT format removes data shown in preview tab

    I have tried many characters per inch values to no avail. I have tried all the recommended values from 8-16 and even some outside that range. I'm not sure if this matters or not, but I have the font set to Courier New with a size of 10. I have also tried changing the font to Courier New with...
  12. mattlscc

    Exporting to TXT format removes data shown in preview tab

    Crystal Reports Version: 11.5.8.939 Main report contains sub report. There are two cases of missing data. Problem one, the first transaction is missing except for the last line which is supposed to be a "^". Which leads me to the second problem... all the lines that are separating the...
  13. mattlscc

    Total in Group Header and Report Header?

    Hey thanks...this was a great help! Here is my final solution... since yours only covered one split of pages I needed to modify it a bit to handle any number of page splits... created formula {@count}: whilereadingrecords; global numbervar cnt := cnt + 2; numbervar output; if cnt mod 998 = 0...
  14. mattlscc

    Total in Group Header and Report Header?

    Is there a way to do this same thing if you don't have a group to pass into the sum function? So in my report, every 999 detail rows I split into a second page. So I might loop over 1,500 records and get 1,500 detail rows... between 999 and 1000 I have to put a footer and then a header for the...

Part and Inventory Search

Back
Top