Variable Headings in Report

[deodev]

I am liking to a SQL table that is has the following data.

id name period stdvalue extvalue bilvalue colvalue

22 test1 1104 100 150 125 100
22 test1 1204 20 50 75 75
22 test1 0105 20 50 75 75
25 test2 1204 20 50 75 75
25 test3 1204 20 50 75 75

through several crosstab queries, I was able to create a report in the
following layout:

ID: 22 Name: Test1
1104 1204 0105 YTD
stdvalue
extvalue
bilvalue
colvalue

My fiscal year is from Nov to Oct.

I would like my report to show a rolling 6 month and a Fiscal year to date
total.

for example in Feb 05, I would show periods June 04 through Jan 05, Feb05 is
not included since it is a partial month.

The table only have period up to the current month. That is in Feb05, there
would not be periods 0305, 0405, 0505 etc.

Any suggestions on how to dynamically create the appropriate rolling 6 month
columns?

 

[David Lloyd]

The following KB article may be of assistance:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328320

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.



I am liking to a SQL table that is has the following data.

id name period stdvalue extvalue bilvalue colvalue

22 test1 1104 100 150 125 100
22 test1 1204 20 50 75 75
22 test1 0105 20 50 75 75
25 test2 1204 20 50 75 75
25 test3 1204 20 50 75 75

through several crosstab queries, I was able to create a report in the
following layout:

ID: 22 Name: Test1
1104 1204 0105 YTD
stdvalue
extvalue
bilvalue
colvalue

My fiscal year is from Nov to Oct.

I would like my report to show a rolling 6 month and a Fiscal year to date
total.

for example in Feb 05, I would show periods June 04 through Jan 05, Feb05 is
not included since it is a partial month.

The table only have period up to the current month. That is in Feb05, there
would not be periods 0305, 0405, 0505 etc.

Any suggestions on how to dynamically create the appropriate rolling 6 month
columns?

 

[deodev]

Thanks