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
"Duy Lam" wrote:
Quote:
> Eric wrote: Quote:
> > 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
>
> 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 
>
> --
> Thanks,
> Duy Lam Phuong
>