Parameter Display

I need to display parameter value on my report.This parameter is coming from web application.

Example:I am passing parameter Dealer Name from web application to Report.

How to display that Dealer Name on Report.

Drag a textbox control in the report.

go to edit expression for that textbox.

select parameter on ur left side, it displays all the parameters listed in ur report on the right hand side.(dealer name as u said for example). incase it is not used in query, u can create one parameter which also be listed in the right hand side.

double click the parameter you want to display in the text box.

sql

Paging using Web Services

We are developing a Web Application for which we have written a class to
render reports that consumes web services provided by Reporting Services.
We invoke "Render" method of web service for displaying report in aspx page.
Paging is achieved using "Section" config of HTMLDeviceInfo passed to render
method.
This approach is working fine for First Page, Previous Page and Next Page
buttons. However we are not able to implement code for Last Page Button
because we are unable to retrieve details regarding total number of pages
through code.
Documentation states that if a value greater than last page index is passed
to "Section" config then Web Service would render last page. This behavior is
causing our code to crash.
Any idea how to overcome this problem.
Thanks in advance.I've described my approach a few months ago.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/tree/browse_frm/thread/5a73412801f5ba54/f63ce6b85e448735?rnum=1&hl=en&q=%22Oleg+Yevteyev%22+pages&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fbrowse_frm%2Fthread%2F5a73412801f5ba54%2F41e4ed35916811eb%3Flnk%3Dst%26q%3D%22Oleg+Yevteyev%22+pages%26rnum%3D8%26hl%3Den%26#doc_ac075ac1383673e8
Hope that helps
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"PVV" <PVV@.discussions.microsoft.com> wrote in message
news:327535A8-2C87-4B38-A60D-223B95D8AFD2@.microsoft.com...
> We are developing a Web Application for which we have written a class to
> render reports that consumes web services provided by Reporting Services.
> We invoke "Render" method of web service for displaying report in aspx
> page.
> Paging is achieved using "Section" config of HTMLDeviceInfo passed to
> render
> method.
> This approach is working fine for First Page, Previous Page and Next Page
> buttons. However we are not able to implement code for Last Page Button
> because we are unable to retrieve details regarding total number of pages
> through code.
> Documentation states that if a value greater than last page index is
> passed
> to "Section" config then Web Service would render last page. This behavior
> is
> causing our code to crash.
> Any idea how to overcome this problem.
> Thanks in advance.
>

Paging using Web Service

To get the UI we required, we built a custom .NET front end that
communicates directly with the MSRS web service. Paging (e.g. a break in the
data at a certain point with some indicator for the "next" page) does not
seem to work once you take this approach. Anyone figured this out?Hi Sean,
> To get the UI we required, we built a custom .NET front end that
> communicates directly with the MSRS web service. Paging (e.g. a break in the
[...]
>does not seem to work once
What doesn't work?
I used the same approch. My user control calls RS webservice with parameter "Section" of device settings so I can _read_ report section by section.
There is only a little problem... there is no way... perhaps is better to say I don't find any way to known How many sections I must paging :o
HTH M.rkino
--
Marco Barzaghi - [MVP - MCP]
http://mvp.support.microsoft.com - http://italy.mvps.org
UGIDotNet - User Group Italiano .NET, http://www.ugidotnet.org
Read my WebLog: http://www.ugidotnet.org/436.blog

Paging Reports

Hi All

I created a report with a matrix on the form and managed to get the results "not" to page when viewed on the web by selecting the "Fit matrix to one page if possible" checkbox.

I created a new report looking at the same data this time using a table and no matter what i do the report keeps paging!!!

Anyone got any advice on how to stop this? Why does it handle a table differently than a table.

Thanks very much

KeepTogether is not currently supported in interactive renderers (HTML and preview). You can try changing the InteractiveHeight property on the report to 0 in order to get the entire report on one page.|||

Setting the Interactive Height to 0in did the trick

aka

<InteractiveHeight>0in</InteractiveHeight>

Cheers

Paging large result sets

I use SqlServer on my web app written in Java. I have went through quite a big effort in trying to realize a flexible paging algorithm that I can include in my set of libraries. However having to deal with too many unknows like do I want the RS ascending/descending, what is the first/last itemid, next/previous page (and then invert logic what is up what is down) I'm quickly going mand. I realise there is a fine line where this is a tsql problem (like, do I use TOP x or not, how do I create all varying parameters on which I'd like to filter on etc.) and architecting java code with DAO's and a matter of how to put all of this together, so in order to avoid this, can you suggest how should a general SQL query be to allow this kind of behaviour? I know that stored procedures did not allow TOP $var in SqlServer2k is this still the case? Should SQL allow for constructs that would allow easy paging?Hello!

