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

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

  • 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.
  • Replied 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
  • Replied 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?
  • Marked as Answer

    Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels