Re Simple Customer Statement Report

[Andre2]

Hi All
I wonder if anyone has a sample of a simple customer outstanding invoice statement form/report
showing current,30 days,60 Days,90 Days + outstanding balances.

The data is in the format
Invoice Date,Invoice Number,Balance owing
1 jan 08,0001,1000.00
1 dec 07 0002,500.00
1 nov 07,0003,500.00...etc

And at the footer of the report would be some sort of cross tab report

Current 30 Days 60 days 90 Days + Total owing
$0.00 $0.00 $0.00 $2000.00 $2000.00

I can do the invoice line item without problem but cannot get my head around how to do the cross tab with calculated date periods

Many Thanks
Andre

[Edward]

Please see the example report in the attachment.

You can open it in the demo.exe sample application.

It uses ternary operation for its work and an expression inside appropriate column or row.

Thank you.

[Andre2]

Thank you for your post and the demo.
Let me stress that I am new to the world of microsoft programing and there are many things in the VB.net and C# lanuage I have yet to master.

I can create the results I need by the use of sql statements such as

SQL: sum(Case datepart(mm,Invoice.Date) when 2 then AmtOwing else 0 end) as febtotal,

but my understanding is that crosstab reports do this for me.

At this stage, I still dont see how to get the crosstab to work, if in fact it is able to produce such a result

Anyway thanks again

[Edward]

Please modify a little bit the report I sent you in my previous post.

There is a StartDate variable of 'DateTime' type which is necessary for setting start date.

In the DisplayValue of the 'Cross_Tab1_Column1' crosstab cell the following expression may be set:

Code: Select all

{(Orders.OrderDate=StartDate.AddDays(-30))?"30 days ":
 (Orders.OrderDateStartDate.AddDays(-60))?"60 days ":
 (Orders.OrderDateStartDate.AddDays(-90))?"90 days ":
"earlier "
}

In the Value of this cell expression was set as follows:

Code: Select all

{(Orders.OrderDate=StartDate.AddDays(-30))?1:
 (Orders.OrderDateStartDate.AddDays(-60))?2:
 (Orders.OrderDateStartDate.AddDays(-90))?3:
4
}

'Sort Type' property of this cell was set in 'by value'.

Now the result of the Crosstab looks almost as you required.

Please see the report in attachment.

Thank you.

[Andre2]

Thank you very much for that help...i now have a little understanding of how the Crostab works.

Just one thing...the crosstab wont show a 0.00 if no invoices are found for the period.

how do I force it to show

90 days 60 days 30days Current Total
450.00 0.00 0.00 0.00 450.00

The way it currently works as per your example is

90 days Total
450.00 450.00

Again Thanks

[Edward]

Cross-Tab has an 'EmptyValue' property. Please set it in 0.00.

Thank you.

[Andre2]

Tried that but it made no difference
thanks

[Edward]

I checked it write now. It works on my computer.

Please inform me about version Stimulsoft Reports.Net that you are using. You can find this information in the Designer:

Help- About.

Thank you.

[Andre2]

Ok Ran your report on my Machine and it showed no difference
im using 2008.1.200

Thanks

[Andre2]

Just updated to 2008.1.228 with the same result

What version are you using
Thanks