retrieving fields from data explorer

[Geejay]

Hello,

maybe I'm missing something but I have a problem with retrieving fieldnames from the data explorer. I use the quickstart example for creating a report. I set up the datasource and  I can see the fieldnames in the data explorer but when I want to drag a field on to my report it becomes a 'regular' textbox. Then connection with the field from the data explorer gets broken.
Or maybe I'm doing something wrong but I can't find posts with a simular problem.

Thank you.

Geert

[Chavdar]

Hi Geejay,

After dragging a field from the Data Explorer to the report a TextBox report item should appear with its Value property set to =FieldName (e.g. "=ProductName"). If you have used the Data Source Configuration Wizard to generate the data source then there is one additional step which should be done in order to get the things working. You have to manually fill the data set. Here is an example:
   
    public partial class Report1 : Report
    {
        public Report1()
        {
            /// <summary>
            /// Required for telerik Reporting designer support
            /// </summary>
            InitializeComponent();

            this.adventureWorksDataSetTableAdapter1.Fill(this.adventureWorksDataSet1.AdventureWorksDataSetTable);
            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }
    }

I hope that this is the problem, so give it a try. Let me know if it persist after this.

 
Greetings,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Reza]

I have problem with retreiving  data source columns defined for  my report by clicking data explorer option in telerik reporting menu .

I have a class library project and inside it I create a new telerik reporting class . then I cancel  it's wizard and I put a sql data adapter into my report and  set my connection string and  after that select my desire stored procedure in sql data adapter wizard  from the list and then finisih. After doing all of the mentioned steps I select my report and then set it's data source to sql data adapter / datasource1 , but when I refer to data explorer option and select it report designer say :  procedure or function sp_GetDailyOrders expected parameters @cmp_Id which was not supplied and then no data source column will retreive for me .

If go to select command property of my sql data adapter and then select it's sub property parameters and the assign a default value for my @cmp_Id then data explorer will retreive my data source columns .

Ok, may you please tell me what is the problem ! I don't want to set default value for my paremters .

Please help me .

[Steve]

Hello Reza,

You can review the following KB article that elaborates on using Telerik Reporting with stored procedures. There is a working project at the very bottom - please give it a spin and let us know of the outcome. Using data source with parameters in Telerik Reporting.

Regards,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.