?
Solved

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

Posted on 2008-06-14
10
Medium Priority
?
211 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
  • 4
  • 3
7 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

862 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