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 Manager/Viewer Help!!

The parameters box in the report view displays in tabular format if you have
at least two parameters. Can I change this in anyway so it displays in
columan format.
Current display
1. parameter box 2. parameter box
3. parameter box 4. parameter box
Can I change it to display like:
1. parameter box
2. parameter box
3. parameter box
4. parameter boxThe answer is no you can't! Sorry.
You could generate you're parameter asp page and run the report with
url access from a button on the asp page. That way you can be much more
fancy with the parameters.
Chris
OriginalStealth wrote:
> The parameters box in the report view displays in tabular format if
> you have at least two parameters. Can I change this in anyway so it
> displays in columan format.
> Current display
> 1. parameter box 2. parameter box
> 3. parameter box 4. parameter box
> Can I change it to display like:
> 1. parameter box
> 2. parameter box
> 3. parameter box
> 4. parameter box

'Report Is Being Generated' Message and Graphic not Displaying

Hello,
I am using ReportViewer in a Web Page with a Server Report and
Asyncrendering is turned on. The report displays correctly; however, the
'Report Is Being Generated' message and graphic do not display when the
report is loading.
It works fine in Report Manager. It is a big problem because the user can
not tell when a report is loading and they keep pressing the 'View Report'
button.
Any suggestions?
Thanks.Hello,
Have you tried this on other develop machine to develop a new report for
test?
Have you use the impersonate in your ASP.NET web application?
If so, what's the permission you have on the report server?
Also, please add your report server to the trust site in the IE and try to
set the security level to low to have a try.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||> Have you tried this on other develop machine to develop a new report for
> test?
No.
> Have you use the impersonate in your ASP.NET web application?
No.
>Also, please add your report server to the trust site in the IE and try to
> set the security level to low to have a try.
I tried this and it didn't work
What do you suggest based on these answers?
Thank
"Wei Lu [MSFT]" wrote:
> Hello,
> Have you tried this on other develop machine to develop a new report for
> test?
> Have you use the impersonate in your ASP.NET web application?
> If so, what's the permission you have on the report server?
> Also, please add your report server to the trust site in the IE and try to
> set the security level to low to have a try.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
I suggest you to check the develop this report on another machine to check
whether this issue appeared or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
Did you use any User Control to hold the ReportViewer? If you put your
ReportViewer to a single aspx page, does this issue appeared?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello
I find some user got the similar issue as you but I did not find any
solution since I could not reproduce this issue on my side.
Could you try to generate a simple sample which could reproduce your issue
and send it to me?
To reach me, please remove the ONLINE in my email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

report grouping

I have a report that shows/hides group detail with the + for expanding the
group. When the report first displays the detail is hidden (as it should be)
with the + showing. However ... the cursor will only change to a finger
(pointer ... whatever) when the cursor is placed to the left of the + sign.
The user will want to expand the detail by selecting on the + sign and they
cant. Why is this?
Example:
+ Client A
^ -- user must click to the left of the plus sign on Client A to expand
groupThis is a known bug in the report designer preview tab.
When the report is published to the report server, all should be fine and
good in the world.
Rob.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:28AF3C35-5277-407E-8646-C42F1D1D441E@.microsoft.com...
>I have a report that shows/hides group detail with the + for expanding the
> group. When the report first displays the detail is hidden (as it should
> be)
> with the + showing. However ... the cursor will only change to a finger
> (pointer ... whatever) when the cursor is placed to the left of the +
> sign.
> The user will want to expand the detail by selecting on the + sign and
> they
> cant. Why is this?
> Example:
> + Client A
> ^ -- user must click to the left of the plus sign on Client A to expand
> group
>|||Thanks Rob, another question has come up ... my use does not like how the
report has to be so wide when you are drilling down. Is there a way to nest
the drill levels so they appear to render slightly indented rather than
spreading across the page? If it involves expressions please elaborate as I
am struggling with that aspect a bit. Thanks in advance!
"Rob Labbe (Lowney)" wrote:
> This is a known bug in the report designer preview tab.
> When the report is published to the report server, all should be fine and
> good in the world.
> Rob.
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:28AF3C35-5277-407E-8646-C42F1D1D441E@.microsoft.com...
> >I have a report that shows/hides group detail with the + for expanding the
> > group. When the report first displays the detail is hidden (as it should
> > be)
> > with the + showing. However ... the cursor will only change to a finger
> > (pointer ... whatever) when the cursor is placed to the left of the +
> > sign.
> > The user will want to expand the detail by selecting on the + sign and
> > they
> > cant. Why is this?
> > Example:
> >
> > + Client A
> > ^ -- user must click to the left of the plus sign on Client A to expand
> > group
> >
> >
>
>