How to pass parameters to report model in Reporting Services

Question

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.

Answer 1

Maybe what you're looking for is to use the result of a Stored Procedure as the data source for your report. You would need to define parameters at a Dataset level to pass to the SP