How to pass parameters to report model in Reporting Services

Posted by savras on Stack Overflow See other posts from Stack Overflow or by savras
Published on 2010-06-01T15:16:29Z Indexed on 2010/06/01 15:23 UTC
Read the original article Hit count: 292

Filed under:
|
|
|
|

I'm developing report in RS that show top N customers based on some criteria. It also allows to select number of customers and period of time.

Is it possible to do it by using report model? Thing that it seems to be difficult is how to pass parameters determined by user.

Another thing that in my oppinion is very disappointing is that i cannot use SQL query as dataset query, because it uses odd and elaborate XML. Although report model items seem to map its fields to query or table fields.

I m concerning using report models because i need to provide uniform data model (the same tables and fields) for more or less different database schemas.

It would be very nice if somebody would explain what can be done with report models and what can not.

© Stack Overflow or respective owner

Related posts about reporting-services

Related posts about model