.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Drillthrough not functioning on deployed report (SSRS2008)

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Hi I have a report with a drillthrough functionality on two cells in a tablix, the intention is for each cell to pass different parameters to the target report. The report fuctions exactly as expected when previewing in BIDS, each drillthough passing the appropriate parameters to the target report. However once the report is deployed (to a SharePoint environment), only one of the drillthroughs will function. In the other, the pointer recognises some kind of link (it changed to a 'clickable' icon) but it won't function (and there is no target displayed at the bottom of the browser as there is with the working link). I've cheked the html source for the page and it appears not to have an onclick command for the first cell (contianing the text 'BSC C701 - BIOCHEMISTRY (4 YR)(I)'): <TD ID="11iT0r9c0" class="a144c"><br/> <DIV class="a144"><br/> <DIV style="overflow-x:hidden;WIDTH:73.14mm;" class="r13"><br/> <DIV class="a143"><br/> <span style="font-style:normal;" class="a140">BSC C701 </span><br/> <span style="font-style:normal;" class="a141"> - </span><br/> <span style="font-style:normal;" class="a142">BIOCHEMISTRY (4 YR)(I) </span><br/> </DIV><

View Complete Post

More Related Resource Links

Use Report Action as default drillthrough on a calculated cell in Excel

Hi, I am using SSAS 2008 R2 and Excel 2010. Is there a way to override the default behavior from the cube to force an excel pivot table to perform a report action rather than a drillthrough when I double click a cell that is a calculated member? Currently, I get an error message. Truth be told, I wouldn't mind making all the double clicking in my pivot table cells pop a report for the user since the drillthrough formatting is so primitive, but I really need to know how to do it for the calculated cells. Thanks, James

Report not getting deployed in Report manager



I have a report which I want to deploy in report manager but it's not getting deployed there. Let me give you guys a bit more detail.

 I have a report where I have used an OLE provider in the connectionstring to connect to a cube.  The properties of the connection string are Type - OLE, Provider - Microsoft OLE DB provider for Analysis Services 9.0. Connection string is, Provider=MSOLAP.3;Data Source=ServerName;Initial Catalog="Cube_Name".

I tried to use the Analysis services (as type) but in that case I was not able to connect itself. I have 2 servers, say A and B. I have BIDS installed in server "A", where I have created my report. In server "B" I have the Analysis Manager (AS 2000). So while creating the report in BIDS, I had to choose the OLE provider to connect to the cube. I tried initially with the Analysis services but in that case I was not able to see the list of cubes in the wizard for creating my DataSource.

Now my problem is that while the report runs perfectly fine in BIDS, as soon as I deploy it in the report manager (which is in the same server as where I have created my report in BIDS, in our case server A), i get an error,

An error has occurred during report processing. (rsProcessingAborted) Cannot c

Passing parameters between 2 SSRS reports deployed in report manager



I have created 2 reports in SSRS. In my 1st report there is a tablix, which contains many rows. The text in these rows act like hyperlink and upon click navigate to my 2nd report. This functionality is working fine in Visual Studio and also in report manager. But as soon as I deploy my reports in SharePoint site (using a page viewer web part), this functionality breaks. I can see when I take my mouse near the text in the Tablix it shows a URL like http://IP Address/Reportserver/

It's evident that the URL here is not forming correctly. Can anyone help me out in this issue. In my report for navigation purpose I had used Action -> Goto Report (report 2) and passing the parameters there.

Thanks in advance,


SSRS2008 Report email subscription not working

Using our local smtp server i am trying to do a report subscription to mail the report to certain mail ids. In report manager getting the status as 'Mail sent to <>' But originally no mail were sent. what might the problem be?
--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Columns not visable on report once deployed


Hi,Fairly new to reporting services and SQL, but I have designed a 3 column report in visual studio for labels. When I run locally and view there is only 1 column, if viewed in print preview the data is there and i can then print the label. When I deployd to our report server to be published on the web I can only see the one column which pushes the data to 4 pages (so ignoring the column formatting) and there is no print preview option.

How can I get the report to display the 3 columns of data once deployed to the web, also the print icon within the report when published to the web site does not work I recieve an error 'Error loading resourse library. (0x8007007e)'

I am using visual studio 2005 and SQL server 2005 sp3 on the report server

Please help


ssrs report parameters not coming on top of report when deployed on moss site



I have deployed ssrs report on moss site through integration mode but the parameter section of report is coming on right hand side of the page on moss site which is not desired.

I want the report parameters to be located on the top as they are seen in report preview.What should i do?

please help,


Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

Dynamic Report in reportviewer


HI I m sorry to say this But this task too urgent.

 Ex- i have two tables in my db name called Comdetails, deptdetails.

TCS is a one company name stored in ComDetails and Company_ID took as primany key,

TCS having 10 department stored in deptdetails and Company_ID as foreign key.

so now in DB we have available one company with 10 departments.

so now i need to generate report , i m using report.rdlc and reportviewer.

i hope upto now its clear.

my task-

1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Report viewer error


  • An error has occurred during report processing.
    • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

  • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

Printing crystal report from webservice



I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?

Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend