layout problem

hi all,

i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this:

store day transfers amount

1 1 1 2.50

1 2 5 3.50

2 1 2 1

and i want to put it in a report like this

store monday tuesday

1 1 / 2.50 5 / 3.50

2 2 / 1

i tried with a matrix but the the result wasnt satisifiying. the best one looked like this:

store monday tuesday

1 1 / 2.50

1 5 / 3.50

2 2 / 1

anyone can give a solution or atleast some hints?

drop store to the row group and day to the column group should satisfy your need.

Launching Web Page From SQL

Hello All,

I'm not very knowledgable about SQL server so I'm not quite sure if this is possible. I want a scheduled task to be ran everyday. (Querying the Database and such). If a certain parameter is met I want a webpage, w/ code behind that will send an email, to be launched.

Is there any way to launch a web page from SQL??

Thanks in advance,

Kyle Landis

Do you want web page to send e-mail only? The SQL Server cansend e-mail too.