Dynamically Generating SMDL (Report Model Definitions) With C#

My problem is this: How do I dynamically generate a Report Model Definition with c#?

Is there some sort of method I could call from the ReportingService2005 web service? Or some sort of APIs I could use?

If I didn't have a dynamic database structure, I would just create a Report Model Definition with BIS and then deploy the same model to each customer. However, our product creates additional tables in the database, depending on what data users wish to collect.

There are currently 2 solutions for this problem. First, I can manually create a Report Model Definition through the Buisness Intelligence Studio (BIS). However, I wish to be able to dynamically generate the report model without having to go through BIS. Second, I could use C# and manually write the XML of the SMDL. However this seems problematic.

I'm really hoping for some MS API that I'm missing out on here. Thanks for the help.

- Sean

I asked MS about this and they said they currently do not have any APIs to accomplish this at this time.

Still searching for ideas.

|||

I was also looking for similar functionality. Let me know in case you find a solution.

Thanks,

-Suri

|||

Suri,

I was unable to find an API or anything definitive to fix this. However, what I am doing is creating a class to populate with information from my database and then serialize it into XML to insert into the SMDL.

I'm actually just designing the class right now. I'd recommend this page in MSDN

http://msdn2.microsoft.com/en-us/library/ms159611.aspx

I hope this helps.

|||

There is API method GenerateModel

|||

Excellent.

You saved me a lot of time. I'll use the similiar RegenerateModel method:

//Get the webservice
wsRS2005.ReportingService2005 r = new TNTSMDL.wsRS2005.ReportingService2005();

//Set the Credentials
r.Credentials = System.Net.CredentialCache.DefaultCredentials;

//Regenerate the Model in the database
r.RegenerateModel(@."/Models/NewModel");

POOF. It is generated. Thanks Again!

|||is there a sample available?

Dynamically Generating SMDL (Report Model Definitions) With C#

My problem is this: How do I dynamically generate a Report Model Definition with c#?

Is there some sort of method I could call from the ReportingService2005 web service? Or some sort of APIs I could use?

If I didn't have a dynamic database structure, I would just create a Report Model Definition with BIS and then deploy the same model to each customer. However, our product creates additional tables in the database, depending on what data users wish to collect.

There are currently 2 solutions for this problem. First, I can manually create a Report Model Definition through the Buisness Intelligence Studio (BIS). However, I wish to be able to dynamically generate the report model without having to go through BIS. Second, I could use C# and manually write the XML of the SMDL. However this seems problematic.

I'm really hoping for some MS API that I'm missing out on here. Thanks for the help.

- Sean

I asked MS about this and they said they currently do not have any APIs to accomplish this at this time.

Still searching for ideas.

|||

I was also looking for similar functionality. Let me know in case you find a solution.

Thanks,

-Suri

|||

Suri,

I was unable to find an API or anything definitive to fix this. However, what I am doing is creating a class to populate with information from my database and then serialize it into XML to insert into the SMDL.

I'm actually just designing the class right now. I'd recommend this page in MSDN

http://msdn2.microsoft.com/en-us/library/ms159611.aspx

I hope this helps.

|||

There is API method GenerateModel

|||

Excellent.

You saved me a lot of time. I'll use the similiar RegenerateModel method:

//Get the webservice
wsRS2005.ReportingService2005 r = new TNTSMDL.wsRS2005.ReportingService2005();

//Set the Credentials
r.Credentials = System.Net.CredentialCache.DefaultCredentials;

//Regenerate the Model in the database
r.RegenerateModel(@."/Models/NewModel");

POOF. It is generated. Thanks Again!

|||is there a sample available?|||

Hello Sean,

Can you post the complete code for "RegenerateModel" method?

It would save lot of development time.

Thanks

Dynamically Generating SMDL (Report Model Definitions) With C#

My problem is this: How do I dynamically generate a Report Model Definition with c#?

Is there some sort of method I could call from the ReportingService2005 web service? Or some sort of APIs I could use?

If I didn't have a dynamic database structure, I would just create a Report Model Definition with BIS and then deploy the same model to each customer. However, our product creates additional tables in the database, depending on what data users wish to collect.

There are currently 2 solutions for this problem. First, I can manually create a Report Model Definition through the Buisness Intelligence Studio (BIS). However, I wish to be able to dynamically generate the report model without having to go through BIS. Second, I could use C# and manually write the XML of the SMDL. However this seems problematic.

I'm really hoping for some MS API that I'm missing out on here. Thanks for the help.

- Sean

I asked MS about this and they said they currently do not have any APIs to accomplish this at this time.

Still searching for ideas.

|||

I was also looking for similar functionality. Let me know in case you find a solution.

Thanks,

-Suri

|||

Suri,

I was unable to find an API or anything definitive to fix this. However, what I am doing is creating a class to populate with information from my database and then serialize it into XML to insert into the SMDL.

I'm actually just designing the class right now. I'd recommend this page in MSDN

http://msdn2.microsoft.com/en-us/library/ms159611.aspx

I hope this helps.

|||

There is API method GenerateModel

|||

Excellent.

You saved me a lot of time. I'll use the similiar RegenerateModel method:

//Get the webservice
wsRS2005.ReportingService2005 r = new TNTSMDL.wsRS2005.ReportingService2005();

//Set the Credentials
r.Credentials = System.Net.CredentialCache.DefaultCredentials;

//Regenerate the Model in the database
r.RegenerateModel(@."/Models/NewModel");

POOF. It is generated. Thanks Again!

|||is there a sample available?|||

Hello Sean,

Can you post the complete code for "RegenerateModel" method?

It would save lot of development time.

Thanks

Dynamically generating RDL

I would like to point my Report Server to an ASPX page that outputs RDL.
Can this be done? Any examples or tutorials that anyone can point me to?
Thanks!
-mdbNot very easily. RS is a server based product. You have to deploy the RDL to
the server. BUT, with VS 2005 you have two new controls that have a local
mode, no server required. You can give the control your RDL (for these
controls it will be a RDLC file). It has to be RS 2005 format. These
controls come with VS, not SQL Server.
I really recommend checking out the controls. If generating RDL these
controls will make it much much much easier.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael Bray" <mbray@.makeDIntoDot_ctiusaDcom> wrote in message
news:Xns9746A0025EBA5mbrayctiusacom@.207.46.248.16...
>I would like to point my Report Server to an ASPX page that outputs RDL.
> Can this be done? Any examples or tutorials that anyone can point me to?
> Thanks!
> -mdb

Dynamically generate SqlDataSource

Hi, how I do create SqlDataSource in thecode-behind,setting Select SQL along with its parameters and, finallyautomically generating Del, Update, Insert SQL.

Is there a way to achieve this goal as it would in VS designer?

Thanks,

Ricky.

It is possible to create the TSQL code and wrapper code automatically by a variety of means. I use TSQL scripts to do the generation from within Query Analyser.

Which version of SQL Server are you targetting?

|||

Hi, I use SQL SERVER 2005

Thanks,

Ricky.