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

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Hi, I got my report fixed to show all codes. I created a mock-crosstab that displays all totals for all months, separated by type1 & type2 (even if some months do not have any data) I am back to my original problem which is: I need to create a chart that displays the total, separated by type1 &...
  2. tbear10

    Crystal Reports - Losing Data When Parameter Entered

    Oh...sweet!!! I got it to work! Although I was using the subreport, I was still linking the dates in the selection criteria. Took that out & its all looking good...thanks for the idea Turkbear :-)
  3. tbear10

    Crystal Reports - Losing Data When Parameter Entered

    Thanks Turkbear. I tried the approach of using a subreport & I am still losing my codes. Whether I create a subreport for each month or 1 subreport with all months, I am still losing my codes. Any other ideas?
  4. tbear10

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Thanks N22S & LB. I had already created the 12 separate formulas & that was working well, but I didn't use Sum, I used Count. I'll try that & see what happens. But I have another issue that I need to deal with before I can move ahead because it can affect my whole report. I've started a new...
  5. tbear10

    Crystal Reports - Losing Data When Parameter Entered

    Hi All, I am creating a cross-tab that should contain ALL codes & the # of times it is used each month. If the code has a not been used for a given month, it should still appear with a value of 0. If I don't have a start/end date parameter, I get ALL the codes for all the months/years. I also...
  6. tbear10

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Yes, I tried that & it doesn't work because data for certain months is not stored anywhere.
  7. tbear10

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Can anyone help me with this problem? I am so close to developing the report that I want, the only thing missing the chart that displays all the months. Thanks in advance
  8. tbear10

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Hi, No, I do not have a table with all the month fields. I don't think I can create one either since this is an enterprise system we are using.
  9. tbear10

    Crystal Reports - display null/zero values in a cross tab and/or chart

    Hello, I'm relatively new to Crystal Reports & need help with a report I am creating. I have given an explanation of the scenario below. Report SHOULD look like this: Month:Jan-Feb-Mar-Apr-May ... Type 1:-0-0-0-12-16 Type 2:-0-0-0-34-56 Total:-0-0-0-46-72 The report looks like this...

Part and Inventory Search

Back
Top