Passing dataset to ssrs

I'm still seeking my holy grail to figure out a way to pass a dataset, full
of data to SSRS at run time.
The work to build the dataset has to be done in my ASPX program. I figure I
could easily create a physical table containing the data at runtime with a
name made up of MyTable + Session number.
My SSRS report would have this exact table format defined but would not know
the table name.
Now I would like to find a way to dynamically pass the table name to SSRS
when I execute the report and find a way to modify the SQL in my SSRS report
when the parameter is received.
Is this feasible?
Thanks,
TTina,
Binding to datasets is not supported in version 1.0 so you need to write a
custom data extension to report off ADO.NET datasets or you can use mine
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
In addition, you can use my AwReportViewer web control (extended version of
the HTML Viewer control) which makes generating reports on the server side
of a web app plus dataset binding easier (I hope). You can download it from
here
http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
Please note that version 2005 of RS will include WinForm and ASP.NET
controls which will support binding to ADO.NET datasets.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Tina" <tinamseaburn@.removespamexcite.com> wrote in message
news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> I'm still seeking my holy grail to figure out a way to pass a dataset,
full
> of data to SSRS at run time.
> The work to build the dataset has to be done in my ASPX program. I figure
I
> could easily create a physical table containing the data at runtime with a
> name made up of MyTable + Session number.
> My SSRS report would have this exact table format defined but would not
know
> the table name.
> Now I would like to find a way to dynamically pass the table name to SSRS
> when I execute the report and find a way to modify the SQL in my SSRS
report
> when the parameter is received.
> Is this feasible?
> Thanks,
> T
>|||I've just posted a DPE this evening to
http://workspaces.gotdotnet.com/appworld that may help you or at least point
you in the right direction.
Regards
Toby
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> Tina,
> Binding to datasets is not supported in version 1.0 so you need to write a
> custom data extension to report off ADO.NET datasets or you can use mine
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> In addition, you can use my AwReportViewer web control (extended version
of
> the HTML Viewer control) which makes generating reports on the server side
> of a web app plus dataset binding easier (I hope). You can download it
from
> here
> http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> Please note that version 2005 of RS will include WinForm and ASP.NET
> controls which will support binding to ADO.NET datasets.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > I'm still seeking my holy grail to figure out a way to pass a dataset,
> full
> > of data to SSRS at run time.
> >
> > The work to build the dataset has to be done in my ASPX program. I
figure
> I
> > could easily create a physical table containing the data at runtime with
a
> > name made up of MyTable + Session number.
> >
> > My SSRS report would have this exact table format defined but would not
> know
> > the table name.
> >
> > Now I would like to find a way to dynamically pass the table name to
SSRS
> > when I execute the report and find a way to modify the SQL in my SSRS
> report
> > when the parameter is received.
> >
> > Is this feasible?
> > Thanks,
> > T
> >
> >
>|||Teo,
Thanks for the quick help. I'll ramp up on data extentions and then look at
these links. Do you have any idea of how far off version 2005 of RS is?
thanks,
T
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> Tina,
> Binding to datasets is not supported in version 1.0 so you need to write a
> custom data extension to report off ADO.NET datasets or you can use mine
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> In addition, you can use my AwReportViewer web control (extended version
of
> the HTML Viewer control) which makes generating reports on the server side
> of a web app plus dataset binding easier (I hope). You can download it
from
> here
> http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> Please note that version 2005 of RS will include WinForm and ASP.NET
> controls which will support binding to ADO.NET datasets.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > I'm still seeking my holy grail to figure out a way to pass a dataset,
> full
> > of data to SSRS at run time.
> >
> > The work to build the dataset has to be done in my ASPX program. I
figure
> I
> > could easily create a physical table containing the data at runtime with
a
> > name made up of MyTable + Session number.
> >
> > My SSRS report would have this exact table format defined but would not
> know
> > the table name.
> >
> > Now I would like to find a way to dynamically pass the table name to
SSRS
> > when I execute the report and find a way to modify the SQL in my SSRS
> report
> > when the parameter is received.
> >
> > Is this feasible?
> > Thanks,
> > T
> >
> >
>|||Tina,
I am sorry, but Microsoft will be in a better position to answer this
question.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Tina" <tinamseaburn@.removespamexcite.com> wrote in message
news:OnLF7JXgEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Teo,
> Thanks for the quick help. I'll ramp up on data extentions and then look
at
> these links. Do you have any idea of how far off version 2005 of RS is?
> thanks,
> T
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> > Tina,
> >
> > Binding to datasets is not supported in version 1.0 so you need to write
a
> > custom data extension to report off ADO.NET datasets or you can use mine
> >
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> > In addition, you can use my AwReportViewer web control (extended version
> of
> > the HTML Viewer control) which makes generating reports on the server
side
> > of a web app plus dataset binding easier (I hope). You can download it
> from
> > here
> > http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> >
> > Please note that version 2005 of RS will include WinForm and ASP.NET
> > controls which will support binding to ADO.NET datasets.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> > news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > I'm still seeking my holy grail to figure out a way to pass a dataset,
> > full
> > > of data to SSRS at run time.
> > >
> > > The work to build the dataset has to be done in my ASPX program. I
> figure
> > I
> > > could easily create a physical table containing the data at runtime
with
> a
> > > name made up of MyTable + Session number.
> > >
> > > My SSRS report would have this exact table format defined but would
not
> > know
> > > the table name.
> > >
> > > Now I would like to find a way to dynamically pass the table name to
> SSRS
> > > when I execute the report and find a way to modify the SQL in my SSRS
> > report
> > > when the parameter is received.
> > >
> > > Is this feasible?
> > > Thanks,
> > > T
> > >
> > >
> >
> >
>|||Teo,
I'm going thru your documentation. I'm at "Setting the Report DataSource"
and am having some trouble.
I Deployed, and registered the dataset extension and adjusted the code
access security policy as per your instructions.
Upon running the query I was prompted for the parameter value of @.DataSource
where I entered the path to my dsResults.xsd. It displayed the button
columns but no fields on the left. Because there are no fields on the left,
I can't design the report.
What do you think might be wrong?
Thanks,
T
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> Tina,
> Binding to datasets is not supported in version 1.0 so you need to write a
> custom data extension to report off ADO.NET datasets or you can use mine
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> In addition, you can use my AwReportViewer web control (extended version
of
> the HTML Viewer control) which makes generating reports on the server side
> of a web app plus dataset binding easier (I hope). You can download it
from
> here
> http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> Please note that version 2005 of RS will include WinForm and ASP.NET
> controls which will support binding to ADO.NET datasets.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > I'm still seeking my holy grail to figure out a way to pass a dataset,
> full
> > of data to SSRS at run time.
> >
> > The work to build the dataset has to be done in my ASPX program. I
figure
> I
> > could easily create a physical table containing the data at runtime with
a
> > name made up of MyTable + Session number.
> >
> > My SSRS report would have this exact table format defined but would not
> know
> > the table name.
> >
> > Now I would like to find a way to dynamically pass the table name to
SSRS
> > when I execute the report and find a way to modify the SQL in my SSRS
> report
> > when the parameter is received.
> >
> > Is this feasible?
> > Thanks,
> > T
> >
> >
>|||Tina,
Good job. Just hit the Refresh Fields toolbar button found on the Data tab.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Tina" <tinamseaburn@.removespamexcite.com> wrote in message
news:OLZsW1kgEHA.3016@.tk2msftngp13.phx.gbl...
> Teo,
> I'm going thru your documentation. I'm at "Setting the Report DataSource"
> and am having some trouble.
> I Deployed, and registered the dataset extension and adjusted the code
> access security policy as per your instructions.
> Upon running the query I was prompted for the parameter value of
@.DataSource
> where I entered the path to my dsResults.xsd. It displayed the button
> columns but no fields on the left. Because there are no fields on the
left,
> I can't design the report.
> What do you think might be wrong?
> Thanks,
> T
>
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> > Tina,
> >
> > Binding to datasets is not supported in version 1.0 so you need to write
a
> > custom data extension to report off ADO.NET datasets or you can use mine
> >
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> > In addition, you can use my AwReportViewer web control (extended version
> of
> > the HTML Viewer control) which makes generating reports on the server
side
> > of a web app plus dataset binding easier (I hope). You can download it
> from
> > here
> > http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> >
> > Please note that version 2005 of RS will include WinForm and ASP.NET
> > controls which will support binding to ADO.NET datasets.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> > news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > I'm still seeking my holy grail to figure out a way to pass a dataset,
> > full
> > > of data to SSRS at run time.
> > >
> > > The work to build the dataset has to be done in my ASPX program. I
> figure
> > I
> > > could easily create a physical table containing the data at runtime
with
> a
> > > name made up of MyTable + Session number.
> > >
> > > My SSRS report would have this exact table format defined but would
not
> > know
> > > the table name.
> > >
> > > Now I would like to find a way to dynamically pass the table name to
> SSRS
> > > when I execute the report and find a way to modify the SQL in my SSRS
> > report
> > > when the parameter is received.
> > >
> > > Is this feasible?
> > > Thanks,
> > > T
> > >
> > >
> >
> >
>|||Toby,
Thanks for the effort and credit :-) Your version wil be very useful in
cases when the data source needs to be configured during runtime.
"Toby" <toby.maillist@.exmlsystems.com> wrote in message
news:OIoYcmWgEHA.904@.TK2MSFTNGP09.phx.gbl...
> I've just posted a DPE this evening to
> http://workspaces.gotdotnet.com/appworld that may help you or at least
point
> you in the right direction.
> Regards
> Toby
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> > Tina,
> >
> > Binding to datasets is not supported in version 1.0 so you need to write
a
> > custom data extension to report off ADO.NET datasets or you can use mine
> >
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> > In addition, you can use my AwReportViewer web control (extended version
> of
> > the HTML Viewer control) which makes generating reports on the server
side
> > of a web app plus dataset binding easier (I hope). You can download it
> from
> > here
> > http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> >
> > Please note that version 2005 of RS will include WinForm and ASP.NET
> > controls which will support binding to ADO.NET datasets.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> > news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > I'm still seeking my holy grail to figure out a way to pass a dataset,
> > full
> > > of data to SSRS at run time.
> > >
> > > The work to build the dataset has to be done in my ASPX program. I
> figure
> > I
> > > could easily create a physical table containing the data at runtime
with
> a
> > > name made up of MyTable + Session number.
> > >
> > > My SSRS report would have this exact table format defined but would
not
> > know
> > > the table name.
> > >
> > > Now I would like to find a way to dynamically pass the table name to
> SSRS
> > > when I execute the report and find a way to modify the SQL in my SSRS
> > report
> > > when the parameter is received.
> > >
> > > Is this feasible?
> > > Thanks,
> > > T
> > >
> > >
> >
> >
>|||Theo,
After originally applying your changes I got security exceptions when ever I
tried to print any report. I then noticed that you had a strange double
quote character in your <codegroup changes where it says
...RS.Extensions.dll"/>. So, I changed it to a normal double quote. Now
whenever I try to print any report I get the exception clipped below. Can
you help?
Thanks,
T
Server Error in '/ReportServer' Application.
----
--
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Assembly reportingserviceswebserver.dll security
permission grant set is incompatible between appdomains.
Source Error:
Line 26: <assemblies>
Line 27: <clear />
Line 28: <add assembly="ReportingServicesWebServer" />
Line 29: </assemblies>
Line 30: </compilation>
Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\web.config Line: 28
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:uwTfyymgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> Tina,
> Good job. Just hit the Refresh Fields toolbar button found on the Data
tab.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> news:OLZsW1kgEHA.3016@.tk2msftngp13.phx.gbl...
> > Teo,
> > I'm going thru your documentation. I'm at "Setting the Report
DataSource"
> > and am having some trouble.
> >
> > I Deployed, and registered the dataset extension and adjusted the code
> > access security policy as per your instructions.
> >
> > Upon running the query I was prompted for the parameter value of
> @.DataSource
> > where I entered the path to my dsResults.xsd. It displayed the button
> > columns but no fields on the left. Because there are no fields on the
> left,
> > I can't design the report.
> >
> > What do you think might be wrong?
> > Thanks,
> > T
> >
> >
> > "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> > news:e2Sr6bWgEHA.1276@.TK2MSFTNGP09.phx.gbl...
> > > Tina,
> > >
> > > Binding to datasets is not supported in version 1.0 so you need to
write
> a
> > > custom data extension to report off ADO.NET datasets or you can use
mine
> > >
> >
>
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5.
> > > In addition, you can use my AwReportViewer web control (extended
version
> > of
> > > the HTML Viewer control) which makes generating reports on the server
> side
> > > of a web app plus dataset binding easier (I hope). You can download it
> > from
> > > here
> > > http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=0
> > >
> > > Please note that version 2005 of RS will include WinForm and ASP.NET
> > > controls which will support binding to ADO.NET datasets.
> > >
> > > --
> > > Hope this helps.
> > >
> > > ---
> > > Teo Lachev, MCSD, MCT
> > > Author: "Microsoft Reporting Services in Action"
> > > http://www.prologika.com
> > >
> > >
> > > "Tina" <tinamseaburn@.removespamexcite.com> wrote in message
> > > news:ObwTjOWgEHA.3932@.TK2MSFTNGP10.phx.gbl...
> > > > I'm still seeking my holy grail to figure out a way to pass a
dataset,
> > > full
> > > > of data to SSRS at run time.
> > > >
> > > > The work to build the dataset has to be done in my ASPX program. I
> > figure
> > > I
> > > > could easily create a physical table containing the data at runtime
> with
> > a
> > > > name made up of MyTable + Session number.
> > > >
> > > > My SSRS report would have this exact table format defined but would
> not
> > > know
> > > > the table name.
> > > >
> > > > Now I would like to find a way to dynamically pass the table name to
> > SSRS
> > > > when I execute the report and find a way to modify the SQL in my
SSRS
> > > report
> > > > when the parameter is received.
> > > >
> > > > Is this feasible?
> > > > Thanks,
> > > > T
> > > >
> > > >
> > >
> > >
> >
> >
>