locked
SSRS Report Development RRS feed

  • Question

  • Hi All,

    I have developed SSRS Report, now I want to get the staff details for which I got created connections roles. now my doubt is how to retrieve the connections in report?

    Thursday, July 10, 2014 10:40 AM

All replies

  • Check the Connection table or FilteredConnection view.

    Thanks


    Sachith Chandrasiri

    Friday, July 11, 2014 6:42 AM
  • Thanks sachith,

    I have used connection view, but now I need to filter based on roleid= "witness";

    I am using below query just for retrieving for filtering what should be the condition, please provide me the query .

    SELECT

            new_incidentreport.new_Date, new_incidentreport.new_name, new_incidentreport.new_TrackingNumber, new_incidentreport.new_Actionstaken, new_incidentreport.new_DescriptionofInjuries,

                             new_incidentreport

    .new_DescriptionofWeapons, new_incidentreport.new_EmployeeSignature, new_incidentreport.new_PlannedUseofForce, new_incidentreport.new_Time,

                             new_incidentreport

    .new_ToName, new_incidentreport.new_TypeofIncidentName, new_incidentreport.new_DetailedDescriptionofIncident, Connection.Record2IdName

                            


    FROM

                new_incidentreport CROSS JOIN


                             Connection

    Friday, July 11, 2014 6:54 AM