Solved

How To Display Associated Table Rows On Different Pages In The Report???

Posted on 2008-06-14
10
206 Views
Last Modified: 2013-11-26
Greetings experts!
I hope someone could help me with this. what I am trying to do is create a report using the SQL SERVER 2005 Report designer. I have a stored procedure which retrives a number of records from a table, these records have two main fields, "Outer_NO" and "Inner_NO". what I would like to do, is display the records with similar "Outer_NO" on seperate pages on  the report, it is like grouping the records with the same value for the "Outer_NO" on a seperate page. I have tried few things to accomplish this but without success. So Far I have tried to create a table in the report and then setup the "Group" property of the table row, but what this has done is like carrying out a "Distinct Select" based on the "Outer_NO", so I ended up with only one record on every page instead of the several records on each page. I can't seem to figure out how to accomplish this. I would really appreciate any help or tips .
Thanks in advance.

best wishes,
~Salman~
0
Comment
Question by:salman_sulaiman_2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
10 Comments
 

Author Comment

by:salman_sulaiman_2008
ID: 21810901
Greetings PenquinMod!
thanks for the reply mate!
I'll be looking forward to that.

thanks.

Best Wishes,

~salman~
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 21812073
Hmmm...I can't quite see what you are talking about.

Is it something like this?

Outer_NO
     Inner_NO
        record
        record
        record
<page break>
Outer_NO
     Inner_NO
        record
        record
        record
0
 

Author Comment

by:salman_sulaiman_2008
ID: 21818898
Greetings TheLearnedOne!
thanks for the reply.

Yes, exactly, that is what I meant. just the way you described it. so in other words, I need to display the records with identical "Inner_NO" in one page, and then break, and the next page comes the next set of records.

~salman~
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 96

Expert Comment

by:Bob Learned
ID: 21821342
It might be good to know how you would do it in Access--it might be similar.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 21821644
Something like this?
SSRS-Grouping-Example.png
0
 

Author Comment

by:salman_sulaiman_2008
ID: 21828599
Greetings PenguinMod and The LearnedOne!
Thanks for the reply mates!
I'll try to apply what can be done in access in the report designer.
and let you know how it goes.!
thanks. I really appreciate your help.!

Best Wishes,

~salman~
0
 

Author Comment

by:salman_sulaiman_2008
ID: 21852547
Greetings mates!
I am so excited, It actually worked..I follwoed the LearnedOne suggestions and applied it in the SQL Report Designer, and I ended up with the wanted results.! it is fantastic..! Thanks!

Best Wishes,
~salman~
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question