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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help Formatting

Author  Topic 

tdwainet
Starting Member

5 Posts

Posted - 2011-03-10 : 12:51:22
I have developed SQL code that is pulling all the information that I need; however, when I cut this code into Report Buider 3.0 SQL Report Writter it seems to manipulate the data by merging groups together. It is very simple what I want to accomplish.

DocNum Customer Detail Info
1234 Handys XXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXX
2345 Jims XXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXX

I only want the DocNum & Customer to be printed once; however, there could be several detail lines that are coming in from multiple tables. Currently all Info is there including DocNum and Customer on each line.

Could someone please help me accomplish this task. I am very new to SQL Report Builder 3.0 .

Todd Thomasson
   

- Advertisement -