Re Simple Customer Statement Report

Stimulsoft Reports.NET discussion
Andre2
Posts: 47
Joined: Thu Jan 24, 2008 12:30 am
Location: Australia

Re Simple Customer Statement Report

Post by Andre2 »

Just updated to 2008.1.228 with the same result

What version are you using
Thanks
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Re Simple Customer Statement Report

Post by Edward »

I tested with 2008.1.200 version.

Here is my report.

Thank you.
Attachments
66.CrossTabWithConditionAsValue.mrt
(24.43 KiB) Downloaded 138 times
Andre2
Posts: 47
Joined: Thu Jan 24, 2008 12:30 am
Location: Australia

Re Simple Customer Statement Report

Post by Andre2 »

Hi There
had to remove the 2008.1.228 version.....broke the report in my application :dumb:
Andre
Andre2
Posts: 47
Joined: Thu Jan 24, 2008 12:30 am
Location: Australia

Re Simple Customer Statement Report

Post by Andre2 »

Ran your report on my system and it appears not to be working.
I have taken a screen shot of the report
I dont know how to attach a file whilst in the forum so Ill post directly
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Re Simple Customer Statement Report

Post by Edward »

Sorry for misunderstanding.

Here is the solution as needed:

I've added the following code in the BeginRenderEvent of the page:

DataRow myRow30 = Orders.DataTable.NewRow();
myRow30["OrderDate"] = StartDate.AddDays(-30);
DataRow myRow60 = Orders.DataTable.NewRow();
myRow60["OrderDate"] = StartDate.AddDays(-60);
DataRow myRow90 = Orders.DataTable.NewRow();
myRow90["OrderDate"] = StartDate.AddDays(-90);
Orders.DataTable.Rows.Add(myRow30);
Orders.DataTable.Rows.Add(myRow60);
Orders.DataTable.Rows.Add(myRow90);
Orders.DataTable.AcceptChanges();

This code adds empty lines to underlying DataTable of the DataSource which is used in Cross-Tab.

Each DataSource is converted into DataTable in the Stimulsoft Reports.Net, so it could be changed in runtime too.
As the records added do not have sums it would be an empty invoices, and cross-tab will be shown as expected.

I am attaching the template too.

Thank you.
Attachments
67.CrossTabWithConditionAsValue.mrt
(24.89 KiB) Downloaded 168 times
Post Reply