cross tab report question

[rrmcguire]

I have a cross tab report where the rows are the field ENTEREDBY and the columns are the field PICKUPDATE(grouped by month) The summarized field is "Sum of @dispatch profit"

What Im trying to do is only show specific entered by iniitals for my row, but those entered by initials are part of a set.

ex.

the set is PET. PET includes initials(ENTEREDBY) SSR, STH, EMG, so I need to either create a parameter field where the user picks the set which are either PET, LTT, or BBT, based on that selection only show the rows of the ENTEREDBY which are part of that set

PET= STH, SSR, and EMG

LTT= SSA, TEG, CRS, SAH

BBT= LKD, RAH, JJN

 

[IanWaterman]

Create a string Parameter with 3 default values PET, LTT and BBT

In select statement

(If {?Param} = 'PET' then ENTEREDBY in ['STH', 'SSR', 'EMG']
else
If {?Param} = 'LTT' then ENTEREDBY in ['SSA', 'TEG', 'CRS', 'SAH']
else
If {?Param} = 'BBT' then ENTEREDBY in ['LKD', 'RAH', 'JJN']
)

Ian

 

[rrmcguire]

ok, that worked when I have the cross tab in its own report but when I put my cross tab in another report it doesn't prompt for for my parameter date range field that the cross tab generates its data from and the cross tab doesn't show up at all.

Is there anything which prevents cross tabs from showing up?

 

[lbass]

A crosstab is just a way of organizing the data that is returned by the record selection formula, so if the records used in the crosstab aren't returned to the report, the crosstab can't generate.

If you need the crosstab to have a different date range and/or set of data than the main report, then insert it as a subreport--or is that what you tried? If you inserted it in a subreport and it is not displaying, try removing the subreport link to see if it will generate then.

-LB

 

[rrmcguire]

I tried putting in both a subreport and the footer of my main report, the table is the same as the table used in my main report.

When using a subreport I didn't link it to the main as they're using the same table

 

[lbass]

Can't troubleshoot this without more specifics about what you did.

-LB

 

[rrmcguire]

The main report is just out of the table SHIPMENTS, as is the cross tab. I have 3 other subreports from other tables(CUSTOMERS, SALESCALLS(2)).

There are a series of parameter fields which need to be filled in but none of those have any effect on the cross tab.

I have 2 parameter fields for my cross tab to dictate what date ranges its pulling along with and what team initials(PET, LTT, BBT) as mentioned above

When I put the cross tab in the report footer as I had it in its own separate report, the report runs but nothing shows up and my parameter fields aren't coming up for the cross tab part either.

If I import the report into the footer as a subreport it does the same thing. I wouldn't think I would need to link the report as the subreport with the cross tab is from the same table SHIPMENTS as the main report.

 

[lbass]

How is the crosstab set up? Where in the crosstab are you using the parameters? You must be using formulas for rows/columns or summary to build these in--what are the contents of these formulas? Are they consistent with the date ranges and selection criteria of the main report?

For the subreport approach, what is the content of the record selection formula? What is the main report selection formula (report->selection formula->record)?

-LB