Minggu, 14 April 2013

Make Report StarDate and EndDate with Reporting Service


How Make Report using Stardate and EndDate with Reporting Service.

Only Example.;

I have one Table with Name dbo.OutPengeluaran_detail with desain:

if we has make that table and have content data to show in reporting service.Example we see below:


Now start to open Reporting service in Sqlserver 2008 R2 and you open Report Builder.you can see below:

you must clik and show this below and choose blank report


and now we start desain report step by step :

we must connection database and table using report.



step two we make connection at dataset .you can see below:


step three we make add parameter name StarDate .screenshoot you see below:


Step Four we make add paramater again name EndDate.screenshoot you see below:



and result we make stardate nd Endate we see screenshoot below:

we make field stardate and field endate in Dataset:

StarDate in Dataset


EndDate in Dataset


and now we add field stardate and enddate in dataset


and we make setting to between stardate and enddate  in dataset and result you can see



and finaly to reporting you must right clik on insert table and you can drag field you need.
this below screenshoot report :



and if you run this screenshot report:




---------Oke Thank You mybe can be useful.---------



































1 komentar: