Solved

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

Posted on 2008-06-14
10
194 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
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now