Hi all!

I've read i can Customize Report Fields at Run Time.
I've tried creating a blank report with 3 formula fields (@Formula1, @Formula2, @Formula3)

In my c# code i created a DataSet and filled it with data taken from an SQL Server, a simple list of clients (fields: id, name, text1).

Now, how can i use my blank report to assign Formula1 to id, Formula2 to name, etc...

I've tried with:

DtaClienti = new SqlDataAdapter( );
DstClienti = new DataSet( );
CmdClienti = new SqlCommand( );
CmdClienti.Connection = CnnClienti;
CmdClienti.CommandType = CommmandType.Text
CmdClienti.CommandText = "SELECT 'id','name','text1' FROM [01_clienti]";
DtaClienti.SelectCommand = CmdClienti;
DtaClienti.Fill (DstClienti,"clienti");

CrystalReport1 myReport = new CrystalReport1();

myReport.Load();
myReport.SetDataSource(DstClienti);

FormulaFieldDefinitions myFormulas;
FormulaFieldDefinition FormulaField1;
FormulaFieldDefinition FormulaField2;
FormulaFieldDefinition FormulaField3;

myFormulas = myReport.DataDefinition.FormulaFields;

FormulaField1 = myFormulas[0];
FormulaField2 = myFormulas[1];
FormulaField3 = myFormulas[2];

FormulaField1.Text = "{clienti.id}";
FormulaField2.Text = "{clienti.name}";
FormulaField3.Text = "{clienti.text1}";

crViewer.ReportSource = myReport;


But an error occurs telling me that {clienti.id} is not a valid key!
It seems that the report hasn't loaded the dataset correctly. Any Idea???:(