SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Error While report processing ******
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jeevangandekumar
Starting Member

1 Posts

Posted - 06/06/2012 :  04:24:03  Show Profile  Reply with Quote
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

Edited by - jeevangandekumar on 06/06/2012 04:24:41

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/07/2012 :  23:06:55  Show Profile  Reply with Quote
see if credential set for datasource is correct in report server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sivasree
Starting Member

India
1 Posts

Posted - 07/18/2012 :  09:10:51  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 07/18/2012 :  10:54:26  Show Profile  Reply with Quote
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 property

something like for example for col4 you'll write like

=IIF(Parameters!Username.vale ="user1",False,True)

...

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000