By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Multiply data in a report from 2 seperate reports

P: 8
Hi,
I have a report called 'schools'

This report lists the percentage of schools performing a certain action

In the 'schools' report I have a subreport which lists information on the percentage of classes performing a certain action.

Thus the 'schools' report contains an output value of the percentage of classes performing a certain action and the percentage of schools performing the same action.

Is there any way I can multiply the percentage of schools performing a certain action by the percentage of classes performing a certain action and display this in the same report?

The 'schools' report uses fields from 'schools' query while 'classes' report uses fields from the 'classes' query.

Please help me find a way to multiply the two percentage values and display them in the same report.

Thanks
Jan 10 '07 #1
Share this Question
Share on Google+
3 Replies


P: 8
To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?
Jan 11 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?

Firstly create a new textbox to hold the value. Then if the textbox is on the subform then set the control source equal to

Expand|Select|Wrap|Line Numbers
  1. =[PercentTextboxOnSubReport] * [Reports]![School]![PercentTextboxOnSchoolReport
or if the new textbox is on the main form them

Expand|Select|Wrap|Line Numbers
  1. =[PercentTextboxOnSchoolReport] * [Reports]![School]![PercentTextboxOnSubReport
Mary
Jan 11 '07 #3

PEB
Expert 100+
P: 1,418
PEB
Hi,

I've always prefered to do all calculations and transformations into a queries rather than in reports!

The codings and calculations in reports are always not able to fit a big amounts of data!

Queries are always more performing! There is cases when query opens but report can't open giving an error Query is too complex!

So try to create a query on using shcool and class queries where to calculate the respective values.

And than create a report that shows those calculations!

Certenly in some cases the report shows the percent calculations easy! But watching the answer of Mary it seem to be more complicated ur case! So seems for me better to calculate into a query!

Exemple of calculation column into query:

Total score: [shcool].[score]*[Class].[Score]


Best regards!
To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?
Jan 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.