?
Solved

SQL Reporting Services - Report only shows first record in trable

Posted on 2006-06-22
4
Medium Priority
?
999 Views
Last Modified: 2006-11-18
Hello All, here's my scenario:
I created this report in SRS that displays information from a table (duh!) in a kind of "sheet" format, each record from the table should be displayed on a diferent sheet, so the keying department print those sheets and do the updates manually on another system.

The report is created, looks great and the managers love it, however, only the first record from the table is being displayed, I don't get all 15 records that I currently have on the table and the formulas on each cell of the report looks like "=Fields!TableField.Value"... I've created this same type of process before and worked, for some reason now it doesn't... Hopefully you guys can help me out on this, I'm running out of time and ideas...

Thanks in advance!
0
Comment
Question by:igorblackbelt
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
dnsvh earned 500 total points
ID: 16961721
When you say 'sheet' format, are you talking about using a list?  If you want each record to display on a separate sheet, you would use a list to do this.
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 16967209
Obvious question, but does the dataset return 15 records?
Are the formulas in the detail, grouping or header/footer rows?
Does the table have any grouping or filters?
0
 

Author Comment

by:igorblackbelt
ID: 16968806
Yes, the dataset returns 15 records.
The Formulas are on regular textboxes, I didn't create them using a table.
No, no fielters, no grouping yet.
0
 

Author Comment

by:igorblackbelt
ID: 16984588
dnsvh -
By Key Sheet, I mean a form, I'm receiving a file, processing into a SQL table and have to display each record on a separate sheet/page. Hope this helps. I'll give that a shot.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

601 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