Prev: reports that produce no data
Next: how to stop subreports shifting horizontally if no data?
From: kjgreen1112 on 28 Feb 2010 10:14
I have a report where the customer is the rows and each column is a month o
total sales. it works, but I am show ALL the dates when I want to limit it to
the last 12 months as of today. I am not sure how to do this.

Any help is appreciated.

From: Uri Dimant on 28 Feb 2010 10:20
Hi
Can you format it via T-SQL?

"kjgreen1112" <u58480(a)uwe> wrote in message news:a4502ea3b183d(a)uwe...
>I have a report where the customer is the rows and each column is a month o
> total sales. it works, but I am show ALL the dates when I want to limit it
> to
> the last 12 months as of today. I am not sure how to do this.
>
> Any help is appreciated.
>


From: kjgreen1112 on 28 Feb 2010 15:17
If I could get this working in SSRS I can change it from a Matrix to a table
report. Any help is appreciated on this too.

In my table I have Customer, Year, Period: and Balnce (I am doing the work
there before I being it into my report.


I neeed to have customer going down and 13 months going across.


jan feb mar
123 1 1 1
234 1 1 1
456


I had a detailed table I was running off of and this the the formula we were
using in crystal. I can go back to this IF I can get the formaul below
working ...which has been an issue.

if year({TEST.DOCDATE}) = year(DateAdd ("m", -1, today()))
then if
month ({Test.DOCDATE}) = month(DateAdd ("m", -1, today()))
then {@Tx Amount}
else 0





Uri Dimant wrote:
>Hi
>Can you format it via T-SQL?
>
>>I have a report where the customer is the rows and each column is a month o
>> total sales. it works, but I am show ALL the dates when I want to limit it
>> to
>> the last 12 months as of today. I am not sure how to do this.
>>
>> Any help is appreciated.

 | 
Pages: 1
Prev: reports that produce no data
Next: how to stop subreports shifting horizontally if no data?