reporting services table formatting

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.
Anybody know how to do this?
*** Sent via Developersdex http://www.examnotes.net ***You can set the property RepeatOnNewPage property of the header to True in
order to get table headers on each page. It is False by default.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:uLW3bBMeGHA.3388@.TK2MSFTNGP05.phx.gbl...
> When you have a table that continues onto another page, how do you get
> the table headers to show on the 2nd page? I just get a continuation of
> the table with no headers on subsequent pages.
> Anybody know how to do this?
>
> *** Sent via Developersdex http://www.examnotes.net ***

reporting services table formatting

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.

Anybody know how to do this?

Are you using Reporting Services 2005?

If so... Select the table and right click to get the pop-up menu. Select properties and on the first tab (General) there is a checkbox "Repeat header rows on each page"

mike72:

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.

Anybody know how to do this?

Reporting Services Report Manager Authentication Issue

Hi,

I have installed Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.

Is there any way to disable this windows authentication dialouge box?

Regards,

PS: in the viewer i give the path of the report as http://localhost/Rerport/ABC.rdlThis forum is on .Net Framework (CLR) integration in SQL Server 2005 that allows you to write routines in CLR languages like c#, VB.NET etc.
I suggest posting your question in SQL Server Reporting Services forum to get a faster response.

Thanks,
-Vineet.

Reporting services question

Hi,
I created aspx page with reprotviewer. Report runs fine and I exported it to excel. (Windows 2000 Professional and MS Office 2002). When I try to open report with excel it gives me "Problem during load" message box with message: "Missing file: c:\styleshe
et.css". When I opened excel file with notepad, I found following line "<link rel=3DStylesheet href=3D"file:///c:\stylesheet.css">". I removed line and when I opened excel file again, file opened without message box.
What should I do to make sure that line mentioned above doesn't appear in file in the first place?
Thanks,
Vcitor
I have to assume that the stylesheet link is being placed in there from =
your aspx page or the report viewer. Can you see any way to not use =
this stylesheet (or any other style sheet for that matter)?
On a side note, I would be interested in seeing the code. I am =
beginning to use Reporting Services and it would be interesting to see =
how you were able to render reports within the web pages using the =
report viewer. Are you willing to post your code here or to a location =
like http://www.gotdotnet.com/ ?
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:84995B62-2670-47E8-B563-9904A0C466DE@.microsoft.com...
> Hi,
>=20
> I created aspx page with reprotviewer. Report runs fine and I exported =
it to excel. (Windows 2000 Professional and MS Office 2002). When I try =
to open report with excel it gives me "Problem during load" message box =
with message: "Missing file: c:\stylesheet.css". When I opened excel =
file with notepad, I found following line "<link rel=3D3DStylesheet =
href=3D3D"file:///c:\stylesheet.css">". I removed line and when I opened =
excel file again, file opened without message box.
> What should I do to make sure that line mentioned above doesn't appear =
in file in the first place?
>=20
> Thanks,
> Vcitor
|||I exported again to excel format and its working fine now. Reporting services have some issues which hopefully will be resolved in Service Pack 1.
Following is C# code which executed in code behind on button click:
protected Microsoft.Samples.ReportingServices.ReportViewer reprotViewer;
private void btnView_Click(object sender, System.EventArgs e){
string _dateFormat = "yyyy-MM-dd";
string _zeroTime = "+00%3a00%3a00";
string _fromDate = Convert.ToDateTime(lblFromDatetxt.Text).ToString(_ dateFormat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).T oString(_dateFormat) + _zeroTime;
string _reportName = "";
string _merchant = "";
reprotViewer.Visible = true;
if(ddlCIMSreports.SelectedItem.Text == "Summary"){
_reportName = "SalesSummary";
}
else{
_reportName = "SalesByMerchantDetail";
//Following assigns Vendor from dropdown list box
_merchant = "&vendor=" + ddlVendor.SelectedItem.Text.Replace(" ", "+");
}
reprotViewer.ServerUrl = "http://localhost/ReportServer";
//Following assigns report name and 3 parameters expected by report
reprotViewer.ReportPath = "%2MerchantSales%2f" + _reportName + _merchant + "&dateFrom=" + _fromDate + "&dateTo=" +_toDate;
}
I hope its helpfull.
Victor
|||Nice article:
http://odetocode.com/Articles/128.aspx
|||good info. thanks
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:9FF0148B-33D9-4FAB-933D-1FC357A0E774@.microsoft.com...
> Nice article:
>=20
> http://odetocode.com/Articles/128.aspx

