VB.NET ReportingService2005 QueryDefinition.CommandText

asked 2020-08-25T14:44:15.323+00:00
jim brown 251 Reputation points

I would like to know if there is a good example of ReportingService2005 QueryDefinition.CommandText using vb.net. My goal is to retrieve / get the SQL within the rdl report. I found this Link but no examples how to use it. any suggestions is greatly appreciated.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,475 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,095 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2020-08-26T06:05:27.127+00:00
    ZoeHui-MSFT 18,671 Reputation points Microsoft Employee

    Hi,

    I'm not familiar with VB.net, do you mean like shown in the link?

    Syncfusion.EJ.ReportViewer~Microsoft.SqlServer.ReportingServices2010.QueryDefinition~CommandText.html

    Regards,

    Zoe


  2. answered 2020-08-27T03:11:21.2+00:00
    ZoeHui-MSFT 18,671 Reputation points Microsoft Employee

    Hi,

    Here is an example for you.

    Hope it can be helpful.

    queryDefinition.CommandText = "Select ReportTitle,ReportSubTitle from ReportDetail";

    SSRS-Report-Subscription-using-Csharp

    No comments