locked
Generate report based on client's .xls RRS feed

  • Question

  • User1886744418 posted

    Technologies used : ASP.Net 2005, C#.Net 2005, SQL Server 2005 (SSIS, SSRS)

    Hello all,

    okay, I have been working out on this thing for past 3 days and cant able to figure out or find solution. OK heres the deal.

    A form is presented to the user with fileupload control, Upload Button and Process Button. User is allowed to upload only .xls file, when UPLOAD button is pressed excel file gets uploaded to the server, when the PROCESS button is pressed, the file goes to SSIS, creates the table and loads the rows based on data from excel file, then generates report in SSRS and displays that report in the user form. I have to display data in report based on some user selection criteria, but, its ok, even if i get to know how to display the uploaded excel file data in report in the webform.

     Thanks everyone, wish you all have a wonerful weekend.

    warm regards, 

    Shariff

    Friday, April 11, 2008 1:20 AM

Answers

  • User-1657637721 posted

    Hai friend,

    I think the following will be useful to call the SSIS packge through coding, 

     string packageLocation=null;       
            Package packgae;
            Application application;
            DTSExecResult packageResults;       
            app = new Application();
            pkg = app.LoadPackage(pkgLocation, null);
            pkgResults = pkg.Execute();
            Response.Write(pkgResults.ToString());

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 17, 2008 8:08 AM

All replies

  • User-1657637721 posted

    Hai friend,

    I have read your question.

    I am looking the way to do that process.

    If you found please send to me.

    Thank you..

    Friday, April 11, 2008 5:35 AM
  • User1886744418 posted

    Oh dear!!, I was expecting someone to respond. Someone must be there, with some idea/hint..

    thanks, later all.

    Sunday, April 13, 2008 1:06 PM
  • User-1657637721 posted

     Import a DLL named as Microsoft.reportviewer.webforms
    and written in your server side [ using system.Reporting.webforms;]
    please use the following code to implement reporting services


    ReportViewer1.ProcessingMode = ProcessingMode.Remote;         
    ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost//ReportServer");
    ReportViewer1.ServerReport.ReportPath = "/Prakash/prakashReport";       
    ReportViewer1.ServerReport.Refresh();

     This report server url and reportpath you have to be noticed while you deploy your report..

    still you have doubt please reply me i will send sample coding to you..

    visit this website for creating SSIS packages

    http://foraspdotnetdevelopers.blogspot.com/ 

     

     

     

    Thursday, April 17, 2008 7:57 AM
  • User1886744418 posted

    Thanks friend, but that code can help me do my job using SSRS, if you can provide me code for SSIS support too, that could be great. Anyways, thanks a lot friend. Thats amazing, in the second post you asked me to help you, but in the end, you end up helping me. Thanks.

    later all

    Thursday, April 17, 2008 8:04 AM
  • User-1657637721 posted

    Hai friend,

    I think the following will be useful to call the SSIS packge through coding, 

     string packageLocation=null;       
            Package packgae;
            Application application;
            DTSExecResult packageResults;       
            app = new Application();
            pkg = app.LoadPackage(pkgLocation, null);
            pkgResults = pkg.Execute();
            Response.Write(pkgResults.ToString());

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 17, 2008 8:08 AM