Reporting Services Report Model

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I am trying to build a query tool that works like the sql server 2005 report
builder connected to a report model. But instead of building a report, I want
the tool to design sql queries based on a report model.

I would like for the users to select items from the model, apply filters,
grouping... then execute the query returning the result set into a grid. The
tool will then use the result set returned to do other things such as loading
into sql db.

Anyone have any ideas on where to start?

I have been trying to use the microsoft.reportingservices.. dlls such as
microsoft.reportingservices.semantecquerydesign.dll.

Thank You
Eric
 
Eric said:
I am trying to build a query tool that works like the sql server 2005 report
builder connected to a report model. But instead of building a report, I want
the tool to design sql queries based on a report model.

I would like for the users to select items from the model, apply filters,
grouping... then execute the query returning the result set into a grid. The
tool will then use the result set returned to do other things such as loading
into sql db.

Anyone have any ideas on where to start?

I have been trying to use the microsoft.reportingservices.. dlls such as
microsoft.reportingservices.semantecquerydesign.dll.

Thank You
Eric
Click to expand...

You mean that you want to create a tool like Report Builder, and your
tool will use Report Models to do something, not generate report like
Report Builder ?
Actually, I really don't know what protocol which Report Builder use to
communicate with Report Server is. Maybe I'm not be well aware of SQL
Reporting Service :)
 
Yes, I am trying to create a tool that works like report builder and
processes report models, but instead of rendering reports, I just want to get
the query result set back from the model, then do some work with the result
set such as export or import into another data source.

I have a need to get data to "power users" that know how to work with data,
but not relational. I have to build the models for other users anyway, now I
want to reuse those models uses other than reporting.

I have found some dll's that seem to work with reporting services and
models, but can't figure out how to get a model out of ssrs, select entities,
and send for query execution.

Microsoft.ReportingServices.SemanticQueryEngine
Microsoft.ReportingServices.SemanticQueryDesign

Thank You
Eric
 
Back
Top