SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Issue with Rectangles creating a page by page
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hbadministrator
Posting Yak Master

119 Posts

Posted - 04/02/2013 :  16:05:34  Show Profile  Reply with Quote
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.


AKA
From-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 4


ONE TABLE Grouped off of From-Cust currently
The fields I have are
Bill To = Cust_no
ChargeName
Charge Address
ChargeCity, ChargeState ChargeZip


Location = From-cust
SiteName
SiteAddress
SiteCity, SiteState SiteZip

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/03/2013 :  01:16:03  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

hbadministrator
Posting Yak Master

119 Posts

Posted - 04/03/2013 :  07:27:52  Show Profile  Reply with Quote
Sure
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000