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