Cross Tab as Column Group

[quocp]

I am converting one report which was designed by RDLC to Stimulsoft.
The rdlc version used the column group to group the quantity of product by the date in the tab header. I am trying to use the cross tab to achieve the same thing for Stimulsoft.
My issue is that the generated report only display one product on it ( see pic1), while the dataset has 5 products ( pls see the attached xlsx file .
Pls give me some advice on how to solve the problem.

Pls note that:
- the ThirteenPeriodTableCrossBand DataSource is duplicated by ThirteenPeriodTable DataSource . I am using it to apply a filter for the CrossData and make sure the product which are the same APN will be displayed the quantity (Qty) in one row.
- the code .Net just use to generate the dataset which has records as the attached xlsxfile file.

[Lech Kulikowski]

Hello,

We couldn't run your report. Please send us test data for your report.

Thank you.

[quocp]

Hello,

We couldn't run your report. Please send us test data for your report.

Thank you.

Hi Lech,

I am quite new with Stimulsoft.
Which format of test data you would like to have ? The data records which generated from dataset has been included in the above attached excel file.

[Lech Kulikowski]

Hello,

You can use the "Embed all data to resources" feature in the designer.

Thank you.

[quocp]

Hi Lech,

I have manually added the data and schemas under the Resouces.
But I could not import XML Schema for BOTH ThirteenPeriodTable and ItemMovementTimeSeries under Data Source.

Could you pls have a look on it ?

[Lech Kulikowski]

Hello,

Can you run a report with these sources in resources? If yes, please save it and send us for analysis.

Thank you.

[quocp]

Hi Lech,

I can run the Report.mrt file in my .Net project which generates the dataset.

But I can not run the Report2.mrt file which was added the resources manually because I could not import XML Schema for BOTH ThirteenPeriodTable and ItemMovementTimeSeries under Data Source.

[Lech Kulikowski]

Hello,

Could you save your dataset from your project?
dataSet.WriteXmlSchema();
dataSet.WriteXml();

Thank you.