Report Builder, Stored Procedures and Views

How can I access recordsets from Stored Procedures and/or views instead of
tables from the database. I need to limit the amount of data a user can
access but the only entities showing up in the Explorer are tables.Hi,
You can access from tables and views, what ever filter criteria you can give
it in views. Go to "Data Source Views" in the Report model project and click
on add existing items from your datasource you should see tables and views.
Amarnath
"SYoung" wrote:
> How can I access recordsets from Stored Procedures and/or views instead of
> tables from the database. I need to limit the amount of data a user can
> access but the only entities showing up in the Explorer are tables.|||You're talking about a Report Project in VS. What I'm talking about is an
add on client development tool accessible via the
http://YourReportServer/Reports page called "Report Builder". This tool
allowes the user to create adhoc reports without having to write 1 line of
SQL.
"Amarnath" wrote:
> Hi,
> You can access from tables and views, what ever filter criteria you can give
> it in views. Go to "Data Source Views" in the Report model project and click
> on add existing items from your datasource you should see tables and views.
> Amarnath
>
> "SYoung" wrote:
> > How can I access recordsets from Stored Procedures and/or views instead of
> > tables from the database. I need to limit the amount of data a user can
> > access but the only entities showing up in the Explorer are tables.

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 - 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...