Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

passing value from subreport to crosstab in main report CRXI

adnil (TechnicalUser) (OP)
16 May 12 5:19
hi there, i need to pass a value from a subreport into a crosstab in the main report and do a % count on it and i can't figure out how to do it.

my main report has a date range parameter and it shows:

1) group 1: area
2) group 2: companies
3) group 3: staff who have been off sick with a reason of stress during the selected date range
4) details: the date(s) they were off sick, and number of sick days.

in the subreport, i have the toal number of staff who have been off sick (regardless of reason) by area. this is placed in group header 1 of the main report.

in the main report's report footer i have the following crosstab:

no of no of sick no of
staff incidents sick days
area A company A1 xx xx xx
company A2 xx xx xx Total xxx xxx xxx
area B company B3 xx xx xx
company B4 xx xx xx
Total xxx xxx xxx

what i need to do now is to have a percentage count of the no of staff against the total no of staff who have been off sick (from the subreport) for each area. how can i do that? any advise will be greatly appreciated.

thank you.

adnil (TechnicalUser) (OP)
16 May 12 9:03
the crosstab looks like this:

column 1: area
column 2: company
column 3: no of staff
column 4: no of sick incidents
column 5: no of sick days

thank you.
adnil (TechnicalUser) (OP)
17 May 12 9:25
lbass (TechnicalUser)
19 May 12 9:59
Please explain what you did so others can benefit from this thread.


Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close