CODEWITHSUNDEEP
crystal-reportscrystal-reports-xi
Imrul Kaesh
Imrul Kaesh

Reputation: 53

sub report to main report value passing in crystal report

I want to get sub report to main report value pass. How this possible?

this is my main report and My Need format

And sub report is- this is my Sub report

AVGQty formula is - Sum ({Command.IssueQty})/Sum ({Command.WorkingDays})

I want to get every Item Wise average from sub report in main report using report link.

as like, Acetic Acid - AVG Qty: 128.91 (Item wise value come from sub report)

Upvotes: 0

Views: 2281

Answers (2)

KuKeC
KuKeC

Reputation: 4610

From what i understand, you don't need callback value (shared variables) from subreport in your main report. Just include subreport dataset into your main report and link those 2 tables in database expert.

So for example you have table a which is in your main report and table b which is you subreport. You link them from itemname from table a to itemname to table b. To make this without any shared variables you should just add table b to main report, in database expert link both tables with itemname and then you can group by attribute itemname from table a to get summarizes which you want.

You can do it with shared variables or with this logic. Your choice

Hope it helps

Upvotes: 0

Rui Rita
Rui Rita

Reputation: 21

You need to use a shared numbervar in your formula.

In your case:

shared numbervar AVGQty:= Sum ({Command.IssueQty})/Sum ({Command.WorkingDays});

then in your main report you simply create a formula with:

shared numbervar AVGQty

Upvotes: 2

Related Questions