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

    Exporting to Excel with Supreport (want on one line)

    And just for future readers of this post - when I published this report to our enterprise server for others in my organization to access, the option to export to Tab Separated Text (TTX) did not exist. But exporting to Rich Text Format (RTF) worked. I then copied and pasted it into excel and...
  2. jccjill

    Exporting to Excel with Supreport (want on one line)

    I GOT IT TO WORK WITH A BIT OF A WORKAROUND. Thank you PGFrank for the idea. I exported it to Tab Separated Text(TTX)and associated that with notepad. Then copied the text in the notepad and pasted into excel and it split it into the correct cells on the correct rows. Thank you all for your...
  3. jccjill

    Exporting to Excel with Supreport (want on one line)

    PGFrank - can you explain how you set this up: "My main report contains a field that allows me to determine whether or not the subreport will have data for a particular detail record." And are you suppressing the sub if null from the main report or in the sub.
  4. jccjill

    Exporting to Excel with Supreport (want on one line)

    Thank you so much for all of your attempts to help solve this problem! I think I am stuck with a wrapping subreport :-) I decided to try to remove the running total all together to see if that was causing the problem - and removing it didn't solve the problem - so I am making the assumption...
  5. jccjill

    Exporting to Excel with Supreport (want on one line)

    To the left is a running total that does produce some null values. (The whole thing is in a group footer)
  6. jccjill

    Exporting to Excel with Supreport (want on one line)

    I tested the guideline on all four sides - and it appears fine. Could it have something to do with the setup or format within the subreport?
  7. jccjill

    Exporting to Excel with Supreport (want on one line)

    It does move when I move the guidelines, however it is not red in the corners to show it is attached, the way the fields in the primary report are. But it does move. Is there a way to make it attached so that the corners turn red the way the other ones do (for now I had dragged the subreport...
  8. jccjill

    Exporting to Excel with Supreport (want on one line)

    I have done the search and the only answer I came up with was to make sure that the subreport is lined up with the rest of the report (formated the same height and aligned.) This has been done in this report and it still is wrapping. Any other thoughts?
  9. jccjill

    Exporting to Excel with Supreport (want on one line)

    How can you export to excel when your report has a subreport - and you want the subreport information on the same line as the information in your report (by record). For example: in crystal it appears record 1info subreport info but when you export it becomes record 1info subreport info
  10. jccjill

    Suppress group footer using formula

    Thank you. That solved it!
  11. jccjill

    Suppress group footer using formula

    The formula is the @Count of Approved Swipes formula field in the footer which was created using summary, count. So the formula is Count ({CARD_ACCESS_HIST.APPROVED}) It is located in the group footer. Other than that the field choosers are the other formulas and they are...
  12. jccjill

    Include Date Parameters Chosen by User in Report Header

    thank you that was helpful, I was able to use the maximum and minimum to break up the range and get that in my report header.
  13. jccjill

    Include Date Parameters Chosen by User in Report Header

    I am allowing my user to choose a date range for the report. The formula is set up so that the date equals the parameter. The parameter is set up as a date range. How can I print the chosen date range in the report header.
  14. jccjill

    Suppress group footer using formula

    I am trying to suppress a group footer when the count is less than 25. In the section expert I have chosen to supress group footer using the following formula: WhilePrintingRecords;{@Count of Approved Swipes}<25 but it isn't working. What am I doing wrong?

Part and Inventory Search

Back
Top