Question

Asked on 2010-08-25 at 03:30:35ID: 26756137

Percentage in Cross Tab

by: NickHoward500

Rating7.1Very Good

I need help to define a report on calls data, for example how many calls connected (%), how many failed (%), Number of Total calls, Number of short calls (counting calls less than x seconds), Average Call, Average PDD (post dialing delay). This to be done for each service provider and for each country prefix. Since service providers can increase or decrease, so I need a dynamic CROSS-TAB solution. I heard this can be achieved in CROSS-TAB, if not possible it is okay to do without it, by question is how to make it dynamic?

I am attaching my report made in CR 2008 where I created all necessary formulas (though don't know how to get avg weight). I am only able to put total success and failure calls in cross tab. No idea how to add next to total failure/ success calls the Success%, Failure %, Total Short Calls, Weight avg duration, weight avg PDD grouped by tariff_prefix . As said above, if this can not be achieved how it can be done (appreciate my report is modified). I have also included datasource in excel.

Hope it would not big thing professionals like you. I am new in CR.

Thanks in advance.

 [embed=file 340751]
 [embed=file 340749]

  1. Cross tab report complexity
    I'm trying to create a cross-tab report as follo…
  2. Format Cross-tab column header
    I'm pretty new at this so please forgive a basic …
  3. I need sum summaries
    I have created a commission report and grouped …
  4. subreport shows wrong data while within main r…
    My record selection formula in main report is: …
  5. A number is required here error
    I am creating a job cost summary type report wit…

Solution

Access this solution immediately by signing up as a member of CrystalReportsExperts.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution

Sign up Now to View This Solution
Zone
general
Tags
Participating Experts
1
Solution Grade
B

Replies

 by: NickHoward

Posted on 2010-08-25 at 04:02:59ID: 34644695

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: NickHoward

Posted on 2010-08-25 at 14:17:35ID: 34644696

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: mlmcc

Posted on 2010-08-26 at 13:12:11ID: 34644697

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: NickHoward

Posted on 2010-08-27 at 02:24:09ID: 34644698

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by:

Posted on 2010-08-27 at 16:52:45ID: 34644699

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: NickHoward

Posted on 2010-09-24 at 05:26:24ID: 34644700

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Stay Connected

Top Experts

  1. mlmcc

    334,774

    Wizard

    0 points yesterday

    Profile
  2. James0628

    70,696

    Master

    0 points yesterday

    Profile
  3. LinInDenver

    4,800

    0 points yesterday

    Profile
  4. peter57r

    4,000

    0 points yesterday

    Profile
  5. 13598

    3,520

    0 points yesterday

    Profile
  6. PCIIain

    1,700

    0 points yesterday

    Profile
  7. RickIsWright

    400

    0 points yesterday

    Profile
  8. Dan3D

    300

    0 points yesterday

    Profile

BrowseAre you an Expert?