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


Post New Web Links

Programatically Exporting Multiple Reports

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

Hi currently I am programmatically exporting multiple reports to a pdf via the ssrs web services using C#.Net.  It exports a single report just fine, I was wondering if there was a way to export multiple reports?  I tried block copying the byte arrays from all the reports into a single byte array, but it only displays the last report.  Is there any solution for this?




View Complete Post


More Related Resource Links

how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help

  

Hi,

I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help

 

Thanks in advance!


Multiple Reports in the same Viewer

  
Hi all, Is that possible to open three reports in the same window ? Can be using the group tree or the tabs beside the MainReport. If it is possible, how to do it ? The reports used to be open in excell and the file has three worksheet, now we want to change them for Crystal Reports, thats why were created three reports, but it must be open the same was the excell format, with three worksheets. Any work around for this will be appreciated. We are developing the asp.net in VS2010 with the CR2010. thanks !

One report >> Multiple Linked Reports in different folders?

  
I love Linked Reports in SSRS because of my ability to change one report in one project and post changes to one location on my SSRS server and then have those changes take effect in my linked report.  Today however I was asked to make one of those reports which is already liniked elsewhere to be linked to two locations and I was dismayed to find out that there is a chance that its limited to one linked report for any source report. Can someone tell me this isn't so and show me a way around this?  I don't want to have to post my RDL to multiple locations unless its absolutely necessary. I'm using SQL Server 2008, SSRS2008, Standard Edition. Thanks, Keith

Using ReportViewer for multiple reports by way of radio buttons

  
 Hi all, Thanks for taking the time to read over my scenario.  I am using one ReportViewer with already established SQL Stored Procedures connected to three report files (*.rdlc).  There are three radio buttons which are to be associated with each report that needs to be displayed in the ReportViewer.  Here is an example if a radio button is selected:ReportViewer1.Reset() Dim rds As Microsoft.Reporting.WebForms.ReportDataSource rds = New Microsoft.Reporting.WebForms.ReportDataSource ReportViewer1.LocalReport.DataSources.Clear() If RadioButtonList1.SelectedIndex = 0 Then rds.DataSourceId = ObjectDataSource1.ID rds.Name = "spEx1" rds.Value = ObjectDataSource1 ReportViewer1.LocalReport.DataSources.Add(rds) ReportViewer1.LocalReport.ReportPath = "Ex1Report.rdlc" ... The ReportViewer works for the first radio button selection but then for the other selection I get the following error: A data source instance has not been supplied for the data source 'spEx1' I'm not sure exactly what is going on or where it's still tied to the first data source.  Any help would be great!  Thank you.

Multiple reports

  
Hi, I want Display 9 Reports in single Report LayOut. plz let me know how can i create reports. thats very help full for me.

Multiple Reports

  
Hey All, I need to create a 5 page Report for each employee in our organisation based on some criteria and then i need to send that 5 page report to the related employee only. Similarly all the reports created that way will go to the related employee as an email. I've the idea of how to do it for single report at a time, But how to do this for all of the employees at one go i am not sure about that. Please give me some idea or solution to work it out. Please help me out. Thanks a lot Punu

Exporting multiple gridviews in multiple excel tabs

  
Hi All, I am able to export multiple gridviews in a single excel worksheet My question is can I separate these gridviews in multiple tabs under the same excel file ? This is my current method under the link buttonprotected void lnkExport_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition","attachement;filename=TrendAnalysisRpt"+StoreNum); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); HtmlForm frm = new HtmlForm(); this.grd_Inj.Parent.Controls.Add(frm); this.grdBody_1.Parent.Controls.Add(frm); frm.Attributes["runat"] = "server"; frm.Controls.Add(this.grd_Inj); frm.Controls.Add(this.grdBody_1); frm.Controls.Add(this.grdBody_2); frm.Controls.Add(this.grdBody_3); frm.Controls.Add(this.grdBody_4); frm.Controls.Add(this.grdMonth); frm.Controls.Add(this.grdDay); frm.Controls.Add(this.grdHours); frm.Controls.Add(this.grdLengthOS); frm.RenderControl(hw); Response.Write(sw.ToString()); Response.End(); } Thanks again!    

Error occuring while exporting larger reports to Excel from SharePoint

  

Hi,

I have SSRS configured in SharePoint integration mode. I have reports deployed. if a user wants to export the report to an excel file works fine for smaller reports. But, in the case of larger reports it is throwing me an error while doing export to Excel. I am getting message like

An unexpected error has occured.

Example: Monthly reports are exporting to excel file fine. Where as, Yearly report has more data than the monthly reports. If I try to export these reports, I am getting above error. I must sure, this is something to do with the IIS time out or application time out(setting in web.config file of web application). Please some one guide me where is best place to do this.

Viewing works fine for both the reports.

I appreciate your help.

Thanks,

-Gautham


SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control

  

MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.

Thanks.

 

Report Definition:

MainReport.rdl:

 

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

How to add multiple reports in single parent pane with each report had its own pane and dropdown to

  

We had a report to create which should show multiple reports with each of them had there own pane and each of them had drop down to select the parameters to run this report. We had to create this report using SSRS, any ideas???

Thanks.

Tony


REndering large single reports into Multiple reports

  

Hi,

I am using ssrs 2008.  My Report can genarate  5000 Record count , 10000 Records count or more than 10000 records count.

When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.

how can i avoid that exception..?

 i read through some forum can genarate one report into mulitiple reports by dividing the record count.

can nay one explain in detail..how best i can work on Rendering Large reports.

 

thanks in Advance.

 


programatically pass the connection string to the ssrs reports

  

hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);
            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParame

programatically pass the connection string to the ssrs reports

  
hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);


            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParameter("@p_dno", "5");
            //this.ReportViewer1.LocalReport.SetParameters(p);
 &n

programatically pass the connection string to the ssrs reports

  
hi... to all
i've created ssrs reports local following is my code..
 public void source(string tbname,string Rptname)
        {
            ReportViewer1.Visible = true;
            string myQuery = "select * from " + tbname;
            SqlConnection myConnection = new SqlConnection(ConnectionString);
            SqlCommand myCommand = new SqlCommand(myQuery, myConnection);
            myCommand.Connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(myCommand);
            DataSet dt = new DataSet();
            da.Fill(dt);


            //ReportParameter[] p = new ReportParameter[1];
            //p[1] = new ReportParameter("@p_dno", "5");
            //this.ReportViewer1.LocalReport.SetParameters(p);
 &n

deploy the reports programatically in aspx page. in c#.net

  
zhi......... to all

i've created one ssrs report and i want to deploy in programatically.. in c#.net(.aspx page)

Multiple reports straight to pdf (SSRS 2008)

  
Hello, I have successfully written code to generate a server report straight to a pdf document. I did this using Report.Render(...) and then writing the result with Response.BinaryWrite. This works fine. The thing I would like to do now is this: On the webpage the user sees a tree with about 20-30 reports on it. I would like the user be able to select which reports he wants to see (using the tree check boxes) and then when he hits print one pdf document is generated with all the selected reports on it. Any suggestions? Thanks.

How to display reports from multiple lists in SQL Server Reporting Services Report Viewer

  

Hi All,

  I want to generate report through SSRS from more than one sharepoint lists. To generate report from one list i am using below query:

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{577B2EB4-8BE3-484B-AF5F-8C6F4BF70352}</DefaultValue>
         </Parameter>
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

Please suggest me a query to get results from more than one list like we use joins for SQL tables.

Thanks in advance,

Saurabh Kumar Singh

Mail: saurabhsinghmca@gmail.com


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