Click here to Skip to main content
15,905,781 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hai friends....

i am new to reports this is my first report please help me if any one knows

i need a rdlc report for employee palyslip/salary voucher for that i created a stored procedure in that i am getting all vlaues
here what i need is when i run thae application each page it will show two table one is employee monthly salary details and another one deduction detalis for every employee id in each page only one employee details will be diplayed in stored procedure i am getting all the details for this report generation how to create rdlc report here i am not passing any parameters like employeeid and all i am not passing anything but when i run tha application in every page it will show one employee detalis like what i said how to do..

[edit]Urgency deleted - OriginalGriff[/edit]
Posted
Updated 5-Sep-14 8:06am
v5
Comments
ZurdoDev 5-Sep-14 13:01pm    
Where are you stuck?
[no name] 5-Sep-14 13:55pm    
No it's not urgent at all. And we are not providers we mostly help people that have made at least an attempt to do their own job.
OriginalGriff 5-Sep-14 14:06pm    
Urgency deleted: It may be urgent to you, but it isn't to us. All that your stressing the urgency does is to make us think you have left it too late, and want us to do it for you. This annoys some people, and can slow a response.

And...DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.

1 solution

First create a Dataset by right clicking solution add new item->Data->Dataset then from your connection drag and drop your stored procedure into the Dataset design.

Then create a rdlc report(hope you know that). Then there will be New button above the toolbox of rdlc report click on that and click on dataset and give a name and choose the dataset from the dropdown list and click save. Now the dataset is referred to your rdlc report. Come to rdlc report drag and drop your controls and suppose it is a textbox right click on it there will be a option like Expression there you can see plenty of option. As you need to bind to a dataset you can see dataset in left side panel click on it then all field available in the referred dataset will be displayed on right side panel there double click on it now a expression will be in the top most box and note that if it is an int field then the expression will be like SUM(Field......) so if you wanna display the value instead of sum make it as FIRST. Do same for remaining fields

Come to form. Create new form and drag and drop reportviewer from the toolbox. In the top right corner of the reportviewer you can see a small arrow click on it there you can select your rdlc reports. It will automatically create soome function like

C#
some....TableAdapter.fille(this.datasetname....)
...RefreshReport();


in page load of form
if you wanna display the report when page loads keep it in page load or make it as you need
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900