Accessing grouped values "inside" fields

Hello,
I'm struggling to make operations on results obtained from grouping by
specific dimensions. To be more specific, I'd like to substract value of
e.g. sales for some product for one year from values from the preceding
year.
I'd like to somehow access the resulting recordset from grouping and make
some operations on these values, just like the SUBTOTAL function does.
Thanks in advance for any help.
Best wishes,
Marek T³uczekOne correction to my question:
> I'd like to somehow access the resulting recordset from grouping and make
> some operations on these values, just like the SUBTOTAL function does.
I meant not recordset, but set of fields.
> Thanks in advance for any help.
> Best wishes,
> Marek T³uczek
>
>

accessing external webservice or webpage from SQL 2005

Is it possible to access a webservice from within SQL 2005?

What I am looking to do is place a trigger on a specific table, and detect if a specific column is being updated. If it is, I want to launch a robust process that does x, y and z. Something like this:

1) record is updated indicating that an account is closed.

2) SQL launched a webservice/ aspx page that builds an HTML email template and then mail it.

thanks!

SQL Server 2005 does have XML web service support. Seehttp://msdn2.microsoft.com/en-us/library/ms191274.aspx.|||

Wow, thanks for the speedy reply. The documentation behind the link you sent seems to refer to SQL server fielding SOAP requests and "listening" to and delivering data, where the SQL server is processing the request.

But is the opposite possible? SQL calling another webservice?

Access specific Graph data

Hello again
I have a graph which lists cell phone minutes broken down by month. I want the specific data for that month to show in either a matrix or table underneath the graph. The key is that I just want the date for that month only. When the user clicks on a specific month on the graph I just want to show that months data. I know how to accomplish this using the "jump to report" option with parameters,but how do I do this on the same report -- right underneath the graph?

thanks
km

Try SubReport.

SubReport is the report where you can view the main report and drilled down report (sub report) in the same window.

1)the development includes design of a new subreport

2) Have an item called "subreport" in the main report where you want to place that is beneath

3) assign the subreport properties to get your newly developed report(Name of the report,Parameters)

4) Control the visibiliy of the subreport.

Thanks

|||great thanks
appreciate the help
km