Re: Reporting Services Report Model

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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:

Eric wrote:
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

.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Using SQL statement to append a recordset to a table
    ... To insert a value into the field Priority: ... > all failed mean while each time my report was working fine. ... Used the query> wizard "Find Unmatched Query Wizard" to create a query between these two> tables, changed to an append query, appending to the ... > table (looking at the sql view along the way). ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)