http://biqubans.files.wordpress.com/2009/02/ppscomments_6.png?w=780

Here you go!

It was attached to the post. I don't know why you can't see it.

And thank you for your help! I appreciate it.

The solution to this specific problem is less important to me compared to finding possibilty of addressing one of multiple columns that appear from single text box.

Please look at this...

I have:

----------------------January-February-March

GB------London------200------100------120

France--Paris--------300------212------213

And I want to have:

----------------------January-February-March-Difference

GB------London------200------100------120------20

France--Paris--------300------212------213------1

Original query has 100+ lines so I made it very simple.

with Data (country, period, city, balance)

as (

select country, period

,city, SUM(money) as balance

from sometable

group by country, period

,city

)

select country

,period as Month

,city

,balance

from...

I should mention one thing. Months that are displayed in the report are determined by parameter @Month, which is determined by the user.

SQL query which provides data looks like

Month---Country---City------Balance

1---------GB--------London---110

and so...