Cross Tab Control Question
Hi Everyone
I have successfully been able to construct a Cross Tab to the format etc I
am after. A Report, Title, Footer and Detail Band with no Datapipeline, and
a single Cross Tab Component with a Datapipeline.
I have read through the Newsgroups, and seen restrictions on orders etc
comming from Pipelines when using Cross Tab's
So my question is this:
I am trying to restrict the data feeding the Cross Tab using the Search Area
within the Data Tab (End User Report Solution).
So I add my field, and the values I am trying to use to limit the data, but
no matter what, the Cross Tab always shows All Data irrespective of the
Search Parameter
Paramster is defined as Field, In List, Values (i.e 1, 5, 6), Autosearch
(not Checked), Mandatory (Checked), Show All (not Checked)
One thing that is curious - if i Use the data viewer on the Data tab on the
Pipeline, I see the correct data
Is this expected behaviour?
I am using RB 6.03, and Delphi 6 Ent Sp2
Any ideas why the cross tab is displaying all the data instead of the
restricted data set?
Any suggestions/information would be appreciated.
Regards
Scott
I have successfully been able to construct a Cross Tab to the format etc I
am after. A Report, Title, Footer and Detail Band with no Datapipeline, and
a single Cross Tab Component with a Datapipeline.
I have read through the Newsgroups, and seen restrictions on orders etc
comming from Pipelines when using Cross Tab's
So my question is this:
I am trying to restrict the data feeding the Cross Tab using the Search Area
within the Data Tab (End User Report Solution).
So I add my field, and the values I am trying to use to limit the data, but
no matter what, the Cross Tab always shows All Data irrespective of the
Search Parameter
Paramster is defined as Field, In List, Values (i.e 1, 5, 6), Autosearch
(not Checked), Mandatory (Checked), Show All (not Checked)
One thing that is curious - if i Use the data viewer on the Data tab on the
Pipeline, I see the correct data
Is this expected behaviour?
I am using RB 6.03, and Delphi 6 Ent Sp2
Any ideas why the cross tab is displaying all the data instead of the
restricted data set?
Any suggestions/information would be appreciated.
Regards
Scott
This discussion has been closed.
Comments
Please disregard the previous question. As it turns out, the QA team gave me
the wrong set of parameter data (after swearing blind it was correct).
With correct input data, everything is working perfectly.
Thanks
Scott