Report Builder Error (Input string was not in a correct format) when filtering data
- by JVZ
Issue: the user is getting an error “The requested list could not be retrieved because the query is not valid or a connection could not be made to the data source.” while trying to filter a reporting using Report Builder 2.0.
When you expand the details the message is “Input string was not in a correct format”
I verified that when the user clicks to see the filter values the query is being sent to the underlying database (by using profiler).
When I build the same report [I'm a server admin] I have no issues and see all the filtered values, which leads me to believe this is a permissions issue. I believe I granted all the correct permissions, see below:
Report Server Setup
[Project Name]
Data Sources
Models
[…other folders]
We are using SQL Server 2005.
The user belongs to a poweruser domain group which has the following permissions:
Home
Report Builder
View Folders
Browser
Home/[Project Name]
Browser
Report Builder
View Folders
[Data Sources]
Browser
Content Developer
[Models]
[Inherit roles from Parent folder] << should be same as [Project Name] folder
Report server log is showing the following:
w3wp!library!5!04/21/2010-08:47:27:: Call to GetPermissionsAction(/).
w3wp!library!a!04/21/2010-08:47:27:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!5!04/21/2010-08:47:27:: Call to GetSystemPermissionsAction().
w3wp!library!a!04/21/2010-08:47:27:: Call to ListChildrenAction(/, False).
w3wp!library!a!04/21/2010-08:47:27:: Call to GetSystemPropertiesAction().
w3wp!library!a!04/21/2010-08:47:27:: Call to GetSystemPropertiesAction().
w3wp!library!9!04/21/2010-08:47:40:: Call to ListModelPerspectivesAction().
w3wp!library!9!04/21/2010-08:48:22:: Call to GetUserModelAction(//Models/, ).
w3wp!library!5!04/21/2010-08:48:45:: Call to GetItemTypeAction(/).
w3wp!library!9!04/21/2010-08:48:46:: Call to GetItemTypeAction(/).
w3wp!library!5!04/21/2010-08:48:53:: Call to GetItemTypeAction(/).
w3wp!library!a!04/21/2010-08:49:21:: Call to ListModelPerspectivesAction().
w3wp!library!b!04/21/2010-08:53:40:: Call to GetUserModelAction(//Models/, ).
w3wp!library!5!04/21/2010-08:54:48:: i INFO: Call to RenderFirst( '' )
w3wp!webserver!5!04/21/2010-08:54:48:: i INFO: Processed report. Report='/', Stream=''
w3wp!library!9!04/21/2010-08:56:42:: Call to GetItemTypeAction(/).
w3wp!library!9!04/21/2010-08:56:42:: Call to GetItemTypeAction(/).
w3wp!library!a!04/21/2010-08:56:50:: Call to GetItemTypeAction(/).
Any ideas on how to resolve/troubleshoot this issue?
