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...
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...
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.
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.