report only displays one row

I added a report viewer, clicked create new report, and followed the wizards. My report only displays one row on one page. I can see all the rows if I preview contents on the data table adapter. There are no filters and no where clause in the SQL. What might the reason be that the report only shows one row? Thanks

HI,dmcdivitt:

Try to use a simple sql statement without any parameter and filter and following the Add New Report Wizard. If you still face to the same sitution, please feel free to post your question here for more discussion.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

I created a new report with a simple SQL statement and got the same result - one row on one page. No more. The table used has 1300 rows. No filters, no parameters, and no where clause was used anywhere.

|||

I will ask this in another forum. Nobody seems to read this one.

|||

HI,dmcdivitt:

I am sorry that i have came back home early and have not read your posts in time due to the different time region.

It is really weird. I hope you can send me your project to me and i will have a check with it.

Please use the simple query string and the common datatable(NORTHWIND).

Here is my address:sighlen@.sina.com

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Resolved. See threadhttp://forums.asp.net/t/1128061.aspx

Report looks different in browser than in development environment

I have a tabular report that has horizontal lines separating the rows. The
row heights are all the same in the development environment, but in the
browser there are many different heights and it looks like crap. Any
suggestions?The Dev environment previews as an Image, not as HTML. Try rendering to an
image format(tiff) from the browser and see how it looks.
--
| Thread-Topic: Report looks different in browser than in development
environment
| thread-index: AcUfSW1UwXSqLdOGS0q4ha3NKeZY/A==| X-WBNR-Posting-Host: 67.41.128.193
| From: "=?Utf-8?B?VGVkZHkgU2FsYWQ=?="
<TeddySalad@.discussions.microsoft.com>
| Subject: Report looks different in browser than in development environment
| Date: Wed, 2 Mar 2005 09:01:07 -0800
| Lines: 4
| Message-ID: <4587D354-7348-4541-B9F7-0D7FAA7B499D@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA
03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:44343
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a tabular report that has horizontal lines separating the rows.
The
| row heights are all the same in the development environment, but in the
| browser there are many different heights and it looks like crap. Any
| suggestions?
|

Report Format with a Group

Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.

You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.

You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.

|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||

Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.

In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.

Report Format with a Group

Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.

You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.

You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.

|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||

Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.

In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.