Yes, paging is a missed feature in SQL Server and it is still missed with version 2005. I do not understand why MS does not work on a construct to allow querying a sliced result. although, there is a known possibility for efficient server side paging, working with some millions of records, if adequate indexes are existent. This solution is based on nested "select top x" statements. You can find a good description at ....

http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx
But i prefer my one extended version which additionally is based on a primary key, which allways allows me to find the exact next or previous record.

Regards,
Tom|||Hi,
I like this stored procedure, although there can be infinite solutions to this problem I've marked it as a correct answer. It even addresses the problem that you can't pass the TOP x where x is a parameter of the procedure. Even the comments are insightfull.
Good work ;)

PS. I somehow wonder if the Command and Builder pattern might be used as well on the server side. Any ideas or links?|||

There are lot of problems with the stored procedure from the link above. Here are some of the issues:

1. It doesn't protect you from SQL injection attack
2. Use of EXEC instead of sp_executesql. The later can produce cacheable plans for the dynamic SQL statement
3. SP returns multiple resultsets which requires more work from client-side to handle. It is best to avoid it unless necessary

Having said this, the stored procedure does demonstrate one technique to page resultsets in SQL Server 2000. And if you incorporate such technique, please make sure to protect against the problems mentioned above.

You may also want to consider avoiding paging of resultsets in the GUI. You can provide like a search and locate type of functionality which will result in less number of rows being pulled from the server to client. This might also provide a better user experience than going through 100 rows at a time to find the one of interest. These type of paging techniques typically produce more load on the server since you are processing more rows in every query to locate the ones of interest. In any case, if you still have a requirement to do paging of the resultset then a dynamic query using TOP is the best way to go in SQL Server 2000.

In SQL Server 2005, you can also use the ROW_NUMBER() function to do this slightly more efficiently. ROW_NUMBER function allows you to generate a sequential number for the each row in a resultset and you can apply filters on it to perform the paging. We are working on a white paper that will compare the various paging techniques that should appear in the Microsoft SQL Server and MSDN web sites.

Paging (Performance)

Hello, I have incorporated a paging query in my software. I got the query from here:

http://rosca.net/writing/articles/serverside_paging.asp

My web software ususlly responded in .005 - .02 seconds with about a 100 rows of data. When I put simulated data on my database I added about 2 million rows. when I did this -- every page that did not execute the paging query responded lightning fast. But the webpages that executed the paging query took over 5 seconds. I dont understand why this paging query brought my web application to its knees.

Does anyone know of a more efficient way to do paging. I have SQL server 2000. If it may be easier I can upgrade to SQL 2005. PLZ Let me know. Thankshave a look at these two blog posts (focus on the more recent post):

http://weblogs.sqlteam.com/jeffs/category/162.aspx

theres a lot of info in the blog comments as well, and also links to other methods (for example, http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html)

Paging

