Reports
-
Hello Guys, In My applicaiton at work I am calculating the payslips for each month and after i done that I have created a Report object and desgned it. I created a form with a MicrosoftReportViewer and assigned that report to that control. I created the dataset, assigned it to the report and then when the form loads I am filling the dataset with the table adapter. Now here comes the problem. What I want is for example I choose 5 employees from the list and print an individual report for each one. Each report will have the details of one employee. How can i do this guys? In short word what I want is a personalized Report for each Employee's payslip details generated automatically after each other. Your help will be greatly appreciated ;) Regards, Christian Pace
-
Hello Guys, In My applicaiton at work I am calculating the payslips for each month and after i done that I have created a Report object and desgned it. I created a form with a MicrosoftReportViewer and assigned that report to that control. I created the dataset, assigned it to the report and then when the form loads I am filling the dataset with the table adapter. Now here comes the problem. What I want is for example I choose 5 employees from the list and print an individual report for each one. Each report will have the details of one employee. How can i do this guys? In short word what I want is a personalized Report for each Employee's payslip details generated automatically after each other. Your help will be greatly appreciated ;) Regards, Christian Pace
Mould your logic so that you send only the currently logged in user data. I think you should filter the data in the Dataset / in query and then send the dataset to the Report. This way it will only show the report of the current user. :thumbsup:
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript -
Mould your logic so that you send only the currently logged in user data. I think you should filter the data in the Dataset / in query and then send the dataset to the Report. This way it will only show the report of the current user. :thumbsup:
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using JavascriptBut thats the point the application already doest that. But what i want is instead of passing it 1 USERID instead i want to pass an array of USERIDs and it will generate a single report for each USERID and print the reports automatically after each other. ;)
-
But thats the point the application already doest that. But what i want is instead of passing it 1 USERID instead i want to pass an array of USERIDs and it will generate a single report for each USERID and print the reports automatically after each other. ;)
Ya.. Actually report will be one because it depends on the report viewer. What you can do is to place page breaks to have each payslip in each page. So when you print, it will look like it is producing multiple reports. In rdlc you can place pagebreak on each control. Just see properties. :)
Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->** Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript -
Hello Guys, In My applicaiton at work I am calculating the payslips for each month and after i done that I have created a Report object and desgned it. I created a form with a MicrosoftReportViewer and assigned that report to that control. I created the dataset, assigned it to the report and then when the form loads I am filling the dataset with the table adapter. Now here comes the problem. What I want is for example I choose 5 employees from the list and print an individual report for each one. Each report will have the details of one employee. How can i do this guys? In short word what I want is a personalized Report for each Employee's payslip details generated automatically after each other. Your help will be greatly appreciated ;) Regards, Christian Pace
1. Create a temporary table in the database with a single column that holds the EmployeeID. 2. Join this table with other tables in the report's query based on the EmployeeID column. 3. At the time of generating the report, populate this table with the list of employees for whom you want to generate the report. 4. If multiple users will be generating reports simultaneously, use an additional column to store UserID of the logged in user (or any unique value will solve the purpose).
-
1. Create a temporary table in the database with a single column that holds the EmployeeID. 2. Join this table with other tables in the report's query based on the EmployeeID column. 3. At the time of generating the report, populate this table with the list of employees for whom you want to generate the report. 4. If multiple users will be generating reports simultaneously, use an additional column to store UserID of the logged in user (or any unique value will solve the purpose).
Yes I was thinking of the same thing but my problem now is that how am I going to get that data from the temporary table and then from that data generate individual reports for each of the users that there are in the database. Now can you help me in means of what code to use so I can do this. Currently I am doing this with microsoft's report viewer but the problem is after I createvthe dataset and bind it to the report and then fill the data only 1 report will be generated now what iwant for a report for every user to be generated automaticcaly. Sorry if you are not understanding me guys.
-
Yes I was thinking of the same thing but my problem now is that how am I going to get that data from the temporary table and then from that data generate individual reports for each of the users that there are in the database. Now can you help me in means of what code to use so I can do this. Currently I am doing this with microsoft's report viewer but the problem is after I createvthe dataset and bind it to the report and then fill the data only 1 report will be generated now what iwant for a report for every user to be generated automaticcaly. Sorry if you are not understanding me guys.