in

C1 Community

ComponentOne Community is a free source for developers and help authors to collaborate and communicate.

supress stored procedure parameter dialog box from coming up

Last post 04-22-2008 12:47 PM by daktmacfan. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-22-2008 11:46 AM

    supress stored procedure parameter dialog box from coming up

    Hi,

    I am using some SP's for data sources for my reports and subreports.  Is there a way in code or something to put in the report xml so that the parameter dialog doesn't come up everytime the report is run?  I am manually updating the parameters in the report xml.  When the dialog comes up it is already populated with the values that I want to send to the SP.

     thanks,

  • 04-22-2008 12:47 PM In reply to

    Re: supress stored procedure parameter dialog box from coming up

    I actually figured it out...

    Must use DataSource.GetRecordSource() method to get the string that can be used to open a recordset.

     EX:

    _c1Report.DataSource.RecordSource = _c1Report.DataSource.GetRecordSource(false);

     

Page 1 of 1 (2 items)
Contact ComponentOne: 1.800.858.2739 ©1987-2008 ComponentOne LLC All Rights Reserved.