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

    ReportNet chart scale problem with Master/Detail report

    I have a ReportNet report that consists of three pages: 1-Title Page, 2-Line Chart, and 3-List. The user is prompted to enter in one or more Group IDs and all three pages will be generated for each Group ID entered. I have a Master Query and 2 Detail queries to generate the data for the...
  2. furthur

    Counting Specific Words within a String

    I am needing to count how many times a specific word appears within a string. For example, if a string is "Complaint, Question, Complaint, Praise" then I need a formula that can tell me that the word "Complaint" appears twice. The string will be comma separated, and...
  3. furthur

    Printing from Excel spreadsheet type is small

    Open the report and in the File|Printer Setup menu box, select "No Printer". We had a similar problem and this fixed it for us.
  4. furthur

    Showing detail info in group header

    I have data something like this: Call_ID Answer 1 red 1 blue 2 blue 2 green 2 orange There can be multiple Answers for each Call_ID. Is there a way to show in the group header (for Call_ID) all the Answers? Such as: Call_ID: 1...
  5. furthur

    Setting Decimal places by report

    That only works if I have the formula on the canvas. I can use Format-Field so it displays .82 instead of 1.00, but if I use that formula in another formula, I can't seem to make it use .82. Assume Numbers are formatted to round to 0 decimal places for the report. @Formula1 : 82/100 I can...
  6. furthur

    Setting Decimal places by report

    I am using CR7, and am wanting to set number fields to show two decimal places (by using the File|Option menu, clicking the Fields tab, and then formatting Number fields to show two decimal places) and then saving that formatting with the report. When I run a different report, I want it to...
  7. furthur

    Suppressing sections on empty reports

    If there are no records for that day, your total will not be 0, but will be NULL. So you should supress your Report Header A (normal header) if your total formula is NULL and suppress your Report Header B (static text saying there were no records) if your total formula is not NULL. Header A...
  8. furthur

    Export problem to Excel

    We had this problem (using Info 7) and were able to solve it by selecting the "No Printer" option from the File|Printer menu within the Crystal Report. After we did that with all of our reports, the print size was fine in Excel.
  9. furthur

    Export to Excel, then illegal operation when printing

    I had a very similar problem using Info 7 and exporting to Excel. We were never able to figure out exactly what was going on, but we were able to get around it by checking the "No Printer" option in the File|Printer Setup menu before running and exporting the report. We thought it...

Part and Inventory Search

Back
Top