Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeevangandekumar
Starting Member
1 Post |
 Posted - 2012-06-06 : 04:24:03
|
| An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'TotalCount'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors Note: It's Working fine in Local, getting this error only when we setup in client machine.Version : SQL Server 2008 R2 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-07 : 23:06:55
|
| see if credential set for datasource is correct in report server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sivasree
Starting Member
1 Post |
Posted - 2012-07-18 : 09:10:51
|
| i have a report with ten columns.and one parameter user name.iam selecting user A display only three columns and iam selecting user B display only five columns and selecting user C display only eight columns.how to solve this problem?plz any one solve this problem.siva |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-18 : 10:54:26
|
quote:
Originally posted by sivasree
i have a report with ten columns.and one parameter user name.iam selecting user A display only three columns and iam selecting user B display only five columns and selecting user C display only eight columns.how to solve this problem?plz any one solve this problem.siva
please dont hijack threads. post your question as a new thread next time. that would improve readability and you'll get quick solutions.for your scenario best way is to return all columns from procedure/sql and conditional display them in report based on username value by applying an expression for hidden propertysomething like for example for col4 you'll write like=IIF(Parameters!Username.vale ="user1",False,True)...------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Error While report processing ******