Putting Data In Report Footer

Hi,
We have a field in our dataset which we want to appear in the footer
of each page in our report.
To do this, we have added a textbox to the body of the report and
reference this data in the footer using the following:
=ReportItems!site_code.Value
This works fine, except when the record overflows onto a second page.
When this happens, the value is printed as a blank on the second and
subsequent pages, until we come to print the next record.
Ideally, we'd like the value to be printed on each page of the report.
Does anyone know of a solution to this?No takers for this?
Seems like a limitation of the software.

Put first 10 rows in a table and then group by each 25 rows in ano

Hi.
I would like to put the first 10 rows in a table and not have a page break.
Then in another table (which will be shown on another page) I would like to
show the 25 next rows, add a page break, show the next 25 rows, etc.
I could solve this by
System.Math.Ceiling (RowNumber (Nothing)/10)
or
Add a filter with top N = 10.
The tables are identical and uses the same datasource.
When I set the group to System.Math.Ceiling (RowNumber (Nothing)/25)
on the last table nothing happens. All rows are shown. I thought I could
add a filter with bottom N = CountRows - 10 but CountRows don't work in
filters.
And if it did I probably would have problems with the grouping to add page
breaks.
I know there have been similar requests, but I haven't been able to find a
solution.
Bright ideas are appreciated.I think I'll just make two different datasources.
One with the first then rows and one with the rest,
then bind each table to its datasource.
"Knut" wrote:
> Hi.
> I would like to put the first 10 rows in a table and not have a page break.
> Then in another table (which will be shown on another page) I would like to
> show the 25 next rows, add a page break, show the next 25 rows, etc.
> I could solve this by
> System.Math.Ceiling (RowNumber (Nothing)/10)
> or
> Add a filter with top N = 10.
> The tables are identical and uses the same datasource.
> When I set the group to System.Math.Ceiling (RowNumber (Nothing)/25)
> on the last table nothing happens. All rows are shown. I thought I could
> add a filter with bottom N = CountRows - 10 but CountRows don't work in
> filters.
> And if it did I probably would have problems with the grouping to add page
> breaks.
> I know there have been similar requests, but I haven't been able to find a
> solution.
> Bright ideas are appreciated.

pulling single lines from a DB

hi im making a page where i want a single line at a time to be pulled from my MS Database, basically at the moment i have a list of questions, but the page is displaying all the questions from my database, i only want it to pull out 1 and then if the user clicks the true button then it goes to another page and displays another question?

Any ideas

Regards,

JoeHi Joe,

Are you want to retrieve any 1 question from DB randomly?
FYI:http://www.datawebcontrols.com/faqs/Data/ReturningDataInRandomOrder.shtml

Regards,

Published Reports -- URGENT

Hi
I am trying to supply input parameters to a report from an aspx page. I tried many methods , but none seem to be working.
Can anyone suggest how I can work with parameterized reports from code?
Moreover , Do I have to publish a report to be able to supply Report Parameters from the code?
Thanks
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.You always have to publish a report to the server before you can use it. Not
sure what you are trying to do.
Are you using URL Access or the SOAP API? Supplying paramters to each is
described in BOL.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uOaURsuZEHA.3112@.TK2MSFTNGP09.phx.gbl...
> Hi
> I am trying to supply input parameters to a report from an aspx page. I
> tried many methods , but none seem to be working.
> Can anyone suggest how I can work with parameterized reports from code?
> Moreover , Do I have to publish a report to be able to supply Report
> Parameters from the code?
> Thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.|||Hi
This is what i think.
1) in your .aspx page, you would have a hyperlink or something that links to the targeted report Eg:
<a href="http://links.10026.com/?link=http://localhost/Reportserver?/report1¶m1=123" >Go to report1</a>
2) In report1.rdl, you would have created a parameter called param1.
3) You definitely need to publish your report. You do this through the report manager: upload.
Chiara
"SqlJunkies User" wrote:
> Hi
> I am trying to supply input parameters to a report from an aspx page. I tried many methods , but none seem to be working.
> Can anyone suggest how I can work with parameterized reports from code?
> Moreover , Do I have to publish a report to be able to supply Report Parameters from the code?
> Thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
>