Showing posts with label builder. Show all posts
Showing posts with label builder. Show all posts

Friday, March 9, 2012

Reporting Services Help

I am trying to use Report builder in both SQL 2005 and SQL 2000( which does not exist in the version). I am trying to run the reports off of my created vies.
Cany one one explain how to do this.

My process is I open VS 2005 Business Itellgence and select Report Model.
Then I selecet my datasource , then my Data source view, then I create my Model.

However, it only allows me to view mt Tables, not my created views or created Queries.

I need to know how to get my views to be accessible and also is Reporting Model Available for SQL 2000 reporting Services and if not why.

thanks.

danjaman:

also is Reporting Model Available for SQL 2000 reporting Services and if not why.

Report Model is not available for SSRS 2000. It is only available for SSRS 2005

Wednesday, March 7, 2012

Reporting Services Filter

I `m using Reporting Services from web. I mean that I have created some reports in report builder and put them in web. Other users can access and view this reports and everything works good. My question: Can other user apply some filter on the report if user has no any Reporting Services ?

For example:

If I created a report, wich contains 2 fields (ClientName and BirthDayDate), and I select all clients with birthdays from 1900 to 2007. But what if user wants to filter this clients and choose those, who hase birthdays from 1998 to 2001 for instance.... Is there a posibility like this in Reporting Services ?

You can configure the Report Builder parameter as prompted by right-clicking on it (on the Filter dialog) and choose Prompt.