Report Description Overwrite Issue

When I deploy a report from MSDE, the description from within the report
properties is displayed under the report name/link within the Report Manager.
When I modify the report description in MSDE and then re-deploy the report
it doesn't update the one I see in Report Manager? I can delete the report
in Report Manager and then redeploying creates the modified description; but
I don't really want to have to delete reports everytime I modify the
description.
Is this is a bug?MSDE is not a supported platform for Report Server. You must use either the
Standard edition or the Enterprise edition. You can also use the Developer
edition, but it is licensed for developing or testing only.
Charles Kangai, MCT, MCDBA
"Simon" wrote:
> When I deploy a report from MSDE, the description from within the report
> properties is displayed under the report name/link within the Report Manager.
>
> When I modify the report description in MSDE and then re-deploy the report
> it doesn't update the one I see in Report Manager? I can delete the report
> in Report Manager and then redeploying creates the modified description; but
> I don't really want to have to delete reports everytime I modify the
> description.
> Is this is a bug?

Report Definition

Is it possible to control the number of table rows that can be displayed by modifying the report definition?Not sure if this is what you mean, but you can control the # of rows displayed by limiting the # of rows fetched from the data source. There's no way AFAIK to fetch N rows but only display N-M rows.|||

>> There's no way AFAIK to fetch N rows but only display N-M rows.

Yes, actually there is <s>.

You do need to give yourself appropriate information from the data source, but this doesn't necessarily mean limiting the rows! (because you might have another data region that shows a different count, in the same report, from the same data).

Here's a reporting query from my favorite ASP.NET add-on table (ELMAH error handler):

Code Snippet

SELECT ErrorId, Application, Host, Type, Source, Message,
[User], StatusCode, TimeUtc,

Sequence, AllXml

FROM ELMAH_Error ORDER BY ErrorId

... now suppose we add a column, as follows:

Code Snippet

SELECT ErrorId, Application, Host, Type, Source, Message,

[User], StatusCode, TimeUtc,

Sequence, AllXml, Row_Number() OVER (ORDER BY ErrorID) AS ItemID
FROM ELMAH_Error ORDER BY ErrorId

(you can add a counter like this different ways in other data sources)

... Now we can add the following filter to a table (or whatever):

Code Snippet

=Fields!ItemID.Value <= 8 ' or whatever maximum you have in mind,

' for example you can say:

=Fields!ItemID.Value <= =Parameters!MyMax.Value

... and readers please note, if you have trouble when you follow these instructions:

When I built this example I had to CInt() (cast) on both sides of the filter expression (including the literal 8!) to get it to work the first couple of times. It may be because I was building the query interactively for the dataset, and the designer doesn't support this clause so, while it processes the SQL, it is not sure about the data type of the result. IAC it does work.

>L<

|||Thanks for your help.

Report Builder top x% clause

