shared dataset with crystal report

Question

how i can make sure the user prints only his selected information not other user's information both users use same table or same dataset with cyrstal report

pls help

i am using c# application , VS2019 with crystal report to be used by doctors to print prescriptions at the same time

thanks

OB

Adarsh Nigam · Answer

To ensure that each doctor prints only their selected information and not data from other users in a C# application using Crystal Reports, you can implement the following steps: User Authentication and Authorization : Ensure each doctor logs in with a unique ID. Assign permissions to each user based on their ID. Parameterized Reports : Use parameters in Crystal Reports to filter data. Pass the logged-in doctor's ID as a parameter to the report. Data Filtering in the Query : Filter the dataset based on the logged-in user's ID before passing it to the report. Use SQL queries or LINQ to filter the data. Implementation Example User Login : Authenticate users and store the logged-in user’s ID. Filtering Data : Filter the dataset using the logged-in user's ID. Example SQL query: SELECT * FROM Prescriptions WHERE DoctorID = @DoctorID Passing Parameters to Crystal Report : Pass the filtered data or the DoctorID parameter to the Crystal Report. Code Example // Assuming you have a method to get the logged-in doctor's ID int loggedInDoctorId = GetLoggedInDoctorId(); // Fetch data filtered by DoctorID var filteredData = GetDataForDoctor(loggedInDoctorId); // Create a new Crystal Report instance ReportDocument reportDocument = new ReportDocument(); reportDocument.Load("PathToYourReportFile.rpt"); // Set the data source for the report reportDocument.SetDataSource(filteredData); // Optionally, pass parameters if needed reportDocument.SetParameterValue("DoctorID", loggedInDoctorId); // Display or print the report crystalReportViewer.ReportSource = reportDocument; Explanation User Authentication : Ensure that each doctor is authenticated and their unique ID is stored. Data Filtering : Fetch only the data relevant to the logged-in doctor using SQL or LINQ. Report Binding : Bind the filtered data to the Crystal Report or pass the doctor’s ID as a parameter. This approach ensures that each doctor can only print their own prescriptions, maintaining data privacy and integrity.