Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SSRS Report Development RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    Check the Connection table or FilteredConnection view.

    Thanks

    Sachith Chandrasiri

    Friday, July 11, 2014 6:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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