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

    Cross Tab report showing a percentage

    I did I find it - I looked in an old manual and found the section about changing the summary in the cross tab. Click on that and changed it from sum to count and then on the box that indicate to show as a percentage. This was on the @0 formula. The summarized fields are: Count of Call Type and...
  2. eliner

    Cross Tab report showing a percentage

    Please disregard this. I found the way to do it. It was right in front of my face and I was to dumb to see it at first.
  3. eliner

    Cross Tab report showing a percentage

    We have a report on our call center activity. There are various fields in the call center entry page that have a name, however, on the report they are showing as a #. Example: Select “sale” on the entry form and you get a 1 on the report. I have created a formula that will translate them into...
  4. eliner

    Accessing database on webserver

    Good Morning - we have a webbased database that we wish to connect to and generate crystal reports on the data therein. It is an MYSQL database. Thanks for any info you can provide.
  5. eliner

    Group Sub Totals Percentages in Cross Tab Summary

    Good Morning - thank you for all your assistance with this problem. Working great now. Just what we wanted, again, thanks.
  6. eliner

    Group Sub Totals Percentages in Cross Tab Summary

    Hello again - that solved part of the problem. No longer am I getting the div/0 response. What is now appearing when I run the report is nothing under the various vendors for the two new rows added. In the total column I do get 0.00 for each of the rows. For some reason It is not picking up the...
  7. eliner

    Group Sub Totals Percentages in Cross Tab Summary

    Thanks for the information and help. Think there maybe a syntax error as I am getting a Division by Zero error when I run The report. Both “comdue” and “base” are highlighted. Maybe I should rename some formulas. Gross Comm: Formula: @commission/@upfront rebate Commission: database field...
  8. eliner

    Group Sub Totals Percentages in Cross Tab Summary

    Sorry for the delay in response - been out of the office. Since the report is sorted by vendor and we get totals for each vendor and the report can have anywhere from 1 to 20 vendors on it, I call the vendor totals sub totals since we do have a grand total for the whole report in the report...
  9. eliner

    Group Sub Totals Percentages in Cross Tab Summary

    Good Morning – I have a report that is 11 columns across. The report is grouped by vendors with group sub totals. We receive a commission from vendors and pass some of that to our clients. My current cross tab is a summary and work fine. We have added two columns to the report: Gross Comm % and...
  10. eliner

    Running Totals in a Cross-Tab

    Good Morning – I have a report that is 11 columns across. The report is grouped by vendors with group sub totals. We receive a commission from vendors and pass some of that to our clients. My current cross tab is a summary and work fine. We have added two columns to the report: Gross Comm % and...

Part and Inventory Search

Back
Top