Reporting services question

Hi,
I created aspx page with reprotviewer. Report runs fine and I exported it to
excel. (Windows 2000 Professional and MS Office 2002). When I try to open r
eport with excel it gives me "Problem during load" message box with message:
"Missing file: c:\styleshe
et.css". When I opened excel file with notepad, I found following line "<lin
k rel=3DStylesheet href=3D"file:///c:\stylesheet.css">". I removed line and
when I opened excel file again, file opened without message box.
What should I do to make sure that line mentioned above doesn't appear in fi
le in the first place?
Thanks,
VcitorI have to assume that the stylesheet link is being placed in there from =
your aspx page or the report viewer. Can you see any way to not use =
this stylesheet (or any other style sheet for that matter)?
On a side note, I would be interested in seeing the code. I am =
beginning to use Reporting Services and it would be interesting to see =
how you were able to render reports within the web pages using the =
report viewer. Are you willing to post your code here or to a location =
like http://www.gotdotnet.com/ ?
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:84995B62-2670-47E8-B563-9904A0C466DE@.microsoft.com...
> Hi,
>=20
> I created aspx page with reprotviewer. Report runs fine and I exported =
it to excel. (Windows 2000 Professional and MS Office 2002). When I try =
to open report with excel it gives me "Problem during load" message box =
with message: "Missing file: c:\stylesheet.css". When I opened excel =
file with notepad, I found following line "<link rel=3D3DStylesheet =
href=3D3D"file:///c:\stylesheet.css">". I removed line and when I opened =
excel file again, file opened without message box.
> What should I do to make sure that line mentioned above doesn't appear =
in file in the first place?
>=20
> Thanks,
> Vcitor|||I exported again to excel format and its working fine now. Reporting service
s have some issues which hopefully will be resolved in Service Pack 1.
Following is C# code which executed in code behind on button click:
protected Microsoft.Samples.ReportingServices.ReportViewer reprotViewer;
private void btnView_Click(object sender, System.EventArgs e){
string _dateFormat = "yyyy-MM-dd";
string _zeroTime = "+00%3a00%3a00";
string _fromDate = Convert.ToDateTime(lblFromDatetxt.Text).ToString(_dateFor
mat) + _zeroTime;
string _toDate = Convert.ToDateTime(lblToDatetxt.Text).AddDays(1).ToString(_
dateFormat) + _zeroTime;
string _reportName = "";
string _merchant = "";
reprotViewer.Visible = true;
if(ddlCIMSreports.SelectedItem.Text == "Summary"){
_reportName = "SalesSummary";
}
else{
_reportName = "SalesByMerchantDetail";
//Following assigns Vendor from dropdown list box
_merchant = "&vendor=" + ddlVendor.SelectedItem.Text.Replace(" ", "+");
}
reprotViewer.ServerUrl = "http://localhost/ReportServer";
//Following assigns report name and 3 parameters expected by report
reprotViewer.ReportPath = "%2MerchantSales%2f" + _reportName + _merchant + "
&dateFrom=" + _fromDate + "&dateTo=" +_toDate;
}
I hope its helpfull.
Victor|||Nice article:
http://odetocode.com/Articles/128.aspx|||good info. thanks
--=20
Keith
"Victor" <anonymous@.discussions.microsoft.com> wrote in message =
news:9FF0148B-33D9-4FAB-933D-1FC357A0E774@.microsoft.com...
> Nice article:
>=20
> http://odetocode.com/Articles/128.aspx

Reporting Services Problem

I have a URL link to a report such as in a html page. Here is a typical example

<a href = "List">http://www.myserver.com/ReportServer?%2fCustomReports%2fOrganization>List of Managers</a>

This works great and renders the report

However after I return to the calling page and perform a POST such as

<form ACTION="http://www.myserver.com/Catch.asp" METHOD="post" name="frm1" id="frm1"
<INPUT id=Var1 name = Var1 type=hidden value="valuetopost">

The variables Var1 are never passed if I do this AFTER linking to the report. It always works if I do this BEFORE calling the report. I can only get this to work again by closing out the html page and starting again

Does anyone have any ideas what is wrong?You should try posting this to SQL Server Reporting Services forum.

