Showing posts with label tia. Show all posts
Showing posts with label tia. Show all posts

Wednesday, March 28, 2012

Report designer client component?

I have seen reference to the above component - can anyone
please tell me what it is? Is it an optional part of
VS2003 installation?
TIA,
JBReport Designer is SQL Server 2000 Reporting Service's report authoring
tool. It is hosted within the Visual Studio 2003 .NET shell. This means that
you have to have some component (VB .NET satisfies this requirement) of VS
2003 .NET on your machine prior to install Report Designer
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JB" <anonymous@.discussions.microsoft.com> wrote in message
news:1fac401c45840$10d78ed0$a501280a@.phx.gbl...
> I have seen reference to the above component - can anyone
> please tell me what it is? Is it an optional part of
> VS2003 installation?
> TIA,
> JB

Wednesday, March 21, 2012

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