Programmatically create a Report Model

We would like to take advantage of the Report Builder tool to provide
end-user ad-hoc reporting. The database for the application can be
different depending on how the client configures it (they can add various
fields and data collection forms). At TechEd, I attended a session on
Microsoft Dynamics AX 4.0 and its tight integration with Reporting
Services/Report Builder. This is very much in line with what we'd like to
do. I imagine the users adding a field (through our interface), setting a
few properties, and then after some automated process occurs, they would be
able to use Report Builder to access any data collected in that field.
What we'd like to do is programmatically generate and maintain a report
model based on how the individual install is configured. I've found some
documentation that makes me believe this is possible, but I'm hoping someone
can nudge me in the right direction. The ReportingServices2005 class has
several model related methods (CreateModel) and I found the .xsd for the
semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document
from scratch. Looking at the files generated from BIDS is somewhat
overwhelming and I have no idea where I'd pull most of the information.
Any help that can be provided would be greatly appreciated. Thanks!
RussellHi Russell,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
programmatically manage the Report Model xml file (smdl). If I
misunderstood your concern, please feel free to let me know.
I would like to know what information you want to pull from the Report
Model. The smdl file is a xml file and I think you could control the file
in VS .NET.
The CreateModel of the Reporting Services 2005 class is used to upload the
Report Model file to Report Server. I think it is not quite meet your
requirement.
Here is an article about refine a report model.
Refining a Report Model
http://www.sqlmag.com/Article/ArticleID/50048/sql_server_50048.html
Hope this information will be helpful and please let me know the result.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russell,
I would like to know whether the information is helpful. Feel free to let
me know if you have any questions.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russel
did you have any success with that? did you solve it by creating the SMDL
File with an XMLTextWriter or did you find an other solution? an oblect that
could be referenced?
i am having the same problem and would like to establish the SMDL file fully
by code, from scratch.
any info is appreciated.
Kind Regards, Rene
"RussellReed" schrieb:
> We would like to take advantage of the Report Builder tool to provide
> end-user ad-hoc reporting. The database for the application can be
> different depending on how the client configures it (they can add various
> fields and data collection forms). At TechEd, I attended a session on
> Microsoft Dynamics AX 4.0 and its tight integration with Reporting
> Services/Report Builder. This is very much in line with what we'd like to
> do. I imagine the users adding a field (through our interface), setting a
> few properties, and then after some automated process occurs, they would be
> able to use Report Builder to access any data collected in that field.
> What we'd like to do is programmatically generate and maintain a report
> model based on how the individual install is configured. I've found some
> documentation that makes me believe this is possible, but I'm hoping someone
> can nudge me in the right direction. The ReportingServices2005 class has
> several model related methods (CreateModel) and I found the .xsd for the
> semantic model XML file
> (http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
> but no real documentation on how to put together a Report Model document
> from scratch. Looking at the files generated from BIDS is somewhat
> overwhelming and I have no idea where I'd pull most of the information.
> Any help that can be provided would be greatly appreciated. Thanks!
> Russell
>
>