How to use DataSet and Storedprocedure as FastReport DataSource in VS2008

Comments

• AlexTZ

  July 2009 edited 12:30PM

  Hello,
  
  1) see programmer's manual, "Working with Windows.Forms/Using the Report component in Visual Studio" chapter (if you work with Windows Forms project). If you want to register a DataSet in ASP.NET project, read the "Working with ASP.NET/Registering data" chapter.
  2) it's not correct use of SqlDataSource, you have to specify the connection string.
• xlfg

  July 2009 edited 12:30PM

  
  1.I'v read proammer's manual.and registerdata(dataset),but still I dont know how to design report in designer that which datasource is dataset.I'm working with ASP.NET.
  2.I'v specified the connectionstring to SqlDataSource, and test correctly when binding it to GridView.
• AlexTZ

  July 2009 edited 12:30PM

  One possible solution is to run a designer at run-time to create a report. To do this:
  - place Button on your aspx page;
  - create the following event handler for it:
  

          protected void Button1_Click(object sender, EventArgs e)
          {
            Thread th = new Thread(DesignReport);
            th.SetApartmentState(ApartmentState.STA);
            th.Start();
          }
  
          private void DesignReport()
          {
            Report report = new Report();
            // create the DataSet instance
            crosstestDataSet ds = new crosstestDataSet();
            // register it in a report
            report.RegisterData(ds);
            // run the designer
            report.Design();
            // dispose a report
            report.Dispose();
          }
  

  
  Note that this will work only on your local machine. Run your project, press the Button - you will be able to design a report and save it to a file, then use this file in your ASP.NET project. Once you have designed a report, remove this Button and all associated code (or hide it).
  
  To use the report you have designed:
  - add report file to your project via Solution Explorer. App_Data folder is good for this;
  - put WebReport component on your aspx page;
  - go Properties window and invoke the "ReportFile" property editor;
  - select App_Data\report.frx file.
  
  To run a report, you need to register the DataSet. Use the WebReport.StartReport event handler:
  

          protected void WebReport1_StartReport(object sender, EventArgs e)
          {
            Report report = WebReport1.Report;
            crosstestDataSet ds = new crosstestDataSet();
            report.RegisterData(ds);
          }
  
• xlfg

  July 2009 edited 12:30PM

  This code works not correct. Anothers error occured, perhaps there's some wrongs in anothers parts of my code.Can I work it in design time that using Dataset but not implement it by code which is inconvenient.
  
  Secondary how to use SqlDataSource with Storedprocedure,which is success in using a table as a datasource.
  
  Thanks for your help firstly
• AlexTZ

  July 2009 edited July 2009

  This solution works well for me, I've checked it on a simple project before posting here.
  
  Another way is to use ObjectDataSource, bind it to your DataSet and then register in a report. This can be done in a visual manner.
  
  I've tested stored proc as well - it works fine (I have a test database with MiProc2 proc with one string parameter).
• xlfg

  August 2009 edited 12:30PM

  God bless.I found solution from topic in this forum.
  But I still dont know how to use DataSet as DataSource in VS.
  
  Thanks AlexTZ
  
• AlexTZ

  August 2009 edited 12:30PM

  Please read my previous post.
  

  wrote:

  Another way is to use ObjectDataSource, bind it to your DataSet and then register in a report. This can be done in a visual manner.
• xlfg

  August 2009 edited August 2009

  That is,Put Register(Dataset) to StartPage event handler? Will this event fired in design time? I think not, startpage event isn't fired then I can't register a DataSeta in design time. Maybe I am not understanding your meaning clearly.
  
  Any additional question:
  
  1.I'v set column's size to 'cangrow'.Still, there are many rows' height didnt grow when one column's text is very long and text being clipped.But, some rows work well.It looks like have no regulation.And when change font,rows' height changed with also no regulation.
  2.My report have two Databand and one Datahead, on which I put a total column,that on the head of second Databand. But the Datahead content didn't show on the first page when it on first page whereas other pages work well when it on other pages at run time.
  3.Does FastReport .net demo version have expiration or client connections limitation?
  
  Best Regards
• AlexTZ

  August 2009 edited 12:30PM

  No, it can be done visually, without writing any code. Once you create a ObjectDataSource component, you can use it in a report, as described in the programmer's manual, "Working with ASP.NET/Using the WebReport component" chapter.
  
  1,2 - I can't say what's wrong, I need a demo report that demonstrates this behavior.
  3 - no it does not.
• xlfg

  August 2009 edited 12:30PM

  I did as programmer's manual indicate.But in designer,has no correct tables and columns show in Datasource, just objectdatasource1, tree list 'Databinding: col0','Databinding: col1','Databinding: col2'
• AlexTZ

  August 2009 edited 12:30PM

  That means your ObjectDataSource is not properly connected to data. You can connect ObjectDataSource to only one table in a DataSet. In this case, you will see all columns of this table. Do a simple task: configure the ObjectDataSource and connect it to standard GridView. If it's ok, you will able to use it in FastReport as well.
• irfansyd

  September 2009 edited September 2009

  Hi Alex,
  
  I tried this as you mention in post#4. But its displaying the data directly from the test.frx file, instead of Dataset.
  
  Please help.
  
  
  Irfan
• AlexTZ

  September 2009 edited 12:30PM

  Hello,
  
  The report does not contain any data. It contains datasource schema only. So I don't understand this:

  wrote:

  But its displaying the data directly from the test.frx file, instead of Dataset.
• irfansyd

  September 2009 edited 12:30PM

  AlexTZ wrote: »

  Hello,
  
  The report does not contain any data. It contains datasource schema only. So I don't understand this:

  AlexTZ wrote: »

  But its displaying the data directly from the test.frx file, instead of Dataset.

  
  Hey Hurray !! Right, datasource schema... Thanx Alex. Its working now.
• mohanaraj 600001

  September 2009 edited 12:30PM

  Dear Alex,
  
  i read the post #4 you mentioned as the "run this code in the local machine" that means run this as windows application? or web application.
  
  When select the design report in the webreport component that placed in the aspx page it display the connection wizard window to create new connection in that only display the connection type as MS Access Connection, XMl Databse, OLEDB Connection, MS SQL Connection in that what i choose? to load my dataset. As you mention, i did report.register to register my dataset before that how can i design the report with the fields from the stored procedure. Please guide me i'm in urgent to finish this task.
• AlexTZ

  September 2009 edited 12:30PM

  Go to the "Data|Choose Report Data..." menu. Did you see tables of your dataset?
• mohanaraj 600001

  September 2009 edited 12:30PM

  AlexTZ wrote: »

  Go to the "Data|Choose Report Data..." menu. Did you see tables of your dataset?

  
  
  Hai Alex,
  
  Thanks, I got it. Do you suggest how to do summary report.
  
• AlexTZ

  September 2009 edited 12:30PM

  Hello,
  
  Please read the user's manual, it has a chapter "Report creation" which covers all report types.