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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Where to Find the url of the report in the back end

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server

Hi All,

I want to know the url of the reports from the backend, so that I can use it to jump to that url, is there a way to find out the url of a report from the back end(from Report Server database).



View Complete Post

More Related Resource Links

Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

Back Button for Parent Report

Hello all, I have created a summary report and have the hyperlink set up to jump to another detail report. In BIDS, when I get to the detail report, there is an option to go back to the parent report. But when I publish these reports to Report Manager, that back button is not there. Does anyone know a workaround to this? I really want the user to be able to go back to the summary report when they are done looking at the details. We are working on SSRS 2005. Any help would be greatly appreciated.

Find SQL Query when report is executed

Hi All, I am using SSRS 2008 R2 verison of reporting services. I have a report and the data source for this report is Oracle 10i, it takes around 2 mins to execute the report. I want to find out the query, which is sent by the reporting services to the Oracle. Is there a way to find it out. Please help me with this. Thanks Vineeshvineesh1701

CrystalReportsException: Load report failed - The system cannot find the path specified

I recently added a Crystal Report to a web application within Visual Studio 2010.  I'm using the Push method with a DataSet, and have a CrystalReportViewer control added to an aspx page.  When trying to test the report locally I'm getting an exception when performing the data binding on the CrystalReportViewer control...-----------------------------------------------------------------------------------------------------------------------------------Server Error in '/TestDevelopment' Application. The system cannot find the path specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: The system cannot find the path specified. Source Error: Line 7: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Line 8: BindReport() Line 9: CrystalReportViewer1.DataBind() Line 10: End Sub Line 11: Source File: C:\Documents and Settings\acwhifield\Desktop\VS_Projects\TestDevelopment\TestDevelopment\a\CR_Rpt_SubSelNotes.aspx.vb Line: 9 Stack Trace: [COMException (0x80004005): The system cannot find the path specified. ] CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(O

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

report manager parameters , back button do not show

Hi, not sure this is an expected behavior.  My drill through reports have parameters that are passed from the first report.  once drill through, somehow the parameters are not showing in report manager.  also the Back arrow is also missing from the second report.  is this expected?thanks

How to find the rowcount of the dataset in a report


I have a report.

In one of the text field i have to show the rowcount of the dataset

How can i do that

cannot find PivotTable report tempalte in PerformancePoint Dashboard Designer



I want to create PivotTable report in PerformancePoint Dashboard designer, as I checked in the link http://office.microsoft.com/en-gb/performancepoint-server/create-a-pivottable-report-by-using-performancepoint-dashboard-designer-HA010257416.aspx ,I should be able to do the following step:

{In Dashboard Designer, click the Create tab, and then click Other Reports. ClickPivotTable, and then click OK. The Create a PivotTable Report wizard opens.}

But I am not able to find PivotTable in 'Other Reports' in Create tab, could you please tell me is there any prerequisite need to be done before I start the above step?



report definition cannot find custom assembly in VS 2010



I;m trying to use custom code (C#) in a report definition and I have followed the steps outlined in MSDN to get this done. However, whenever I compile the code, I keep getting the following error

"Error while loading code module: ‘GSLibrary, Version=, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'GSLibrary, Version=, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

I've scoured through this forum and the net looking for answers but nothing seems to work. The closest answer was to mark the assembly as a trusted code module in the current app domain, but VS2010 complains that this method is deprecated.

The assembly works just fine elsewhere in code. How do I get custom C# code to work with the reports I am creating.

Thanks for your help.

Parent report parameters not maintained when going back from sub report


I have just managed to integrate SharePoint 2010 (just installed last week so we pretty much use latest sp and fixes) with SSRS 2008 SP2 (no unfortunately not R2 we had a reason for that)

Most parts work but unfortunately we have a huge problem going back to a parent report from a sub report.

The parameters pane doesn't change back to the 'original' parameters pane from the parent report and this of cause result in an script error when trying to process another sub report from the same parent. The parameters obviously doesn't fit.

I have read the following very similar thread: http://social.msdn.microsoft.com/Forums/en-ZA/sqlreportingservices/thread/fa6d9b5a-eef5-43d9-8906-36c7eac33796

But it doesn't really give me anything to work with.

Having many parameters and quite a long excution time on the parent report. It is not really an option to run it each time we want to find details through the sub report. (I write as if we only have one parent/sub but we have many ...)

I have a test setup where the DB and SSRS is 2008R2 and it is the same problem.

Everything worked fine with SharePoint2007 and SSRS2008 SP2

Is this a known bug? Is there a fix or a workaround ?

Please help


SSRS 2008 - Subreport passing a value back to the main (master) report



Looking for a way to pass a calcuated value or Sum from a Subreport back to the Main Report.   Is there anyway to do this.  In past posts, with the most recent being 2008, it is said that this feature was not available or included in SSRS.

Using SSRS 2008.



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">

Post back puzzle


Hi, I have a website where the user makes a selection from a combo box and it then fills a couple text boxes with text based upon the selection. I'm sure as you know it could take a second for the text to appear in the text box due to the post back. I know there is no way to make it instantanious, so what I would like to do it fill the text box with somthing like "Loading Info..." so the user does not type in it while the information is loading.

If you would like to see what I mean please go to this page: www.epiclinks.com/create.aspx and mess around with the combo boxes and You'll see what I mean.

What I would like to do is have it do a post back to write "Loading Info..." and then do another post back to fill it in based upon their selection. How would I do this?

I'm up for anything, so if you have a better solution than that please let me know.


find a Control inside a GridView using jQuery


I have databound GridView in my page and I have a hidden DIV in all rows. Each row contains a Button that I want it to make the DIV visible for me! how can I use that with jQuery?!

here is the code page: 

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                                EnableModelValidation="True" GridLines="None" ShowHeader="False" Width="100%">

Is there any way to find out the reason for session expiry?


Dear All,

is there any way to find out the reason for session expiry?



Cannot find ASP.NET tab on IIS6+2003,how to choose .NET framework 4.0?


Hi all,

I just wanna setup a .net framework 4.0 on my VPS for a new site. While I could not find the ASP.NET tab on properties. I did some research find some similar problems but haven't fixed it yet.

Any suggestion would helpful.



Using loginName to find ADInfo from an outside class



I wrote a class to pull adinfo and for the life of me I can't seem to figure

out why it says "Invalid Login Name" no matter what I type in. If I leave

it blank it seems to work properly but it doesn't seem to be actually searching

the AD. I'll drop the whole class here, it's being initiated by a button click

on an outside form.


Thanks in Advance for any help Offered,



Imports System.DirectoryServices
Imports Microsoft.VisualBasic
Imports System.String
Imports System.Collections
Imports System.Security.Principal
Imports System.Security.Permissions

Namespace LoginButton
    Public Class LoginButton

        'Class Variables
        Dim UserID As String = Nothing
        Dim DomainDN As String = ConfigurationManager.AppSettings("myConnectionString")
        Dim ADEntry As DirectoryEntry = New DirectoryEntry(DomainDN)
        Dim objSearch As New System.DirectoryServices.DirectorySearcher(ADEntry)
        Dim oResults As DirectoryServices.SearchResultCollection
        Dim oResult As DirectoryServices.SearchResult
        Dim RetArray As New Hashtable
        Dim page As Page = DirectCast(HttpContext.Current.Handler, Page)
        Dim TextLogin = DirectCast(page.FindControl("
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