Report Parameters

I have a report with a parameter set up for Account name. When I use
the drop down I do display the 5 accounts associated with the 5 rows
data. (One shows in the parameter drop down 3 times because it has
data for 3 different rows.)
Account 1
Account 1
Account 1
Account 2
Account 3
My question is, what else do I need to make the parameter at the top
work, currently my report is not filtering the data by Account. I
still see all 5 rows of data. Do I need a report filter as well?On Oct 1, 10:25 am, BLAW <brad...@.gmail.com> wrote:
> I have a report with a parameter set up for Account name. When I use
> the drop down I do display the 5 accounts associated with the 5 rows
> data. (One shows in the parameter drop down 3 times because it has
> data for 3 different rows.)
> Account 1
> Account 1
> Account 1
> Account 2
> Account 3
> My question is, what else do I need to make the parameter at the top
> work, currently my report is not filtering the data by Account. I
> still see all 5 rows of data. Do I need a report filter as well?
If I understand you correctly, you will want to set your dataset from
the Data tab to a variable. Something like:
select x, y, z, ... from table_x where AccountName = @.AccountName
Then in the Parameters tab (select via Edit Selected Dataset [...] ->
Parameters tab) set the variable @.AccountName (below Parameters:Name)
to Value: =Parameters!AccontName.Value
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

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 generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert

Report only generates 1 page output

I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?

Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?

Thanks,
Albert

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 not using pagination properly

I have a portrait report that has 1 table with 1 hidden group header (for the Page Header to reference fields from) and 36 detail rows. My problem is that pagination is not working properly. Depending on the length of data in the detail rows, the report tends to push majority of data on the next page(s) which leaves a lot of blank lines or blank page at the beginning of each group of data. I want the data to complete the first page before rolling over to the next page. That's why I have 36 individual detail rows instead of all the data in 1 detail row. I've tried adjusting the page length, but it doesn't seem to work all that well. I either get all the report on one page (which is fine when viewing online, but data is cut off when printing) or inadequate pagination. I do not have any white space at the bottom of the table and the page footer. Anyone have any ideas?

Thanks,

T

Have you tried setting KeepTogether=false on your table? The behavior your describing sounds like it's set to true, which would mean that if the table can't fit completely on the current page, but will fit on the next page, it will move the table to the next page.

You shouldn't need to specify the detail rows individually if you're populating from a data source!|||Yes, KeepTogether is false and yes I am using a shared data source and data is queried using Stored Procedure.|||Well it seems the problem lies within the Group Header row. I removed that row and pagination works properly now, but I lose the ability to call fields in my page header when the report spans more than one page.|||

Ok, I found a solution for showing Field values in Page Header even when the report spans more than one page(but you don't know at what point the report spans to the next page). It's a combination of several solutions:

1) Create hidden textbox(es) with the field value you're wanting on every line where the page might span to the next page.

textbox1

textbox2

textbox3

2) Create a function in code that will reference each hidden textbox(es) by name

Shared Function Header(reportItems as ReportItems) as string
Dim final as string
If ReportItems!textbox1.value <> "" Then
final = ReportItems!textbox1.value
Else If ReportItems!textbox2.value <> "" Then
final = ReportItems!textbox2.value
Else If ReportItems!textbox3.value <> "" Then
final = ReportItems!textbox3.value
End If
Return final
End Function

3) In Page Header call function, pass (ReportItems)

=Code.Header(ReportItems)

The reason for the function is because you can't reference multiple ReportItems in Page Header textbox, so you have to determine which hidden textbox has a value on that page and return that value to the calling Header textbox. Hope this helps....

sql

report not showing information in rows

Hello,
I have several reports that work fine other then when the values for a
column is the same as the one below it the the value dose not show up? Is
this something I can turn off?
For example I have a column that might have several rows of 0 but only one 0
will there and then blank rows till the next value.Hi John,
It sounds like the rows have the property "Hide Duplicates" assigned to the
column or field that is repeating the value. You can toggle this attribute
in the property dialogue of the field in question.
Rodney Landrum
Author - Pro SQL Reporting Services (Apress)
"John" <John@.discussions.microsoft.com> wrote in message
news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> Hello,
> I have several reports that work fine other then when the values for a
> column is the same as the one below it the the value dose not show up? Is
> this something I can turn off?
> For example I have a column that might have several rows of 0 but only one
> 0
> will there and then blank rows till the next value.
>|||I create the report in code but that sound like it is my problem thanks
"Rodney" wrote:
> Hi John,
> It sounds like the rows have the property "Hide Duplicates" assigned to the
> column or field that is repeating the value. You can toggle this attribute
> in the property dialogue of the field in question.
> Rodney Landrum
> Author - Pro SQL Reporting Services (Apress)
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> > Hello,
> > I have several reports that work fine other then when the values for a
> > column is the same as the one below it the the value dose not show up? Is
> > this something I can turn off?
> > For example I have a column that might have several rows of 0 but only one
> > 0
> > will there and then blank rows till the next value.
> >
>
>

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 Headers showing on blank page

I hope someone will have time to answer a really basic RS question.

