Fridli Jacober
Top achievements
Rank 1
Rank 1
Fridli Jacober
asked on 23 Dec 2009, 01:28 PM
Hi
At the moment I'm testing your report- tool with VB in Visual Studio 2008.
It seems to be a great tool but I have the following problem:
As we have a very detailed right- management on the system (for example each user can have diffrent settings which fields in a table he is allowed to see) we can not simply read the datas from the MS SQL Server.
Is there a possibility to send the data from VB to a report? Can you advise what would be the easiest way?
Thanks
At the moment I'm testing your report- tool with VB in Visual Studio 2008.
It seems to be a great tool but I have the following problem:
As we have a very detailed right- management on the system (for example each user can have diffrent settings which fields in a table he is allowed to see) we can not simply read the datas from the MS SQL Server.
Is there a possibility to send the data from VB to a report? Can you advise what would be the easiest way?
Thanks
1 Answer, 1 is accepted
0
Hi Roland Meier,
Please excuse us for the late response.
The default mechanism for data retrieval which utilizes typed DataSets and DataAdapters is provided for convenience only. This way you do not have to write any extra code to obtain your data, since this code is automatically generated for you by the designer. Of course nothing prevents you from populating your data source somewhere else outside the report, e.g. in your business logic layer, and then assign it to the DataSource property before previewing or rendering that report. In fact you can use any object as a data source as long as it is supported by Telerik Reporting. You can check the list of supported data source types in the online documentation. A good example how to bind the data source programmatically can also be found in the documentation. It uses a SqlCommand and a SqlDataAdapter to populate the data, but you can easily replace that part with an invocation to a method from your business logic layer.
If you have more questions regarding this, please do not hesitate to ask.
Happy Holidays!
Greetings,
Ivan
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Please excuse us for the late response.
The default mechanism for data retrieval which utilizes typed DataSets and DataAdapters is provided for convenience only. This way you do not have to write any extra code to obtain your data, since this code is automatically generated for you by the designer. Of course nothing prevents you from populating your data source somewhere else outside the report, e.g. in your business logic layer, and then assign it to the DataSource property before previewing or rendering that report. In fact you can use any object as a data source as long as it is supported by Telerik Reporting. You can check the list of supported data source types in the online documentation. A good example how to bind the data source programmatically can also be found in the documentation. It uses a SqlCommand and a SqlDataAdapter to populate the data, but you can easily replace that part with an invocation to a method from your business logic layer.
If you have more questions regarding this, please do not hesitate to ask.
Happy Holidays!
Greetings,
Ivan
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.