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

    Crytstal 2013

    You can also concatenate the start dates and end dates with cdate function to convert to date then subtract based on what datediff you want.
  2. padytom

    adding totals.

    i have a cross tab report that i want to add the month using formula. If month = january, add all january cost, if month is feb, january cost+febraury cost. if month is march then january+feb+march cost and so on. any help will be appreciated.
  3. padytom

    Cross tab ( Cumulative total)

    I have this report i'm having issue with crystal 2011. It is a cross tab that is made up of column months and summary fields from formulas that sums up the cost for financial years. first row is FY14 second row is FY15 and third row is FY16 all these from formulas. then the next row is supposed...
  4. padytom

    Suppressing Records

    I'm not sure I understand you well but since you know your formula to use, the condition you want to use in the record section should be used in the formula section and use the formula instead of the field.
  5. padytom

    Changing percentage value in crosstab

    where will this formula be created, in the format text on the crosstab or as a separate formula?
  6. padytom

    Changing percentage value in crosstab

    It true crystal report crosstab. It is a replica of an excel report. The 1's and 0's are formula field. How I did it is, I didn't add any field to the rows field in the cross tab then then the grid lines to that section and text, I used background color to hide them and then used text object to...
  7. padytom

    Changing percentage value in crosstab

    Unable use formula because the formula fields are based of sum of 1's and 0's and these are to be for different months. when I use formula, it returns same value for all months.
  8. padytom

    Changing percentage value in crosstab

    This is a screen shot from the report. I can not use formula to achieve this because the figures up there are sum of 1's and 0's and when I use this formula, (sum({@frmCMcount})/sum({@frmtotalSCCMcomp}))*100 it returns a single value for all the...
  9. padytom

    Changing percentage value in crosstab

    No how I'm doing it is I add the field to the summarized section under the crosstab expert and then select change summary. Then I select weighted average with then the field and ok
  10. padytom

    Changing percentage value in crosstab

    Thank you Skip. I tried doing that but where do I multiply the value. I tried multiplying under the format customization and decimals
  11. padytom

    Changing percentage value in crosstab

    I have a crosstab that returns weighted average value as .45 but I want it displayed as 45. How can I achieve this?
  12. padytom

    Select Most Recent Value from Non Recurring Field

    can you try something like this? I haven't tried it though if isnull({field}) then previous({field}) else {field}
  13. padytom

    Suppressing Detail rows

    Thanks so much Brian. It works great
  14. padytom

    Suppressing Detail rows

    i have a column that has two values 1 and 0. these have been grouped and I want to suppress the detail of the group that has only 0s and show those that have both 1 and 0. any help?

Part and Inventory Search

Back
Top