VB.NET ReportingService2005 QueryDefinition.CommandText

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

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.
12,808 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,813 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2020-08-26T06:05:27.127+00:00

    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. ZoeHui-MSFT 33,296 Reputation points
    2020-08-27T03:11:21.2+00:00

    Hi,

    Here is an example for you.

    Hope it can be helpful.

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

    SSRS-Report-Subscription-using-Csharp

    0 comments