Dynamic replacement of a source of data in report FastReport in C #

Question

1.00/5 (3 votes)

See more:

How to dynamically change the data source in a report FastReport with tables from a database to a DataSet?
There is an example of dynamically creating a report from scratch. But this naturally requires the prescribing of all fields.
Easier to visually create report file with the source from the database. And then change the source to the DataSet.
Try this:

Report report = new Report();
	report.Load(ss);							//I load a file of the report
        report.Dictionary.Clear();						//I delete an old source of data
        report.Dictionary.RegisterData(ds.Tables[nTab], имя таблицы, true); 	//I register new
        report.RegisterData(ds);
        // add report page
        ReportPage page = new ReportPage();
        report.Pages.Add(page);
        page.CreateUniqueName();

        // create title band
        DataBand dataBand = new DataBand();
        page.Bands.Clear();
        page.Bands.Add(dataBand);
        dataBand.CreateUniqueName();							
        dataBand.DataSource = report.GetDataSource(имя таблицы);		//I set the table for
 
        dataBand.Height = Units.Centimeters * 0.5f;
        report.Show();

Displays only one row.

Posted 27-Jan-11 0:25am

vitvikt

Updated 2-Apr-19 22:14pm

m@dhu

v4

Add a Solution

Comments

CPallini 27-Jan-11 6:31am

Please take care of translating your text to English.

m@dhu 27-Jan-11 6:35am

Translated to english.

CPallini 27-Jan-11 6:39am

Very good (it's a pity I cannot vote you for that!). Could you please translate the title too (I may just guess it...).

m@dhu 27-Jan-11 6:57am

Thanks sir. Updated.

[no name] 27-Jul-17 3:31am

If you clear all dictionary...you lost all data from report (totals, params, functions...).

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 2785104 · Answer 1 · 2019-04-02T22:15:00

The databand is not connected to a datasource. Add last line to connect databand to datasource:

C#

report.Load(ss);							
report.Dictionary.Clear();						
report.Dictionary.RegisterData(ds.Tables[nTab], имя таблицы, true); 	
report.RegisterData(ds);
((DataBand)report.FindObject("Data1")).DataSource = report.Dictionary.DataSources[0];

"Data1" is databand name of your report.

Christian Graus · Answer 2 · 2011-01-27T02:28:00

Solution 1

If FastReport is a library, you need to ask them how to use it.

Posted 27-Jan-11 2:28am

Christian Graus