Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hbadministrator
Posting Yak Master
120 Posts |
 Posted - 2013-04-02 : 16:05:34
|
| I am having issues creating a Statement Report. I currently am using a Rectangle then placed a table over top that has a group by on the table(From-cust). The data I will share has 32 records and the Same From cust, some same Cust-no and some different. I want to create a report that can say Bill to cust-no = From cust and has transactions place data all on one page. If Cust-no is not = to From cust create new page and if transaction place all data on that page and next page and next page how ever many differences.AKAFrom-cust Cust-no Debit Balance*OTC *OTC 99.99 5984.45 All on Sheet 1*OTC *OTC 199.12 5772.45 All on Sheet 1*OTC *OTC 123.54 3548.48 All on Sheet 1*OTC *OTC 36.54 1237.48 All on Sheet 1*OTC 011 154.45 3957.25 All on Sheet 2*OTC 011 58.65 4895.43 All on Sheet 2*OTC 011 587.47 3489.15 All on Sheet 2*OTC 012 487.56 1265.17 All on Sheet 3*OTC 012 6.57 6987.14 All on Sheet 3*OTC 013 .78 4783.15 All on Sheet 4*OTC 013 84.74 7865.75 All on Sheet 4ONE TABLE Grouped off of From-Cust currently The fields I have are Bill To = Cust_noChargeNameCharge AddressChargeCity, ChargeState ChargeZipLocation = From-custSiteNameSiteAddressSiteCity, SiteState SiteZip |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-03 : 01:16:03
|
| very difficult to understand report layout from words. Can you create a screenshot for us? Upload in some shared server and put link here------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
hbadministrator
Posting Yak Master
120 Posts |
Posted - 2013-04-03 : 07:27:52
|
| Sure |
|
|
|
|
|
|
Issue with Rectangles creating a page by page