• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

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

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
salman_sulaiman_2008
Asked:
salman_sulaiman_2008
  • 4
  • 3
1 Solution
 
salman_sulaiman_2008Author Commented:
Greetings PenquinMod!
thanks for the reply mate!
I'll be looking forward to that.

thanks.

Best Wishes,

~salman~
0
 
Bob LearnedCommented:
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
 
salman_sulaiman_2008Author Commented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Bob LearnedCommented:
It might be good to know how you would do it in Access--it might be similar.
0
 
Bob LearnedCommented:
Something like this?
SSRS-Grouping-Example.png
0
 
salman_sulaiman_2008Author Commented:
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
 
salman_sulaiman_2008Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now