locked
SSRS CRMAF_Prefilter RRS feed

  • Question

  • Hi

    I want to pre-filter CRM Report and using following query

    but it does not pre-filter record

    SELECT  CRMAF_ses_student.ses_studentId ,
            CRMAF_ses_student.ses_Student ,
            CRMAF_ses_student.ses_StudentName ,
            col_StudentInvoicePayments.TrxID ,
            col_StudentInvoicePayments.TrxNo ,
            col_StudentInvoicePayments.TrxDate ,
            col_StudentInvoicePayments.Name ,
            col_StudentInvoicePayments.TotalAmount
    FROM    ses_student AS CRMAF_ses_student
            INNER JOIN col_StudentInvoicePayments ON CRMAF_ses_student.ses_studentId = col_StudentInvoicePayments.ses_StudentId 

    if anyone have an idea please share with me

    Monday, December 23, 2013 2:18 PM

Answers

  • Hello,

    Try to use following query:

    SELECT  CRMAF_Filteredses_student.ses_studentId ,
            CRMAF_Filteredses_student.ses_Student ,
            CRMAF_Filteredses_student.ses_StudentName ,
            Filteredcol_StudentInvoicePayments.TrxID ,
            Filteredcol_StudentInvoicePayments.TrxNo ,
            Filteredcol_StudentInvoicePayments.TrxDate ,
            Filteredcol_StudentInvoicePayments.Name ,
            Filteredcol_StudentInvoicePayments.TotalAmount
    FROM    Filteredses_student AS CRMAF_Filteredses_student
            INNER JOIN Filteredcol_StudentInvoicePayments ON CRMAF_Filteredses_student.ses_studentId = Filteredcol_StudentInvoicePayments.ses_StudentId 


    Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
    My blog

    • Marked as answer by Riaz Usmani Monday, December 23, 2013 4:02 PM
    Monday, December 23, 2013 2:32 PM
    Moderator