SQL Server Reporting Services | Forum profile

Hi, To filter data in ReportViewer control using a DropDownList control, we can add Parameterized Methods to the TableAdapter class, invoke them in the ObjectDataSource control and specify the value for the selected parameter from DropDownList control. You may refer to the tutorials below: Creating a Data Access Layer http://www.asp.net/learn/data-access/tutorial-01-vb.aspx Declarative Parameters...

 Hi,  I was wondering if there was anyway to reference another cell in a report.  For example if cell1 is =Fields!field1.Value and cell2 is =Field!field2.Value is there any way I can reference the values of cell1 and cell2 so I could say =cell1+cell2 in cell3  I want to do much more complex logic than this but thats the idea.  Thanks, -Jordan

Hi,   Based on the error you described, it should be a general error message thrown by the server side. Could you please make sure that other clients can access the reports at that time?   As for the solution to that issue, you may refer the following thread which may be helpful to you.   http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2535069&SiteID=1   Thanks.    

Thanks for Your answer... I know that trick and I used it before My Question is if there is a way to trap the Built-In  " Export Event " of the report  and make custom change. P.S The Way You are suggestion force to do the Query agian ...  

What you'd have to do is create an 'export' button, and in the click event pass a parameter to the RDLC report. At that point you have to render the file to it's output type. Just pass in the parameter into the report shortly before rendering, once completed rendering set the parameter back to the default, and then the image will only show on the rendered output file. Call it switching on the 'visible' switch...

Well, it seems, it is VS 2008 bug. I created sample website with same exact report and class. I was able to view that object datasource in datasources. And then I again moved that stuff back in my original website, although I was not able to view any object data source in datasource window but report is working. So behind the scene it is working fine.

Bugz, You should be able to use AND with LIKES in the WHERE clause:  SELECT (values) FROM (table A) WHERE A.employeeID LIKE '%(append parameter in here)%' AND A.employeeName LIKE '%(append parameter in here)%' AND A.passportNo LIKE '%(append parameter in here)%'  Depending on the DB you are using you may need to tweak how you append the parameter data with the % signs. Another option would be to...

Hi, If u r using stored procedure write a conditional where by checking parameter values For Ex: if u pass parameter only @cust_mobile the pass only cust_mobile in where conditions SELECT cust_id,cust_name,cust_mobile,cust_email,cust_address,cust_city,comp_name,cust_type,cust_status,cust_tel,cust_fax FROM CCSCustomer if(@cust_mobile <> "") Begin    WHERE ( cust_mobile=@cust_mobile ) End...

 No.I not using Crystal Report.I am using SSRS

 More detailed answer here http://forums.asp.net/p/1352244/2767237.aspx#2767237