Any easy way to create SQL on the fly with RS?

I am very new to reporting services. I am using reporting services
with Visual Web Developer and my database is Oracle 10g.
I have successfully created reports using the MS reporting services.
Data were pulled out from Oracle 10g through pre-defined SQL.
I would like to display on the web a list of fields that my end users
can select, and then my web application creates the SQL command on the
fly according to end users' selection criteria. Any easy way to do
this with the reporting services?
I hope that I have made clear what effect I would like to achieve. If
not, please ask. Thanks.If you are using SSRS 2005 then you got the answer. Just have a look at what
is called "Report Model" where in you can create a view where you can give
the readable column names and the users can drag and drop to get the reports.
Amarnath
"antonyliu2002@.yahoo.com" wrote:
> I am very new to reporting services. I am using reporting services
> with Visual Web Developer and my database is Oracle 10g.
> I have successfully created reports using the MS reporting services.
> Data were pulled out from Oracle 10g through pre-defined SQL.
> I would like to display on the web a list of fields that my end users
> can select, and then my web application creates the SQL command on the
> fly according to end users' selection criteria. Any easy way to do
> this with the reporting services?
> I hope that I have made clear what effect I would like to achieve. If
> not, please ask. Thanks.
>|||Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
> "antonyliu2002@.yahoo.com" wrote:
> > I am very new to reporting services. I am using reporting services
> > with Visual Web Developer and my database is Oracle 10g.
> >
> > I have successfully created reports using the MS reporting services.
> > Data were pulled out from Oracle 10g through pre-defined SQL.
> >
> > I would like to display on the web a list of fields that my end users
> > can select, and then my web application creates the SQL command on the
> > fly according to end users' selection criteria. Any easy way to do
> > this with the reporting services?
> >
> > I hope that I have made clear what effect I would like to achieve. If
> > not, please ask. Thanks.
> >
That sounds great. I am not sure which version I am using, but I just
downloaded it a few weeks ago from Microsoft as a plug-in for Visual
Web Developer. I'll check it out.|||> Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
>
Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
2005. I was not able to see anything called "Report Model" in VWD.
As I mentioned before, I've successfully created reports using this
Add-in. But the reports I created were predefined. I would like to
let my web users select what data they would like to get from the
database, and then create the SQL on the fly. I hope that I can do
this with this Reporting Add-in.
Any idea about how I can do this? Thanks.|||antonyliu2002@.yahoo.com wrote:
> > Amarnath wrote:
> > If you are using SSRS 2005 then you got the answer. Just have a look at what
> > is called "Report Model" where in you can create a view where you can give
> > the readable column names and the users can drag and drop to get the reports.
> >
> > Amarnath
> >
> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
> 2005. I was not able to see anything called "Report Model" in VWD.
> As I mentioned before, I've successfully created reports using this
> Add-in. But the reports I created were predefined. I would like to
> let my web users select what data they would like to get from the
> database, and then create the SQL on the fly. I hope that I can do
> this with this Reporting Add-in.
> Any idea about how I can do this? Thanks.
I've googled a little bit, and the tutorials I found on creating
reporting models all use BI Development Studio. Does this mean that I
cannot possibly create a reporting model with the Add-in in Visual Web
Developer 2005?|||The BI tools come with their own version of VS. If you have it, it
integrates with it. If not, then it installs it. This means that VS 2005
does not need to be purchased.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161640436.894263.5660@.i3g2000cwc.googlegroups.com...
> antonyliu2002@.yahoo.com wrote:
>> > Amarnath wrote:
>> > If you are using SSRS 2005 then you got the answer. Just have a look at
>> > what
>> > is called "Report Model" where in you can create a view where you can
>> > give
>> > the readable column names and the users can drag and drop to get the
>> > reports.
>> >
>> > Amarnath
>> >
>> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
>> 2005. I was not able to see anything called "Report Model" in VWD.
>> As I mentioned before, I've successfully created reports using this
>> Add-in. But the reports I created were predefined. I would like to
>> let my web users select what data they would like to get from the
>> database, and then create the SQL on the fly. I hope that I can do
>> this with this Reporting Add-in.
>> Any idea about how I can do this? Thanks.
> I've googled a little bit, and the tutorials I found on creating
> reporting models all use BI Development Studio. Does this mean that I
> cannot possibly create a reporting model with the Add-in in Visual Web
> Developer 2005?
>|||> Bruce L-C [MVP] wrote:
> The BI tools come with their own version of VS. If you have it, it
> integrates with it. If not, then it installs it. This means that VS 2005
> does not need to be purchased.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
Thanks, Bruce, are you suggesting that the BI Development Studio is
free? Where can I get it?
I have no Visual Studio 2005, what I have is the free Visual Web
Developer 2005.|||It is free. It comes on the SQL Server media.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161658217.724868.128170@.b28g2000cwb.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> The BI tools come with their own version of VS. If you have it, it
>> integrates with it. If not, then it installs it. This means that VS 2005
>> does not need to be purchased.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
> Thanks, Bruce, are you suggesting that the BI Development Studio is
> free? Where can I get it?
> I have no Visual Studio 2005, what I have is the free Visual Web
> Developer 2005.
>|||> Bruce L-C [MVP] wrote:
> It is free. It comes on the SQL Server media.
>
Thanks, Bruce.
Before I proceed, I have a question. We don't use MS SQL Server as our
database behind our web application. Instead, we use Oracle 10g. Will
I be able to create a web-based application that allows users to create
ad-hoc reports using the SQL Server reporting services and Oracle 10g?
Thanks.|||Developers yes, end users no.
Report Designer is for developers and that works against Oracle. For end
users there is a another tool where first a developer/dba creates a model
and that model is used by the end users to create their own reports. Models
can not be created against Oracle data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161703326.930679.107880@.i3g2000cwc.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> It is free. It comes on the SQL Server media.
> Thanks, Bruce.
> Before I proceed, I have a question. We don't use MS SQL Server as our
> database behind our web application. Instead, we use Oracle 10g. Will
> I be able to create a web-based application that allows users to create
> ad-hoc reports using the SQL Server reporting services and Oracle 10g?
> Thanks.
>|||> Bruce L-C [MVP] wrote:
> Developers yes, end users no.
> Report Designer is for developers and that works against Oracle. For end
> users there is a another tool where first a developer/dba creates a model
> and that model is used by the end users to create their own reports. Models
> can not be created against Oracle data.
>
Thanks, Bruce.
I am new to Reporting Services. The kind of reports I've managed to
create with the Reporting Services Add-in in Visual Web Developer are
from predefined SQL queries.
Just for the purpose of simplicity, suppose that in my web application,
I present the names of 10 students in a dropdown list. I would like to
let my web users select one of these students and then I construct the
sql query on the fly, and create a report about this selected student
only.
Is this do-able with the Reporting Services Add-in in Visual Web
Developer 2005 Express Edition?
Thanks.