I have a simple report, the query will only return a few rows (16 - 20), my header is repeating on a 2nd blank page. I'm sure it's because I grouped on a column from the record set. I can not find where you delete the grouping.

Anyone have any good suggestions on RS books?

Thanks

Hey Marc,

There are a couple of places to check:

When you click on the table, are there rows that have little numbers on them (1,2, etc)? If so, you should be able to right-click on these and select Delete Groups.

Another place could be the Properties of the table (Select the table, right click on the Properties option). Select the Grouping tab. Delete any of the groups in there (usually named something like "details_group")

Good luck!

Jessica

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."

Report generation is consuming 100% of CPU client side.

Hi,

I have a problem while rendering a report which returns around 5000 rows. At first the server is busy to process the request, when the server is done the rendering client side takes 100% of CPU and never displays the result ("IE is not responding"). It seems that the ReportViewer has trouble to handle the server response.

Do you have any idea why ?

Sbastien.

It appeared that the problem is a paging issue. The report contains groups and by default the top level is collapsed, when we try to expand a level that contains many rows thoses rows are all displayed on a single page. That's why IE is consuming 100% of the CPU to display all the rows.

How can I change that the paging is working for the sub groups displayed ?

|||

I found the answer in BOL:

"The HTML and Excel rendering extensions are not oriented to physical pages. Furthermore, the HTML rendering extension is interactive, meaning that user actions in a report can trigger additional processing that causes a report to expand horizontally or vertically to accommodate additional content. You cannot precisely control how reports viewed through these rendering extensions will paginate if the report contains interactive features."

Report formatting - green-bar effect

I'm trying to apply the green-bar effect to the detail rows in my report but
the alternating colours are not being applied correctly. The report uses a
table with 3 nested groups defined. For discussion purposes I'll call them
Group A, B and C. Group A is the outermost group, Group B is nested within
Group A, and Group C is nested within Group B. My result set is correctly
displayed so that I end up with 12 rows in Group C. However if I check the
number of rows using the RowNumber function, it tells me there are 20 rows
being returned for Group C.
I looked at the result set in SQL Query Analyzer and discovered that there
are 20 rows, but of these only 12 are unique. So I see why the alternating
colours aren't working, but am not sure how to fix it. Any ideas?
Thanks
--
DawnDawn,
The solution below assumes that you don't have much traffic, concurrent
sessions will cause problems.
Regards,
Cem
Shared ColorState as Boolean = True
Shared Function AlternateColor() as Boolean
if ColorState then
ColorState = False
Return False
else
ColorState = True
Return True
end if
End Function
In the report use IIF(Code.AlternateColor(),"Red","Green")
"Dawn" <Dawn@.discussions.microsoft.com> wrote in message
news:CBF95E44-4B54-4B8A-AFB4-3EEAC0D5B3B5@.microsoft.com...
> I'm trying to apply the green-bar effect to the detail rows in my report
> but
> the alternating colours are not being applied correctly. The report uses a
> table with 3 nested groups defined. For discussion purposes I'll call them
> Group A, B and C. Group A is the outermost group, Group B is nested within
> Group A, and Group C is nested within Group B. My result set is correctly
> displayed so that I end up with 12 rows in Group C. However if I check the
> number of rows using the RowNumber function, it tells me there are 20 rows
> being returned for Group C.
> I looked at the result set in SQL Query Analyzer and discovered that there
> are 20 rows, but of these only 12 are unique. So I see why the alternating
> colours aren't working, but am not sure how to fix it. Any ideas?
> Thanks
> --
> Dawn|||Dawn,
Also take a look at this example, it helped me immensely when trying to
accomplish the same thing- it's how to create a Green Bar Matrix
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
Bill Youngman
Anexinet, Inc.
"Dawn" <Dawn@.discussions.microsoft.com> wrote in message
news:CBF95E44-4B54-4B8A-AFB4-3EEAC0D5B3B5@.microsoft.com...
> I'm trying to apply the green-bar effect to the detail rows in my report
but
> the alternating colours are not being applied correctly. The report uses a
> table with 3 nested groups defined. For discussion purposes I'll call them
> Group A, B and C. Group A is the outermost group, Group B is nested within
> Group A, and Group C is nested within Group B. My result set is correctly
> displayed so that I end up with 12 rows in Group C. However if I check the
> number of rows using the RowNumber function, it tells me there are 20 rows
> being returned for Group C.
> I looked at the result set in SQL Query Analyzer and discovered that there
> are 20 rows, but of these only 12 are unique. So I see why the alternating
> colours aren't working, but am not sure how to fix it. Any ideas?
> Thanks
> --
> Dawn

Report Formatting

Hi !
I have a simple question. I am using a Table in my report. I would like to
apply a different color to alternating rows in the table.
What is the correct or recommended way to do this?
Thank you,
YCreating a Green-Bar Report
To apply a green-bar effect (alternating colors every other row) to a table
in a report, use the following expression in the BackgroundColor property of
each text box in the detail row:
=iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White")
this was from books online.
"Yoshi" wrote:
> Hi !
> I have a simple question. I am using a Table in my report. I would like to
> apply a different color to alternating rows in the table.
> What is the correct or recommended way to do this?
> Thank you,
> Y
>
>

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.