I'm looking for an efficient generic T-SQL paging
technique
that would be able to give me a page result under
different sorting
I done a lot of web searching but didn't find any
tnxPlease dont MULTI-Post... I've already answered this in the other
group and dont wish to answer it a 2nd time.
if more than one group is relevent (as in this case) then CROSS-post
your questions then when someone replies it will automatically cross
post the replie.
to cross post put ALL the names of the groups in the to field
seperated by a semi colon (depending on browser app)
hth.
Al.
On Tue, 13 Jan 2004 10:12:11 -0800, "Bnaya Eshet"
<bnaya_eshet@.splsoftware.com> wrote:

quote:

---

>I'm looking for an efficient generic T-SQL paging
>technique
>that would be able to give me a page result under
>different sorting
>I done a lot of web searching but didn't find any
>tnx

---

Pagination without datagrid

I'm working on a website where we're using .Net web services to feed data to a Flash front-end. The site will have a comments section and we want to display 15 or so comments per page with 'back' and 'next' functionalitiy. We'd also like to show the number of pages of comments and highlight the page they're on. The standard stuff that datagrids do so well.

How can this be accomplished without a datagrid?

There's a good page that explains a number of ways to do this using classic ASP. Some of the solutions they implement I can most likely use with .Net.

http://www.aspfaq.com/show.asp?id=2120

But I wanted to ask the community. How to paginate without a recordset? Sql Server 2000 back-end, ASP.NET 1.x

Thanks.Why don't you want to use a datagrid?|||We aren't using a DataGrid because our 'front-end' isn't an aspx page it's a Flash application that we're feeding the data to via a webservice.

Correct me if I'm wrong but I don't think a DataGrid is an option with this situation.|||

I see. Sorry, I missed that part. Well, if you are using web services to a flash front end, I would assume that your data isn't going to change very often. I would see about getting your data into a dataset, formatting the output into a cache object with a sqldependancy.

Beyond that, I would have to know a lot more about how your web service interacts with your flash front end.

Pagination for Large data

I want to build a system that will have about 1 million rows in a
table in sql server database.I am using this for a web application and
accessing it via JDBC type 4 driver.But display 20 records at a time
only using pagination(as in google).What will be the best way to go
about this.On 10 Oct 2003 04:04:11 -0700, nik_sharma75@.hotmail.com (Nikhil
Sharma) wrote:

>I want to build a system that will have about 1 million rows in a
>table in sql server database.I am using this for a web application and
>accessing it via JDBC type 4 driver.But display 20 records at a time
>only using pagination(as in google).What will be the best way to go
>about this.

Figure how many anyone is actually ever going to page through.
Obviously no one is going to page through to the end. How many google
pages would you look at before refining your search? Then construct
your query and restrict it with TOP. Cache the results and handle the
paging in your app.

Page Width and or Margin problems using the new print from web

When I print directly from the web (report manager) I get an extra page for
each report page. The behavior is similar to what you'd get if you had the
page width and margins adjusted incorrectly. However, the reports export to
PDF correctly and print from within VS correctly in the print preview. Is
there a known issue with the new print from web functionality?
I have the page size set to 8.5" by 11" and all margins set to .25". The
body size is set to 8" (so that if you add .5" worth of margin to get 8.5"
overall)
Any ideas?We're experiencing the same problem too, with reports displaying an extra
page, or data appearing on next page, when using client-side printing.
We've found that the default margins (using the client-side print button) is
.500 on all sides (left, right, top & bottom). We have to change the
margins each time, before printing the report, which is too much hassle.
Is there any way to change the default margins of the client-side printing
control?
TIA.
Marlon
"john" <john@.discussions.microsoft.com> wrote in message
news:99A04411-1EF1-49C8-BBBD-E6869DC552B1@.microsoft.com...
> When I print directly from the web (report manager) I get an extra page
> for
> each report page. The behavior is similar to what you'd get if you had
> the
> page width and margins adjusted incorrectly. However, the reports export
> to
> PDF correctly and print from within VS correctly in the print preview. Is
> there a known issue with the new print from web functionality?
> I have the page size set to 8.5" by 11" and all margins set to .25". The
> body size is set to 8" (so that if you add .5" worth of margin to get 8.5"
> overall)
> Any ideas?