c# - How to Repeat Invoice for each company with stimulreport -
i using stimulsoft
report in asp.net c# language. have report 3 list, 1 head list , 2 other list detail. it's bill report range of date. problem can't repeat them in order like; following list , report want :
haedlist >> billid,coname,totalprice,invoicedate servicelist >> billid,servicename,servicecost productlist >> billid,productname,productcost
the user enter date range, example 2015/01/01 2015/01/03
--> page 1 billid=52 ---- coname=haaret servicename=repair,servicecost=12$ servicename=cleaning,servicecost=2$ productname=dvd,productcost=10$ productname=cpu,productcost=60$ productname=vga,productcost=40$ totalprice=124$ tax=4$ total >> 120$ --> page 2 billid=55 ---- coname=girbold servicename=training,servicecost=300$ productname=pen,productcost=5$ productname=notebooks,productcost=10$ totalprice=315$ tax=4$ total >> 311$ --> page 3 billid=70---- coname=drillport servicename=driver,servicecost=30$ servicename=test,servicecost=10$ productname=battery,productcost=35$ productname=monitors,productcost=200$ totalprice=275$ tax=4$ total >> 271$
so have 3 days in range, , should print 4 pages in following order. problem head repeats 3 times service printed, , product, , summary head, following:
billid=52 ---- coname=haaret billid=70---- coname=drillport billid=55 ---- coname=girbold servicename=repair,servicecost=12$ servicename=cleaning,servicecost=2$ servicename=driver,servicecost=30$ servicename=test,servicecost=10$ servicename=training,servicecost=300$ productname=dvd,productcost=10$ productname=cpu,productcost=60$ productname=vga,productcost=40$ productname=pen,productcost=5$ productname=notebooks,productcost=10$ productname=battery,productcost=35$ productname=monitors,productcost=200$ totalprice=124$ tax=4$ total >> 120$ totalprice=315$ tax=4$ total >> 311$ totalprice=275$ tax=4$ total >> 271$
the following link contains 3 image , report template have made project.
best regards
you should put billid
, coname
in group header , servicename
,servicecost
,productname
,productcost
in data , totalprice
,tax
, total
in group footer.
i not have stimula in system, template seems did not have group header or footer.
also check send correct query(with correct group by
) report data source.
Comments
Post a Comment