Zo Has
Zo Has

Reputation: 13018

Pass command field from main report to crosstab formula in sub report?

I have a master detail report. The crosstab is included in detail section inside a subreport.

How to pass a command field from main report to cross tab formula field in sub report ?

Upvotes: 0

Views: 1337

Answers (1)

codingbadger
codingbadger

Reputation: 43974

You can do this using Shared Formulas.

In your main report create a new Formula Field - it can be called whatever you like. Create a shared variable and assign it a value.

WhilePrintingRecords;
shared stringVar MAINREPORTVAR := {Table.ColumnName}

In your sub report, create a new Formula Field and enter the following:

WhilePrintingRecords;
Shared StringVar MAINREPORTVAR;
MAINREPORTVAR

The variables names in both of the formulas must be the same.

This will display the value of the Formula field from your main report on your sub report. You can then use this in your cross-tab.

Upvotes: 4

Related Questions