Change Header of Report?

Hi all,

I'm pretty new to SQL Reporting Services so my question might be a little silly.

I was wondering, if it was possible to change the toolbar of a report. The only thing I found to change there, is the sorting and filter dropdowns. But other than that, is there a way to add my own controls like a Commandbutton? If not, is it possible to remove certain things from the toolbar like the print icon?

Thanks for your answers in advance.

Nat

If you are using Report Manager, you cannot change the toolbar of the report viewer. If you are using the new ReportViewer controls (included in Visual Studio 2005) in your application, you can remove buttons from the toolbar. However, you cannot add things to the toolbar. You could have your own toolbar along with the report viewer.

|||Hi Brian,
Thanks for your answer and I apologize for the big delay in answering.
I tried the ReportViewer control in VS 2005. I set the Report Server URL and the Report Path but I keep getting the error: "The request failed with HTTP status 401: Unauthorized."
As I said, I'm all new to this so I have no idea where to search for this error.

Thanks again for your answers in advance.

Nat

Cell1 = Cell2

I'm pulling my hair out now... What am I doing wrong
OK..
Header1 | Header
--+--
cell1 | cell
Very basic table layout..
If Cell1 is just a field value I can do cell2 = reportitems!cell1 an
it works find. However, if Cell1 is a calculation that's slightl
complex and do cell2 = reportitems:cell1 I get
> p:\formulacard\formulacard1\Formula Card SG.rdl The value expressio
for the textbox ?QtyReqdCell? refers to the report item ?kl?. Repor
item expressions can only refer to other report items within the sam
grouping scope or a containing grouping scope
Now this annoys the hell out of me because the cell1 on it's ow
renders fine and returns a values. What am I doing wrongRob,
Is this actually a table or a matrix?
What is the expression in cell 1, both when it succeeds and when it
fails.
The ReportItems option can only deal with items within the same scope,
i.e. on the same level. One of its uses was for exporting to Excel as
formulas instead of values, but there were some bugs with it so
Microsoft curtailed it's functionality a bit. I now avoid using
ReportItems if I can. I tend to make sure the query provides all the
data I need to populate cells, including calculations.
Chris
RobFarley wrote:
> I'm pulling my hair out now... What am I doing wrong?
> OK...
> Header1 | Header 2
> --+--
> cell1 | cell 2
> Very basic table layout...
> If Cell1 is just a field value I can do cell2 = reportitems!cell1 and
> it works find. However, if Cell1 is a calculation that's slightly
> complex and do cell2 = reportitems:cell1 I get
> > p:\formulacard\formulacard1\Formula Card SG.rdl The value expression
> for the textbox ?QtyReqdCell? refers to the report item ?kl?. Report
> item expressions can only refer to other report items within the same
> grouping scope or a containing grouping scope.
> Now this annoys the hell out of me because the cell1 on it's own
> renders fine and returns a values. What am I doing wrong?|||I've gone for that option now, everything is calculated in the quer

Cell Orientation

How do i format the Header cells to be oriented by 90 degrees like in Excel. I tried the WRITING MODE under INTERNATIONAL in properties, and choose "tb-rl". But it gives top to bottom. Is there any way to get it bottom to top?

Is there any example to write Expression in Writing Mode property to display in 30 degrees?

Thanks.

Girija, did you ever find a solution to this? I need to do the same thing, rotate headers by 90 degrees.

Thanks.

|||Unfortunately, this is not supported in the current version of Reporting Services. Arbitrary text rotation is something we would like to add in a future release.

Cell Orientation

How do i format the Header cells to be oriented by 90 degrees like in Excel. I tried the WRITING MODE under INTERNATIONAL in properties, and choose "tb-rl". But it gives top to bottom. Is there any way to get it bottom to top?

Is there any example to write Expression in Writing Mode property to display in 30 degrees?

Thanks.

Girija, did you ever find a solution to this? I need to do the same thing, rotate headers by 90 degrees.

Thanks.

|||Unfortunately, this is not supported in the current version of Reporting Services. Arbitrary text rotation is something we would like to add in a future release.