How to set up report (chart or table) with:
- top X
or
- top x%
clause to limit number of records displayed?
Is it possible?
Any ideas?
TIA,
KamelThis can be done by using the 'Top N' or 'Top %' in the filter tab for
the chart or table, where you set the expression, then select 'Top N'
ot 'Top %'as the Operator, followed by the actual number or pct.
Matt A|||I have following operators in filter definition:
- Is Empty
- Equals
- In a list
- Greater Than
...etc
But there are no Top N and Top % operators.
Whats wrong?
Kamel|||Can someone help with this?|||Put your "top 10 percent" clause into your query\stored procedure that feeds
the report...
"kamel" wrote:
> Can someone help with this?
>|||I am usinging report builder with report model.
Is it possible and how to use TOP N with report builder and report
model?
Kamel|||Ah right, sorry I havnt worked with the report model and report builder yet
so cant answer your question.
"kamel" wrote:
> I am usinging report builder with report model.
> Is it possible and how to use TOP N with report builder and report
> model?
> Kamel
>|||Matt,
are you sure this is possible?
I can not find TOP N operator in a filter :(
Kamel|||Has someone managed to do that with report builder?sql

Report Builder filter dropdown list issues

How can I create a report in Report Builder with a date-type parameter that displays a dropdown list of month names displayed in the correct chronological order (i.e. January, February, etc.)? More generally, how does one sort filter values in the dropdown list?

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.

Thanks!

Paul.

Paul Rayner wrote:

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.
Thanks!
Paul.

Names will appear in dropdown if ValueSelection property of attribute Transaction is set to "Dropdown".

|||

Thanks for the reply. Perhaps I was insufficiently clear. I know how to get a dropdown list. What I don't know how to do is how to sort the date values (when displayed as month names) in a dropdown list. Month names are being displayed as April, August, etc. instead of January, February, etc.

Paul.

Report Builder button doesn't appear....

Hi,
I have the latest CTP installed. Users do not see the report builder button.
Only members of the local admin group seem to have it displayed. Can anyone
steer me in the right direction'
AllanI have run into a similar problem on my machine. The Report Builder button
never appears in my report manager home page.
I'm using Windows 2000 workstation with SQL Server 2005 (September)
Jay
"Allan" wrote:
> Hi,
> I have the latest CTP installed. Users do not see the report builder button.
> Only members of the local admin group seem to have it displayed. Can anyone
> steer me in the right direction'
> Allan|||I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
further but still have the same problem.....
"Jay" wrote:
> I have run into a similar problem on my machine. The Report Builder button
> never appears in my report manager home page.
> I'm using Windows 2000 workstation with SQL Server 2005 (September)
> Jay
> "Allan" wrote:
> > Hi,
> > I have the latest CTP installed. Users do not see the report builder button.
> > Only members of the local admin group seem to have it displayed. Can anyone
> > steer me in the right direction'
> >
> > Allan|||I've downloaded the MSDN RTM version and installed, but I have the same
problem. I have ensured that the users are in the Reporting services Content
Manager security group (and indeed every other group) but with no joy. Only
members of Windows Domain Admins group can see the button.
I guess I must be missing something ... ?
"Allan" wrote:
> I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> further but still have the same problem.....
> "Jay" wrote:
> > I have run into a similar problem on my machine. The Report Builder button
> > never appears in my report manager home page.
> >
> > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> >
> > Jay
> >
> > "Allan" wrote:
> >
> > > Hi,
> > > I have the latest CTP installed. Users do not see the report builder button.
> > > Only members of the local admin group seem to have it displayed. Can anyone
> > > steer me in the right direction'
> > >
> > > Allan|||Make sure, that in site settings --> configure system level role definitions
--> System USer has "Execute report definitions" is checked. This is not
checked by default if you are upgrading to 05. If you are installing it brand
new, then it is checked by default.
"Furzehill Bill" wrote:
> I've downloaded the MSDN RTM version and installed, but I have the same
> problem. I have ensured that the users are in the Reporting services Content
> Manager security group (and indeed every other group) but with no joy. Only
> members of Windows Domain Admins group can see the button.
> I guess I must be missing something ... ?
>
> "Allan" wrote:
> > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > further but still have the same problem.....
> >
> > "Jay" wrote:
> >
> > > I have run into a similar problem on my machine. The Report Builder button
> > > never appears in my report manager home page.
> > >
> > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > >
> > > Jay
> > >
> > > "Allan" wrote:
> > >
> > > > Hi,
> > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > steer me in the right direction'
> > > >
> > > > Allan|||The solution provided by Nagini Indugula does not work (at least for all
cases).
Having the same issue, adding a user to the local admin group of the
SQLRS2K5 server has the Report Builder button appearing. Remove the user
from the local admin group, the button goes away.
Trying all other local groups for the user do not resolve the issue. Looking
also for a way to get this to work.
"Nagini Indugula" wrote:
> Make sure, that in site settings --> configure system level role definitions
> --> System USer has "Execute report definitions" is checked. This is not
> checked by default if you are upgrading to 05. If you are installing it brand
> new, then it is checked by default.
>
> "Furzehill Bill" wrote:
> > I've downloaded the MSDN RTM version and installed, but I have the same
> > problem. I have ensured that the users are in the Reporting services Content
> > Manager security group (and indeed every other group) but with no joy. Only
> > members of Windows Domain Admins group can see the button.
> >
> > I guess I must be missing something ... ?
> >
> >
> > "Allan" wrote:
> >
> > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > further but still have the same problem.....
> > >
> > > "Jay" wrote:
> > >
> > > > I have run into a similar problem on my machine. The Report Builder button
> > > > never appears in my report manager home page.
> > > >
> > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > >
> > > > Jay
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > Hi,
> > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > steer me in the right direction'
> > > > >
> > > > > Allan|||In digging some more, a post by Blackfish was the solution.
---
The solution is:
site settings -> Configure site-wide security -> New Role Assignment ->
add user to either 'System Admin' or 'System User'
Tim
---
"TL" wrote:
> The solution provided by Nagini Indugula does not work (at least for all
> cases).
> Having the same issue, adding a user to the local admin group of the
> SQLRS2K5 server has the Report Builder button appearing. Remove the user
> from the local admin group, the button goes away.
> Trying all other local groups for the user do not resolve the issue. Looking
> also for a way to get this to work.
>
> "Nagini Indugula" wrote:
> > Make sure, that in site settings --> configure system level role definitions
> > --> System USer has "Execute report definitions" is checked. This is not
> > checked by default if you are upgrading to 05. If you are installing it brand
> > new, then it is checked by default.
> >
> >
> >
> > "Furzehill Bill" wrote:
> >
> > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > problem. I have ensured that the users are in the Reporting services Content
> > > Manager security group (and indeed every other group) but with no joy. Only
> > > members of Windows Domain Admins group can see the button.
> > >
> > > I guess I must be missing something ... ?
> > >
> > >
> > > "Allan" wrote:
> > >
> > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > further but still have the same problem.....
> > > >
> > > > "Jay" wrote:
> > > >
> > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > never appears in my report manager home page.
> > > > >
> > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > >
> > > > > Jay
> > > > >
> > > > > "Allan" wrote:
> > > > >
> > > > > > Hi,
> > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > steer me in the right direction'
> > > > > >
> > > > > > Allan|||Hi - I'm glad you found the answer but I'm confused... why should we have to
do this versus just assigning the user to the report builder role under item
level security?
"TL" wrote:
> In digging some more, a post by Blackfish was the solution.
> ---
> The solution is:
> site settings -> Configure site-wide security -> New Role Assignment ->
> add user to either 'System Admin' or 'System User'
> Tim
> ---
> "TL" wrote:
> > The solution provided by Nagini Indugula does not work (at least for all
> > cases).
> >
> > Having the same issue, adding a user to the local admin group of the
> > SQLRS2K5 server has the Report Builder button appearing. Remove the user
> > from the local admin group, the button goes away.
> >
> > Trying all other local groups for the user do not resolve the issue. Looking
> > also for a way to get this to work.
> >
> >
> >
> > "Nagini Indugula" wrote:
> >
> > > Make sure, that in site settings --> configure system level role definitions
> > > --> System USer has "Execute report definitions" is checked. This is not
> > > checked by default if you are upgrading to 05. If you are installing it brand
> > > new, then it is checked by default.
> > >
> > >
> > >
> > > "Furzehill Bill" wrote:
> > >
> > > > I've downloaded the MSDN RTM version and installed, but I have the same
> > > > problem. I have ensured that the users are in the Reporting services Content
> > > > Manager security group (and indeed every other group) but with no joy. Only
> > > > members of Windows Domain Admins group can see the button.
> > > >
> > > > I guess I must be missing something ... ?
> > > >
> > > >
> > > > "Allan" wrote:
> > > >
> > > > > I'm on WIN 2003 and SQL 2005 Sept. I haven't had a chance to investigate
> > > > > further but still have the same problem.....
> > > > >
> > > > > "Jay" wrote:
> > > > >
> > > > > > I have run into a similar problem on my machine. The Report Builder button
> > > > > > never appears in my report manager home page.
> > > > > >
> > > > > > I'm using Windows 2000 workstation with SQL Server 2005 (September)
> > > > > >
> > > > > > Jay
> > > > > >
> > > > > > "Allan" wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > > I have the latest CTP installed. Users do not see the report builder button.
> > > > > > > Only members of the local admin group seem to have it displayed. Can anyone
> > > > > > > steer me in the right direction'
> > > > > > >
> > > > > > > Allan

report builder aggregates

Is there anyway to control which aggregates are displayed in Report Builder? Failing that can I turn them off by table or all together.

Thanks.

You have a couple of different options.

1. Turn them off when autogenerating. There are two checkboxes; one for autogenerating count aggregates and one for date aggregates.

2. Delete the ones you know you don't want. I tend to do this with numeric columns that I know are keys or IDs.

3. By default, the Total aggregate is the displayed value in the model. You can disable this behavior in properties of the column, "DefaultAggregateAttribute". Make in "(none)". I spend alot of time making sure my entities are in alpha order so that they are easier to find. This cleans up the look of the final model.

4. Hide the aggregate. I find this one the most useful. You never know when you may be asked to make it re-appear.

R

|||Thanks!

Quick questions. On which screen are these checkboxes, I haven't seen them. Also where would you hide an aggregate?|||

When you run the Autogenerate wizard, the third screen in has mulitple checkboxes for what you want to generate. If you are like me, you just "Next->" on through them. There are some nice options in there.

The hidden property is available on every item in the model. Show the properties window, select the item(s) you want to hide and change the "Hidden" property from False to True.

R

Report - Limit rows in table per page

I have a report that is a master-detail style report. The detail is displayed in a table. I would like to be able to limit the number of rows that can be in that table, and if there are more rows, it goes to the next page.

The report is essentially invoices. The master part has the name address, etc... and the detail is the line item detail. But with the format i am using, i can only fit x amount of line items per page (Depends on the size font i have). So, lets say i can only fit 10 items on a page. If there is an invoice with 12 items, i would like it to print 10 on the first page, and the last 2 on the second page. Everything else can be identical (doesn't really matter though). Is this possible?

Thanks

Hi bortiquai

you didn't mentioned which control you are using?

if you are using gridview than you can simple set the property

pagesize="10" or whatever you want

hope it helps

|||

I'm using the Table object in the Report Designer (RDLC), and the ReportViewer Control to view the report on the page. The pagesize=10 property on the GridView control is pretty much what I'm looking for, but the Table object in the report viewer does not have this property.

|||

This article will help you.

http://msdn2.microsoft.com/en-us/library/ms251668(VS.80).aspx

Look for "Page Breaks" section. This "=Int((RowNumber(Nothing)-1)/25)" expression will limit the number of rows displayed to 25 per page but you have to set it in the report. If you want your users to decide the number of pages, you just need to pass a parameter to the report that will contain the value. If you need help with that, let me know.

good luck...