Custom DataSets

Is there any way to add a dataset to RS without it being a SP or Query? I
have .Net code that handles all of the database connections and SP calls and
returns datasets that I would like to plug into RS for my repotsOn Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> Is there any way to add a dataset to RS without it being a SP or Query? I
> have .Net code that handles all of the database connections and SP calls and
> returns datasets that I would like to plug into RS for my repots
You could try using the Code section (via: Layout view >> Report drop-
down >> Report Properties... >> Code tab); however, I'm not certain
that it will work. That said, its best for performance for you to use
the built in dataset options available (preferably stored procedure-
based datasets). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks I will keep that in mind.. the only issue I have with the SP route is
moving the code across environments(DEV, TEST to PRD). Each of these
environments are on different servers with different connection strings.
"EMartinez" wrote:
> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> > Is there any way to add a dataset to RS without it being a SP or Query? I
> > have .Net code that handles all of the database connections and SP calls and
> > returns datasets that I would like to plug into RS for my repots
>
> You could try using the Code section (via: Layout view >> Report drop-
> down >> Report Properties... >> Code tab); however, I'm not certain
> that it will work. That said, its best for performance for you to use
> the built in dataset options available (preferably stored procedure-
> based datasets). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||You can do data processing extension but it is non-trivial and I really
recommend against it.
As far as moving across Dev/Test/Production. This is no problem whatsoever.
While reports can have their own per report data source I strongly suggest
not doing that. Instead you use shared data sources. The first time you
deploy a report based on a shared datasource the datasource gets deployed.
By default thereafter the data source does not get deployed. After the first
deployment of the datasource you set up the connection strings and
credentials for that data source. For each place (Dev/test/production) you
would have different connections/credentials.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> Thanks I will keep that in mind.. the only issue I have with the SP route
> is
> moving the code across environments(DEV, TEST to PRD). Each of these
> environments are on different servers with different connection strings.
> "EMartinez" wrote:
>> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
>> > Is there any way to add a dataset to RS without it being a SP or Query?
>> > I
>> > have .Net code that handles all of the database connections and SP
>> > calls and
>> > returns datasets that I would like to plug into RS for my repots
>>
>> You could try using the Code section (via: Layout view >> Report drop-
>> down >> Report Properties... >> Code tab); however, I'm not certain
>> that it will work. That said, its best for performance for you to use
>> the built in dataset options available (preferably stored procedure-
>> based datasets). Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant|||On Dec 21, 8:50 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can do data processing extension but it is non-trivial and I really
> recommend against it.
> As far as moving across Dev/Test/Production. This is no problem whatsoever.
> While reports can have their own per report data source I strongly suggest
> not doing that. Instead you use shared data sources. The first time you
> deploy a report based on a shared datasource the datasource gets deployed.
> By default thereafter the data source does not get deployed. After the first
> deployment of the datasource you set up the connection strings and
> credentials for that data source. For each place (Dev/test/production) you
> would have different connections/credentials.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Adam" <A...@.discussions.microsoft.com> wrote in message
> news:2E856BD3-2D8F-430F-8CDD-C67A3160BC08@.microsoft.com...
> > Thanks I will keep that in mind.. the only issue I have with the SP route
> > is
> > moving the code across environments(DEV, TEST to PRD). Each of these
> > environments are on different servers with different connection strings.
> > "EMartinez" wrote:
> >> On Dec 20, 4:37 pm, Adam <A...@.discussions.microsoft.com> wrote:
> >> > Is there any way to add a dataset to RS without it being a SP or Query?
> >> > I
> >> > have .Net code that handles all of the database connections and SP
> >> > calls and
> >> > returns datasets that I would like to plug into RS for my repots
> >> You could try using the Code section (via: Layout view >> Report drop-
> >> down >> Report Properties... >> Code tab); however, I'm not certain
> >> that it will work. That said, its best for performance for you to use
> >> the built in dataset options available (preferably stored procedure-
> >> based datasets). Hope this helps.
> >> Regards,
> >> Enrique Martinez
> >> Sr. Software Consultant
You're welcome. Also, you could have a table that exists in every
environment that basically tells what the environment is and the
locations of the remote environments and uses linked servers to
execute the local stored procedure of the desired environment. Hope
this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant

Custom Data Extensions - Multiple Datasets.

Hi,
I know your probably going to tell me that this is not possible, but I am a
whisker away from getting it to work.. So there must be a way.
I have managed to extend reporting services with my own Data Processing
Extension (DPE).
With the combination of a dynamic web service proxy generator and the RDL
params provided by the Report Designer wizard i.e., Connectionstring & Query
I am able to call a web service dynamically and return a serialized dataset
from a web method.
This is then used by reporting services report designer wizard to provide a
list of fields in the dataset which are then used to layout the report.
Connectionstring = WebService URL e.g. http://local/mywebservice.asmx
Query = WebMethod e.g. GetDataset
It works great with a single dataset.
Now,
All this is done at run-time, and I know at design time it is possible to
add multiple datasets which gives you the nifty drop down list of datasets in
the fields window.
However, I have a dataset which contains multiple datasets and I wish to do
the same thing that reporting services does at design-time but at run-time.
Structure:
========== DataSet 1
DataSet A
DataSet B
DataSet C
Just for further information, I am extending the IDataReader Interface and
passing back the dataset through the Systems.Collections.IEnumerator
Interface.we are doing the same thing in my company please contact me at
andrescampos99@.hotmail.com with the source code and we will glad to assist you
"eskimo" wrote:
> Hi,
> I know your probably going to tell me that this is not possible, but I am a
> whisker away from getting it to work.. So there must be a way.
> I have managed to extend reporting services with my own Data Processing
> Extension (DPE).
> With the combination of a dynamic web service proxy generator and the RDL
> params provided by the Report Designer wizard i.e., Connectionstring & Query
> I am able to call a web service dynamically and return a serialized dataset
> from a web method.
> This is then used by reporting services report designer wizard to provide a
> list of fields in the dataset which are then used to layout the report.
> Connectionstring = WebService URL e.g. http://local/mywebservice.asmx
> Query = WebMethod e.g. GetDataset
> It works great with a single dataset.
> Now,
> All this is done at run-time, and I know at design time it is possible to
> add multiple datasets which gives you the nifty drop down list of datasets in
> the fields window.
> However, I have a dataset which contains multiple datasets and I wish to do
> the same thing that reporting services does at design-time but at run-time.
> Structure:
> ==========> DataSet 1
> DataSet A
> DataSet B
> DataSet C
> Just for further information, I am extending the IDataReader Interface and
> passing back the dataset through the Systems.Collections.IEnumerator
> Interface.