Creating reports and dashboards | Stimulsoft community forum

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.

Hello,

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

Thank you.

Lech Kulikowski wrote: ↑Mon Jul 24, 2023 4:03 am 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.

Hello,

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

Thank you.

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 ?

Hello,

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

Thank you.

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.

Hello,

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

Thank you.