how to dynamically create report in web app?

Hello,
I am rather new to report service. What I want to achieve is prvide a web
page and let users to choose what fields they want to see, what table they
want to query and what formats they want to apply.
Is it something achievable? Would someone give me some tutorial or hints?
Many Thanks
--
hello, please helpAlthough possible it is not trivial. You need to know the RDL specification
(go to MSDN.microsoft.com and search on RDL specification, there are several
articles). Then there is the issue that this is a server based product, you
cannot change the RDL on the fly. You have to publish the RDL. With RS 2005
you can use the new controls and give the control the RDL and the dataset
(in local mode you do not even need the server). These controls come with VS
2005 (Not with SQL Server). So, check out the spec and see if this is really
something you want to tackle. Depending on the complexity you might be
better off to use XML and XSL instead.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jerry.xuddd" <jerryxuddd@.discussions.microsoft.com> wrote in message
news:78300BE1-38D8-4491-997D-2C4C0EC98AFE@.microsoft.com...
> Hello,
> I am rather new to report service. What I want to achieve is prvide a web
> page and let users to choose what fields they want to see, what table they
> want to query and what formats they want to apply.
> Is it something achievable? Would someone give me some tutorial or hints?
> Many Thanks
> --
> hello, please help

How to do calculation in Stored Procedure

Hi All,

Can anyone show me how to do a calculation in stored procedure? What I want to achieve is:
Employee has a different commission on each order, but what I would like to get is the total commission for all the orders that he/she accomplished so far.
Can anyone help me to write a query for this?

Thanks in advance.

Anyone please...|||

Try something like this:

SELECT EmployeeID, SUM(Commission) AS TotalCommission FROM yourOrderTable

GROUP BY EmployeeID

|||Thanks, I got it. I was thinking too complicated.

How to do a join in multiple datasets

I have two datasets accessed from two different data sources.
I would like to display the report by doing a join between the two. How can
I achieve that?
This join can not take place at data source level.Man that's a tough one.
I wonder if you could set the reports' data source to a custom assembly
which brings the two data sources together?
Alternatively, I suppose you could link the two datasources through another
database say Access if that's an option.
HTH
Matt
"Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
news:A729C0A5-ECC4-4337-B88F-0DF072FA2202@.microsoft.com...
> I have two datasets accessed from two different data sources.
> I would like to display the report by doing a join between the two. How
can
> I achieve that?
> This join can not take place at data source level.
>