• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

SQL SERVER Reporting services

I am developing an application using vb.net and sql server.
also I wish to use SQL SERVER Reporting services  for my Reports
 
I need to print a report using tables
  1. Invoice Header table -
      Fields :InvoiceID
                  Invoice Date
                  Invoice Number
                  Customer

  2. Invoice Detail Table
      Fields :  InvoiceID
                   Product
                   Qty
                   Rate


My Report Should look as below :

Invoice No.    Invoice Date    Customer    Product     Qty     Rate       Invoice Amount
========   =========    ======     ======    ===    ====     ===========
001               01/01/2009      ABC             A1              10       5.00              250.00
                                                                 A2              20     10.00


002               02/01/2009      DEF             A2             100      10.00          1500.00
                                                                A4                 1    500.00        


Can anyone tell me how to accomplish this.
Thanks

0
joan04
Asked:
joan04
  • 5
  • 4
1 Solution
 
daveamourCommented:
Hi Joan
That's an awfully big question.
Can I first check that you have SQL Server Reporting Services installed.
Also what kind of application is this?
0
 
joan04Author Commented:
I do have SQL Server Reporting Services installed
It is a WinForm application.

I just need some tutorial links where I can learn how a similar task is done.

Rgds,
Joan
0
 
daveamourCommented:
Ok can I just check which version of SQL Server you are using and also which version of Visual Studio?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
joan04Author Commented:
I am using SQL Server 2005 and Visual Studio 2005
0
 
daveamourCommented:
Ok well this one should be good:
http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/
And then this one mentions the WinForms control to view reports (reports are actually hosted by IIS and are webpages)
http://channel9.msdn.com/forums/Coffeehouse/256694-Winforms-and-SQL-Reporting-Services/
Hope this helps
 
0
 
joan04Author Commented:
I have already gone thru Steve Joubert's Tutorials the first 2 parts.They surely are Good .

However, I need to know how to accomplish master detail reporting in a single table control as mentioned above.
Should I include all fields in a single query and then Group by the Invoice Number ?
In that case how will I get multiple line items of  Products for the same Invoice while displaying Invoice Date and Customer only once for that particular Invoice No.
 
Hope this makes sense.


0
 
joan04Author Commented:
I  will try out the use of Sub reports and let you know.

Basically What I need is a Sale Register Printout.

Rgds,
Joan
 
0
 
daveamourCommented:
Ok good luck and shout up if you need help
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now