Report Paging

We are converting from Crystal Reports to Reporting Services. We are
encountering what appears to be an issue with the Report Viewer. If Table
rows in the body of the report are conditionally made Hidden (depending on
parameter input), the number of pages differs between the viewer and the
printed (either printer or pdf). In fact, some reports show a single page in
the viewer, but many pages when printed or exported to pdf. If the Table rows
are always visible, the pagination is consistent between viewer and printing.
Is there any way to work around this?Hello HK,
I would like to know the following things:
1. What's the SQL server version did you use? 2000 or 2005?
2. Since this issue only occured for the conditional Hidden, it is a known
issue in SQL 2005. And the product team is researching this issue. If I get
any update, I will let you know.
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.|||Thank you for your response.
We are using sql server 2005 sp2, visual studio 2005.
It appears to be occuring only with the conditional Hidden. If I remove the
conditional Hidden, we appear to get correct pagination. I (and our many
report users) would greatly appreciate any solution to this.
"Wei Lu [MSFT]" wrote:
> Hello HK,
> I would like to know the following things:
> 1. What's the SQL server version did you use? 2000 or 2005?
> 2. Since this issue only occured for the conditional Hidden, it is a known
> issue in SQL 2005. And the product team is researching this issue. If I get
> any update, I will let you know.
> 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 HK,
Product Team confirmed this is a known issue and will be addressed in the
next version of Reporting Services.
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.|||I'm glad to hear that - thanks for your response.
"Wei Lu [MSFT]" wrote:
> Hello HK,
> Product Team confirmed this is a known issue and will be addressed in the
> next version of Reporting Services.
> 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 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