Reporting services problem

Hi, I'm trying to use the reporting services in ASP.NET page.

- I've inserted an ReportViewer object my ASP.NET
- I've a datatable with the info that I want to see in my report

Now I must to create the DataSource object? How can I create a DataSource for this solution?? Somebody can send me an example?

Thanks

Please help me!!!|||Before that you need to create the report.
In fact the ReportViewer is just a container for the report.
In VS you need to do : right click on project / insert new item / Report.
Which version of SRS do you use ?|||

Sorry I didn't see the date of your post !!
I think it's too late to answer ;-)
and I think you were using VS2003...

reporting services print preview

Why whenever I create a report that is more than 1 page long, do I get a
blank page between every page of my report? In VS for example if I
create a 3 page report, I get a 6 page report and every other page is
blank on the print preview.
How do you prevent this?
Cheers,
Mike
*** Sent via Developersdex http://www.examnotes.net ***Check that your page margins are correct.
If you have overshot your page margins with a table or object then you will
get this.
Immy
"Mike P" <mike.parr@.gmail.com> wrote in message
news:eynAtgDeGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Why whenever I create a report that is more than 1 page long, do I get a
> blank page between every page of my report? In VS for example if I
> create a 3 page report, I get a 6 page report and every other page is
> blank on the print preview.
> How do you prevent this?
>
> Cheers,
> Mike
>
> *** Sent via Developersdex http://www.examnotes.net ***

Reporting Services Preferences

Is it possible to default Zoom to 'Whole Page' instead of 100% in Reporting
Services (not through a custom application). I understand that I can
manually do it each time I ran a report but I was wondering about some kind
of custom preferences setting.
Thank you.No, this is only possible if you are hosting URL access yourself.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"andrei" <andrei@.discussions.microsoft.com> wrote in message
news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> Is it possible to default Zoom to 'Whole Page' instead of 100% in
> Reporting
> Services (not through a custom application). I understand that I can
> manually do it each time I ran a report but I was wondering about some
> kind
> of custom preferences setting.
> Thank you.|||Thank you.
"Brian Welcker [MSFT]" wrote:
> No, this is only possible if you are hosting URL access yourself.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "andrei" <andrei@.discussions.microsoft.com> wrote in message
> news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> > Is it possible to default Zoom to 'Whole Page' instead of 100% in
> > Reporting
> > Services (not through a custom application). I understand that I can
> > manually do it each time I ran a report but I was wondering about some
> > kind
> > of custom preferences setting.
> > Thank you.
>
>|||Do you have any future plans to give more control over the page/menu setting?
Thank you.
"Brian Welcker [MSFT]" wrote:
> No, this is only possible if you are hosting URL access yourself.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "andrei" <andrei@.discussions.microsoft.com> wrote in message
> news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> > Is it possible to default Zoom to 'Whole Page' instead of 100% in
> > Reporting
> > Services (not through a custom application). I understand that I can
> > manually do it each time I ran a report but I was wondering about some
> > kind
> > of custom preferences setting.
> > Thank you.
>
>

Reporting Services performance

When I first go to the Report Manager, it takes a long time to load the web
page (15-30 seconds). After that it loads in a acceptable amount of time.
is there a way to configure it so that the page loads more quickly the first
time?
--
Message posted via http://www.sqlmonster.comI think what you will find is happening is that the Reporting Service
is "starting up" the first time you access it. We are having the same
problem and I am currently trying to find an answer. There is an
article on Microsoft's website talking about Anti-virus causing it to
restart frequently. But this doesn't seem to be that problem. The
server "stops" after a certain amount of inactivity and then takes a
while to start up when it's next accessed.
I'll post here if I find an answer.
Chris Harvie|||Here's the scoop. After a time of inactivity
First, a quick little hack. Create a very simple report, have it autoexecute
every x minutes (I do 5 minutes). I just leave this up. The delay goes away.
Then there are these suggestions from another poster which I have included
below. Personally, I had a report that I look at frequently anyway so I have
not tried this. I know my suggestion will work. If you try the below post
back on your success or failure:
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>>>>>>>>>>>>>>
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
>>>>>>>>
<Harv013@.gmail.com> wrote in message
news:1129825242.427488.89690@.o13g2000cwo.googlegroups.com...
>I think what you will find is happening is that the Reporting Service
> is "starting up" the first time you access it. We are having the same
> problem and I am currently trying to find an answer. There is an
> article on Microsoft's website talking about Anti-virus causing it to
> restart frequently. But this doesn't seem to be that problem. The
> server "stops" after a certain amount of inactivity and then takes a
> while to start up when it's next accessed.
> I'll post here if I find an answer.
> Chris Harvie
>

