this report cannot have a default filter -- sql server reporting services

Steve Dearman
7/11/2006 4:56:08 PM

You need to go to the dataset view and right click properties the table that
you want to use the filter and add a alias to the table in this format
CRMAF_(yourtablename exactly as it is normally), this should work!

[quoted text, click to view]

Sandhya
7/19/2006 10:39:01 PM

I have done teh same. but still i get this error..

[quoted text, click to view]

Barrett
8/16/2006 11:33:01 AM

Open your .rdl file in notepad and find the SELECT/FROM area.

CRM requires the format of:
"FROM FilteredEntity AS CRMAF_FilteredEntity"

Make sure there is NO "dbo." infront and that the "AS" is there.

hth
Barrett

[quoted text, click to view]

Dine
5/5/2008 1:57:44 AM

i think i have d same issue. I have my own view (say rpt_FilteredContact). and i need to add the "CRMAF_" prefix to that, in order to make it context sensitive (i.e. pre-filterable). Is there any other way to achecive this ?? Thanks.

From http://www.developmentnow.com/g/115_2006_6_0_0_776107/this-report-cannot-have-a-default-filter.htm

Posted via DevelopmentNow.com Groups

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : this report cannot have a default filter