[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2008-06-14
10
Medium Priority
?
210 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

650 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