Reporting Services Parameters

I have a report set up in SQL reporting services which I need to pass two values: fundingRef and mRef from another aspx page which I have managed to get working using the following code:

string param = "&fundingRef=2" + "&mRef=25";
ReportViewer1.ReportPath = Global.ReportPath + reportPath + param;

Both the parameters have been set up in the SQL report designer in VS2003.NET and will contain several values using the SQL IN statement. My sql statement is to a structure as follows:

SELECT [field names] FROM [table] WHERE (fundingRef in(@.fundingRef )) AND (mastercourseRef in(@.mRef))

When I pass single values, it works fine but when I try to send values e.g. 14, 25, 3, 4, 28, 2, 1, 6, 5. I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot read the next data row for the data set TTP. (rsErrorReadingNextDataRow) Get Online Help Error converting data type nvarchar to bigint.

I have tried declaring the variable as a varchar but although it returns no error, it also returns no records. Please can someone enlighten me as to how I can this to work. Cheers.

Are you using "," as value seperators?

D.|||Yes|||This should work with RS 2005 as it support multiple param selections.

I'm guessing this is the reason it's not working now.|||Try using a table function & large varchar parameter if your report can accomodate.
See this article on parsing tokens...|||Cool, thanks for the information wavesmash. I hope this should fix my problem. I'll let you know how I get on.

Cheers again

Reporting Services Parameters

I have a report set up in SQL reporting services which I need to pass two values: fundingRef and mRef from another aspx page which I have managed to get working using the following code:

string param = "&fundingRef=2" + "&mRef=25";
ReportViewer1.ReportPath = Global.ReportPath + reportPath + param;

Both the parameters have been set up in the SQL report designer in VS2003.NET and will contain several values using the SQL IN statement. My sql statement is to a structure as follows:

SELECT [field names] FROM [table] WHERE (fundingRef in(@.fundingRef )) AND (mastercourseRef in(@.mRef))

When I pass single values, it works fine but when I try to send values e.g. 14, 25, 3, 4, 28, 2, 1, 6, 5. I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot read the next data row for the data set TTP. (rsErrorReadingNextDataRow) Get Online Help Error converting data type nvarchar to bigint.

I have tried declaring the variable as a varchar but although it returns no error, it also returns no records. Please can someone enlighten me as to how I can this to work. Cheers.

Are you using "," as value seperators?

D.|||Yes|||This should work with RS 2005 as it support multiple param selections.

I'm guessing this is the reason it's not working now.|||Try using a table function & large varchar parameter if your report can accomodate.
See this article on parsing tokens...|||Cool, thanks for the information wavesmash. I hope this should fix my problem. I'll let you know how I get on.

Cheers again

Reporting services- Magnify to 150%

I have a report that has abt 20 + fields . For all fields to fit on 1 page, I have set the
font size to 6 on that report.
Howevever, when the font size is 6, the report appears very small size when viewed from
the screen. In order to see teh reprot clearly on the scree, users have to magnify it to
150% and then they are able to view it clearl on screen.
Is there any way in reporting services, where when the report is delviered on the screen,
it automatically sets it to a 150% by default, so that
way users dont have to manually change to 150% every time they view the report?

This is simple to do if you have created a windows or web application using Visual Studio 2005. However, I doubt it's possible just using reporting services and viewing it in report manager. You don't have much control over the code for report manager.

Reporting Services linked report in a pop up window.

Hi All,

We have a j2ee application which uses Microsoft Reporting Services 2005 for reports.

In our JSP page we show and hide an IFRAME for which the src url is given as the Report URL with queryString for parameters.

Is there a standard way to POST data to report rather than passing it to URL in query String.

We also have a linked report.

We need to display this report in a Popup or provide a back button .

How to do this..

Kindly help me in this regard as we are new to reporting services

use the follwing java script to get the report in new windon

"javascript:void window.open('Reportviewer? + ReportName', '_blank', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"

|||

HI this works when i give this in the Jump to URL and access through Report Manager.

