locked
CRM2011 SSRS pass value parameter RRS feed

  • Question

  • Hi all,

    I've got a problem concerning a custom SSRS report that has to get the entityID of a selected record in CRM.

    I'm doing folowing query in a dataset:

    SELECT     invoiceid AS quoteid
    FROM         FilteredInvoice AS CRMAF_FilteredInvoice

    Then I retrieve the invoiceid in a second parameter in the SSRS.

    But the value I get in this parameter is:

    SELECT [esc_subcontainer0].*
    FROM   filteredesc_subcontainer AS "esc_subcontainer0"
           JOIN (SELECT TOP 1 dbo.Fn_beginoflastxday(Getutcdate(), 30) AS
                              modifiedon1,
                              Getutcdate()                             AS
                              modifiedon2
                 ORDER  BY modifiedon1,
                           modifiedon2) AS modifiedondtc
             ON 1 = 1
    WHERE  ( esc_subcontainer0.modifiedonutc >= modifiedondtc.modifiedon1
             AND esc_subcontainer0.modifiedonutc <= modifiedondtc.modifiedon2 ) 

    So there is no ID in the query, can someone help? Thanks in advance!


    Friday, March 7, 2014 9:20 AM

All replies

  • can you arrage your sql?
    Friday, March 7, 2014 10:03 AM
  • Done

    Friday, March 7, 2014 11:04 AM
  • Hi

    Did you manage to resolve this, as the only work around is to edit the RDL file via report builder.

    Thank

    Thursday, December 18, 2014 4:31 PM