End User Designer - set datasource to .Net dataset at run time

End User Designer - set datasource to .Net dataset at run time

Posted by: bhirsch on 4 October 2020, 3:35 am EST

• 

  bhirsch

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 October 2020, 3:35 am EST

  I want to make the End-User Designer access a .Net dataset for a Winforms application with multiple tables available for reporting. Ideally, I’d like to display all of the tables and fields on the Report Explorer and allow the end-user to create their own queries on the datasource. Is this possible?

  As an alternative, I can give access to the backend SQL server, but the user won’t know the credentials and I don’t want them to be able to execute queries that would alter the data or save the credentials in the report definition. I think this is a security risk. Help.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 4 October 2020, 10:15 pm EST

  Hello,

  You question is replied in the following S1 Post:
  
  https://supportone.componentone.com/casedetail/466104

  Please reply to above post only to avoid confusion.

  Thanks,
  
  Mohit

• 

  bhirsch

  • Post Options:
  • Link
    Copy

  Posted 5 October 2020, 11:52 pm EST

  Thank you, that is very close to what I need. Unfortunately, your code doesn’t appear to support any type of SQL select joins between tables, which is the ultimate goal here. I may have to try a different strategy (create a SQL user with lower permissions or copy my database to a temporary database and connect to that). So here are the next two questions:

  1. Do you have code to perform a relationship SELECT using joins on a .Net dataset containing multiple tables and foreign keys?
  2. I’ve been looking all over your website and forums for samples like the code you just provided. Where can I find this code online to do my own research?
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 October 2020, 11:15 pm EST

  Hello,

  You question is replied in the following S1 Post:
  
  https://supportone.componentone.com/casedetail/466104

  Please reply to above post only to avoid confusion.

  Thanks,
  
  Mohit