When i click through my application. the url gets pasted in the address bar and page cannot be displayed screen is seen.

In my application when user clicks the run report button we show the Report in the same Page using IFRAME.

when the user clicks the Link for the linked report it is not opening in a popup.

"javascript:void window.open('Reportviewer? + ReportName', '_blank', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"

Please Tell me how to solve this.

Reporting Services initial page load takes to long.

I have looked all over to get an answer to the following:
I have installed Reporting Services with the latest service pack. When
I or any of my customers try to initially load the default page
(http://localhost/reports/Pages/Folder.aspx) it will take 20-30
seconds. After the initial load it is fine. The next day when we try
to access it again, it takes 20-30 seconds again. I have seen two
people ask the same question on the newsgroups with no answers.
Some may feel this is not a big deal, but I am moving from one
reporting service to "Reporting Services" and the less issues my
customers have the easier it will be for me to sell this. If I could
get this corrected it would be great, but if I can not, I would at
least like a logical reason why this occurs.
Also
Is there an equivalent function in RS to Crystal's "Next" command
I am converting a report from Crystal to Reporting Services and I need
the ability to look ahead by one row (the Next command in Crystal) and
use this data from the result set to perform certain calculation. If
there is not a similar command is there a way to do this short of
creating a temp table and using a cursor?
Thanks,
TomThe initial delay occurs when ASP.Net first compiles all of the assemblies.
This occurs during the first access only. After a period of time of
inactivity the ASP.Net worker process is unloaded and the whole thing must
start over again.
For you second question I would start a new thread with a subject which
reflects the question, otherwise it might not get answered.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1096037678.531999.323430@.k26g2000oda.googlegroups.com...
> I have looked all over to get an answer to the following:
> I have installed Reporting Services with the latest service pack. When
> I or any of my customers try to initially load the default page
> (http://localhost/reports/Pages/Folder.aspx) it will take 20-30
> seconds. After the initial load it is fine. The next day when we try
> to access it again, it takes 20-30 seconds again. I have seen two
> people ask the same question on the newsgroups with no answers.
> Some may feel this is not a big deal, but I am moving from one
> reporting service to "Reporting Services" and the less issues my
> customers have the easier it will be for me to sell this. If I could
> get this corrected it would be great, but if I can not, I would at
> least like a logical reason why this occurs.
> Also
> Is there an equivalent function in RS to Crystal's "Next" command
> I am converting a report from Crystal to Reporting Services and I need
> the ability to look ahead by one row (the Next command in Crystal) and
> use this data from the result set to perform certain calculation. If
> there is not a similar command is there a way to do this short of
> creating a temp table and using a cursor?
>
> Thanks,
> Tom
>

Reporting Services Footer issue and workarounds

I had to create an invoice report, where there is a stub on the buttom of the last page.

I need a report footer and RS does not have it.

I talked to Microsoft about it, here is the full emails between me and Microsoft.

hope this helps

Read from buttom to top

--

Hi Ronnie

Sorry I was late in getting back to you as I was out of the office in the last couple of days

I made some checks and it seems the problem that you have is a genuine one.

The workarounds that you specified are the only solutions available now.

I checked with the development team and even though they are aware of the problem, they told me that there won’t be changes to fix it in SQL 2008

So you have to decide on one of the workarounds that you specified

Best Regards,

Hi Tamer,

I wonder if you had any updates on our issue with RS2005.

Thanks,

---

Thanks for your help on this issue, I am going to more research on your solution (moving the footer to the body).

Meanwhile, I be looking forward for your sample as well.

Thanks again for all your efforts.

Ronnie Peretz

---

Hi neil

I think there is a way to implement your need in Reporting Services

Reporting Services has a free form designer which means that whatever you put on the report will appear in the same order in the final view. This is why we don’t have a report footer.

Instead of putting the stub in the footer, just put it after the last item.

You can use a list dataregion to make sure that the stub will always appear at the bottom of the page in the expected location

Ronnie, I hope that solves your problem

Contact me directly if you need more info on how to implement this

Best Regards,

Tamer Farag

---

Here are all the facts I learned about Reporting Services "Report Footer" limitations and workaround I have tried.

Objective: On the last page of an invoice at the bottom of the last page have a stub of the invoice:

Issue: Reporting Services does not support Report Footer only Page Footer. (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1439673&SiteID=1)

Work around that I have tried:

Work around 1:

I have created a page footer with a rectangle and set the Visibility expression to =Globals.PageNumber < Globals.TotalPages

Results: The page footer did show up only in the last page, but created a block of space in the first pages.

I was trying to see if there is a way to suppress the spaces from the first pages, and found out it's not supported in Reporting Services

This behavior where the report body would consume the space of the empty page header & footer is currently not supported.

-- Robert (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=340650&SiteID=1)

Work around 2:

I tried to fit all the footer objects in the rectangle in a very small height range, hoping it will auto grow at run time. That did not work as well.

The textboxes did auto grow, but the Rectangle object or the Page Footer itself does not auto grow, cause to cut the footer information.

Work around 3:

Set the property on the page footer PrintOnFirstPage to False, and PrintOnLastPage = True, Reporting services does print the footer in pages in between.

works great for reports that have only 2 pages, but not not more then 2 pages

Best workaround:

Instead of having a space block at the bottom of each page, have a marketing text on every page except the last page

I had overlap a textbox on top of the rectangle (in the page footer) and having this expression on the Visibility =Globals.PageNumber = Globals.TotalPages.

For most of the invoices which are one page, that text will not show up and the Invoice stub will show up

For Invoices which are two pages or more, the marketing text will show up in the first pages only and in the last page the Invoice stub will show.

note: this workaround cause a warning saying "Overlapping report items are not supported in all renderers."

but it is supported for PDF.

In Reporting services 2000 there is actually a messy way of representing data in your headers and footers.

I used the follwoing method to present header and footer values without using global variables for an invoice showing a remittance advice/footer with dataset values.

Basically it seems reporting services renders the body section content first, one would presume that this is because it needs to know what content lies there to produce the values for page totals and numbering etc.

What you need to do is use a text box (or multiple) in the body field, with the repeat with "table1" (which contains your invoice row detail and totals) option set, and set the hidden attribute to "true". Then overlap your table with your invoice rows on top of these fields. This will ensure that your header and footer values are repeated on each page.

Now to use the hidden text boxes you have just created in the header and footer, you just need to create another text box containing this expression

=ReportItems("TextBox1").Value

Where "TextBox1" obviously reffers to one of the fields you've created and hidden in the body content.

I hope this helps, why you can reference a textbox value in the body and not a field value, I have no idea... something overlooked I guess?

Thanks

Gary

Reporting Services Defining Shared Variables SQL 2000

Where do you define shared variables? Is it in the code window, under report properties?

I found an article that will reset the page number when a group changes. I can cut and paste the code into the code window, but I don't know where you define the shared variables the author was referring to in his code snippet.

Thanks!

DotNetNow

Update:

It appears that Shared Variables are defined in the Code window.

DotNetNow

|||

The code panel is where you define shared variables. All is well!

Thanks anyway!

Barry

Reporting services configuration NO initialization

I am installing sql server 2005 reporting services on server running sql server 2005. I get to the reporting services configuration page and configure...
report server virtual directory
report manager virtual directory
windows service identity
web service identity
database setup
encryption keys
when I get to Initialization the button is grey and inactive so I can't initialize reporting
services, Do I need to restart server?

Hello,

You might want to review what's on the database setup tab and try to reapply the settings in there. Make sure that account has access to the database and that all of the services are started.

There are a couple other posts about this same problem on here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=441135&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=723431&SiteID=1

Hope this helps.

Jarret

Reporting Services Configuration -- Database Setup

Hi, I have installed SQL Server 2005 EVAL edition in my machine.

I am not able to configure the Database Setup Page in the Reporting Services Configuration. When i am doing configuration it is displaying the following error.

If I selecct Credentials type as Windows or SQL Server

the error is "Using other editions of SQL Server for report data sources and/or the report server database is not suported in this edition of Reporting Services."

if i select Credentials type as Service Credentials

the error is "A virtual directory must first be created before performing this operation."

Thanking you.

When using the tool, work top down on the left hand pane.

For the first error, it is telling you that the SKU of SQL Server you are using does not allow what you are trying to do. An example of this would be trying to use an Express SKU of RS with the database on a Standard edition of SQL server. Additionally, Express SKU does not allow data sources or databases outside of itself.

I have not seen this error with the Evaluation edition trying to configure on Evaluation edition. If this is the case, please let me know. bradsy(at)microsoft.com