Phuminvibol
Top achievements
Rank 1
Rank 1
Phuminvibol
asked on 01 Jul 2014, 06:07 AM
Hello everyone,
I have been trying to find an easier way to update data in a table cell dynamically for the last hour.
Basically, i have a table that summarizes the activity of a sales person, tracking how many emails or calls he's been making. What i have been doing is, i have each cell call a C# function, and the C# function would directly make connection to the database to grab the number of calls, emails or appointment he's been making. The problem with this is if i have about 20 cells, this approach would be hugely insufficient due to each cell making a connection to one database table at the same time. So my question is, Is there a better way to do this? Please refer to the attached image. Thank you!
I have been trying to find an easier way to update data in a table cell dynamically for the last hour.
Basically, i have a table that summarizes the activity of a sales person, tracking how many emails or calls he's been making. What i have been doing is, i have each cell call a C# function, and the C# function would directly make connection to the database to grab the number of calls, emails or appointment he's been making. The problem with this is if i have about 20 cells, this approach would be hugely insufficient due to each cell making a connection to one database table at the same time. So my question is, Is there a better way to do this? Please refer to the attached image. Thank you!
3 Answers, 1 is accepted
0
KS
Top achievements
Rank 1
Rank 1
answered on 03 Jul 2014, 01:04 PM
0
Phuminvibol
Top achievements
Rank 1
Rank 1
answered on 03 Jul 2014, 08:00 PM
Hi KS, thanks for replying,
That is exactly what i did afterward, however is there an even better way to achieve this without using sql or c# but just the table control? Thanks
-Vibol
That is exactly what i did afterward, however is there an even better way to achieve this without using sql or c# but just the table control? Thanks
-Vibol
0
KS
Top achievements
Rank 1
Rank 1
answered on 04 Jul 2014, 04:05 PM
Hi Vibol,
In all cases the data should come from somewhere like database, csv file, entity data model, and then the report designer allows you to work with the data via data source components, which can be set to any DataSource property of report, table, chart etc.
-KS
In all cases the data should come from somewhere like database, csv file, entity data model, and then the report designer allows you to work with the data via data source components, which can be set to any DataSource property of report, table, chart etc.
-KS