Report builder 3.0 does not populate filter formula on query designer

Hi Everyone,

On Report builder 2.0 on SQL 2005 SSRS, the filter on query designer work just fine to dynamically populate the formula on the report designer and report output, so user able to see what filter criteria they use for the report.

After migrating to SQL 2008 R2 report builder 3.0, the filter no longer work. It stay as the last filter value was used in Report builder 2.0 before upgrading to SSRS SQL 2008 R2. I tried to change the value, delete one of the filter and nothing change on the filter. It stay the same.

Filter: View Calls with: All of (Unit Arrived = TRUE, Self Initiated = FALSE, DateTime Entered from 10/15/2008 to 08/12/2011, Address contains "1626 anystreet")

On the filter I change the start date range value to 10/1/2008, and no change on the filter parameter at the bottom page footer of report designer. I tried to change other filter value and does not work either.

Does anyone have any ideas how to get it working? Any comment I would appreciate it.


more ▼

asked Sep 09, 2011 at 01:32 PM in Default

avatar image

21 2 2 4

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 09, 2011 at 01:32 PM

Seen: 1854 times

Last Updated: Sep 10, 2011 at 03:11 AM

Copyright 2018 Redgate Software. Privacy Policy