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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Can not load SSRS report on aspx page

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :Windows Application
 

I have a SSRS report that I am supposed to show on an aspx page. I wrote the following code and passed all the parameters to the report. When I load this page I see a Loading progress bar that goes on and on, but it never loads. I am getting no errors at this stage.

Please suggest what is missing?

<%@ Page Title="Home Page" Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

    <form id="Form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
      <table>
        <tr>
        <td>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" width="100%" height="95%" ></rsweb:ReportViewer>             
        </td>
        </tr>
      </table>
      </form>

protected void Page_Load(object sender, EventArgs e)
    {
        
        List<ReportParameter> Params = new List<ReportParameter>();
        ReportParameter param = new ReportParameter("CaseNo", "THC11-002665");
        Params.Add(param);
        param = new ReportParameter("DraftWatermark", "False");
        Para


View Complete Post


More Related Resource Links

Passing parameters from ASP.Net web page to SSRS report

  
I have a web page that displays some data.  The user first selects a date range on the web page and then can edit some data.  When they click a submit button, I want to run a report.  But I would like to pass the start date and end date values that the user already entered on the web page to the report.  Is this possible?  Can I use the value of a session variable in the report? Bob

Problems passing parameters to SSRS report from ASP.Net web page

  
I have a web page that displays some data.   When they click a submit button, I want to run a report.  But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report.  Here is what my url looks like when the report is displayed: http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008 But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty.  What am I doing wrong?  I did a google search and I saw something about using ReportServer instead of ReportManager.  I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer".  Is this correct? Bob     Bob

SSRS Report issue blank page is coming

  
I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

SSRS Report - Page break after the Header when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam

 


Blank page while exporting the SSRS report to PDF format

  
While exporting SSRS report to PDF, I am getting blank page in between and at the end also. The report page size is set to 8.75in x 15.00in with 0.02in margin from left, right, bottom and top. I tried in changing the tablix and rectangle box "KeepTogether" property also. In both the case (true/false), I am getting blank pages. Can anyone help me out?

SSRS Report printing blank first page

  

 

Greetings,

I have a pretty basic SSRS report that has a table header, body (with a table), and table footer.  When I view the report in normal layout,all is well.  However, when I switch to print layout only the table header and table footer are displayed on the first page.  I don't see any of my table data until page two.  So, this is adding an additional page to the beginning of the report and it's make a 17 page report 18 pages.  And because I am including the page numbers on the report, this is noticeable to the users of the report obviously.  Any feedback on things I could do or check to remove this blank page would be greatly appreciated. 

Thanks

jrock630


Exporting one particular page from SSRS report

  

Hi,

I have developed a report using 2 sub-reports. The report data spans across many pages.
User wants to export one of the sub-report in TIFF format.

Is this possible? Can I export one particular page using export option? Here I don't know the exact page number as well because sub-report may get displayed on any page 2,3.4 etc.

Regards,
Neeraj

 


Font/letter spacing issue when printing from SSRS 2008 report page

  

We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
abcdefghijklmnopqrstuvwxyz
123456789000,000,000.00

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

SSRS Report Page break when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.

My issue is for certain cases the line items in the body of the invoice, only the last line item moves to the next page. Cretaing a large gap in the body of the report. This happens only for some invoices. I am using Land scape type report, having Page size as 11 * 8.5 inches.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

I can also send the RDL file, sample data as well as the PDF output for review.

Thanks,

Mahalingam


How to use a custom aspx page instead of RSViewerPage.aspx to open report from Report Library in Sha

  
I am using MOSS 2007 in SSRS integration mode and currently the report opens up on page - RSViewerPage.aspx and I have created my own custom aspx that can be used for viewing the reports. How to use a custom aspx page instead of RSViewerPage.aspx to open report from Report Library in Sharepoint SSRS integration mode.

Thanks in advance

SSRS 2005 Report Printing Additional Blank Page

  

Hi,

New to SSRS 2005 and having some problems printing. I have a report that has only 7 columns and while in layout mode, the body of the report only has a width of not even 7 inches. I have made my left margin 0.2 in, RM at 0 in, TM at 0 in and BM at 0 in as well and yet when I print, I get an additional blank page. All my records print in the first page just fine but I get the additional blank page. This also happens to me on a different report when I change the settings for landscape printing. I am able to fit all the columns in one page using landscape but get an additional blank page for every page that is printed. So instead of printing just two pages of records, I get 2 additional blank pages.

Any help will be greatly appreciated.

Thanks.

 


Load Previous ASPX Page while click on Javascript History.Back

  

Hi All,

I am stuck with a unusual Scenario, I have Default.aspx page which contains a Search criteria option and Gridview, After doing particular search result is displayed in Gridview .

When i click on selectedindexchanged event of Gridview it takes me to another page called Details.aspx where there is form in edit mode where the user can update and save the data into a database . In Details.aspx page i have link button which have history.back function which takes me to default.aspx page where i can retain my Search criteria and Gridview Result but my query is when click on Link button i want to call any of the Events of Default.aspx page.


Thanks in Advance

Shabbir




Content sources page (layouts/listcontentsources.aspx) takes 10 minutes to load or fails with 'Unkn

  
Ever since this weekend we cannot normally access the Search Content sources page. It takes ages to load and sometime fails with "Unknown error". Also, we have incremental crawls on all our content sources that are stuck for ~30 hours now. Restarting search services didn't help. There's almost no activity on our search server. May have something to do with backup software on the search server but we uninstalled it completely now.

MOSS2007, latest SP's, clustered farm, 2 * FWS, 2 * SQL, separate index server

Any clues?

Thanks

SSRS-2005 Repeat Matrix On Each Report Page

  
I am using two matrix controls in my report. Both use different data sets. I want the first matrix to repeat on all the report pages. Can someone help me with this? Thank you in advance.

How to pass multivalued parameters to SSRS report hosted in ReportServer from ASP.Net page

  

I have a webpage from which Im passing parameters to a SSRS report.

While passing mutiple values from a multi valued parameters, the URL is exceeding the value of 2038 and hence the report is not showing up. Any suggestions on this matter would be really helpful.

eg: MacCode is a parameter and is multivalued attribute. Im choosing from the webpage drop down the values 1,2,3,4,5,6,7,8 for this MacCode. When it is passing to the ReportServer URL , it may exceed 2038 character limitation of URL.

 

Howto handle this... Please help

 


Launch CMD File From ASPX Page

  

My organization uses a CMD file to install updated files for a major enterprise application. Currently, we send out an email to users with a link to the file and instructions to run it, BUT inevitably users don't update their machines until their in field and try to start the app.

 

We're now liking the idea of using an ASPX page to prompt the users to run the updates and to capture the fact that the updates have been run. I realize that we can't capture the success or failure of the update. But we'd like to capture the user accessed the page.

 

Is it possible to embed into the markup for the page a link to the file on the local intranet that the users can click on to run the file?

The user accessing the page would capture that they did just that. We'd deal with wether or not the update was actually installed or if it failed later with them directly.


Open ModalPopup dialog on page load

  

Is there a way to make a modal popup panel active on page load so that the user can't do anything until they deal with the popup dialog?


Categories: 
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