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: 294
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