ftp a report

What is the easiest way to ftp a reporting services report out to a ftp site ?
Any ideas greatly appreciated.
Thanks.Using ftp at command prompt:
C:\>ftp
ftp>open <FtpServerName>
ftp>user <MyUserName> then enter password if required
ftp>lcd <LocalMachineDirectory>
ftp>cd <FtpServerDirectory>
ftp>put <MyReport.rdlFileName>
ftp>close
ftp>quit
C:\>
"steve" wrote:
> What is the easiest way to ftp a reporting services report out to a ftp site ?
> Any ideas greatly appreciated.
> Thanks.|||Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
the question i should have posted is how do you do this from reporting
services? Do you create a subscription ? etc. Only see an option to email to
an address in a unique format. These reports are great and need to provide a
copy of the report to a ftp site.
Thanks
"magendo_man" wrote:
> Using ftp at command prompt:
> C:\>ftp
> ftp>open <FtpServerName>
> ftp>user <MyUserName> then enter password if required
> ftp>lcd <LocalMachineDirectory>
> ftp>cd <FtpServerDirectory>
> ftp>put <MyReport.rdlFileName>
> ftp>close
> ftp>quit
> C:\>
> "steve" wrote:
> > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > Any ideas greatly appreciated.
> >
> > Thanks.|||You could get the report published as a pdf/xls/... to a file share and then
set up an ftp script as a scheduled task.
HTH,
Magendo_man
"steve" wrote:
> Hi magendo_man and thanks for the reply. Have no problem with the ftp syntax
> the question i should have posted is how do you do this from reporting
> services? Do you create a subscription ? etc. Only see an option to email to
> an address in a unique format. These reports are great and need to provide a
> copy of the report to a ftp site.
> Thanks
> "magendo_man" wrote:
> > Using ftp at command prompt:
> >
> > C:\>ftp
> >
> > ftp>open <FtpServerName>
> > ftp>user <MyUserName> then enter password if required
> > ftp>lcd <LocalMachineDirectory>
> > ftp>cd <FtpServerDirectory>
> > ftp>put <MyReport.rdlFileName>
> > ftp>close
> > ftp>quit
> >
> > C:\>
> >
> > "steve" wrote:
> >
> > > What is the easiest way to ftp a reporting services report out to a ftp site ?
> > > Any ideas greatly appreciated.
> > >
> > > Thanks.

Frustrating Reporting Services problem. New machine fails to deploy reports to report serv

Hi All,
I got a new machine. On my old machine, I had no problem using VS
.Net to deploy Report Projects to our Report Server.
On my new machine, I installed IIS, installed VS .Net, enabled
ASP.Net, performed a Report Designer installation of Reporting
Services.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I found the following USENET thread that describes my problem, but I'm
not sure the solution there is the same for me:
http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
All help appreciated.
Thanks a lot,
ChuckCan you navigate to the report manager?
http://MyRServerName/Reports
That is a good troubleshooting step.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> Hi All,
> I got a new machine. On my old machine, I had no problem using VS
> .Net to deploy Report Projects to our Report Server.
> On my new machine, I installed IIS, installed VS .Net, enabled
> ASP.Net, performed a Report Designer installation of Reporting
> Services.
> After I create my report in VS .Net and try to deploy it, I get the
> following error message:
> A connection could not be made to the report server
> http://MyRServerName/ReportServer
> I am a local admin of the machine that the report server is on and I
> have no problem navigating to http://MyRServerName/ReportServer using
> Internet Explorer.
> I found the following USENET thread that describes my problem, but I'm
> not sure the solution there is the same for me:
> http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> All help appreciated.
> Thanks a lot,
> Chuck|||Try running this from command prompt -
rsconfig -c -s127.0.0.1 -dreportserver -aSql -usa -p(your sa password)
"Jeff A. Stucker" wrote:
> Can you navigate to the report manager?
> http://MyRServerName/Reports
> That is a good troubleshooting step.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
> news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> > Hi All,
> >
> > I got a new machine. On my old machine, I had no problem using VS
> > .Net to deploy Report Projects to our Report Server.
> >
> > On my new machine, I installed IIS, installed VS .Net, enabled
> > ASP.Net, performed a Report Designer installation of Reporting
> > Services.
> >
> > After I create my report in VS .Net and try to deploy it, I get the
> > following error message:
> >
> > A connection could not be made to the report server
> > http://MyRServerName/ReportServer
> >
> > I am a local admin of the machine that the report server is on and I
> > have no problem navigating to http://MyRServerName/ReportServer using
> > Internet Explorer.
> >
> > I found the following USENET thread that describes my problem, but I'm
> > not sure the solution there is the same for me:
> >
> > http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> >
> > All help appreciated.
> >
> > Thanks a lot,
> >
> > Chuck
>
>|||I can navigate to http://MyRServerName/Reports using Internet
Explorer. However, the problem remains that I cannot deploy a report
using VS .Net on my new computer.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.

Frustrated with Parameters Automatically Reloading the Report

Hello.
Here's the scenario: I have two report parameters, both with default values.
As I would expect, the report loads automatically in Preview mode. But why,
when I try to change either parameter value, it seems to automatically reload
the report on simply setting focus to the text box for the other parameter.
I can't seem to stop this from happening, and it actually prevents me from
being able to run the report with any other values than the default values.
Am I missing something?
Thanks,
JohnJohn,
The easiest way to stop it is not to populate parameter 2 with a default and
make sure the parameter does NOT allow blanks.
Normally you can stop the report, change the parameters and click view
report to re-run it.
But remember the 'preview' doesn't necessarily behave the same as when
deployed. I don't use the preview mode much anymore because of this. I find
it better to deploy (or run) to a developement area (use solutions
configuration to switch between Debug and Production to handle this) and then
you get a more accurate picture of it's likely behaviour in the wild.
It's not that much extra hassle to do it this way, if you right click the
report in the solution explorer window you can deploy or deploy & Run just
that report.
Solutions Configurator properties can be accessed by clicking the project
name in the Solution Explorer and selecting properties. You can set different
deployment folders for Debug and Production modes here.
Regards
Chris
"JohnJohn" wrote:
> Hello.
> Here's the scenario: I have two report parameters, both with default values.
> As I would expect, the report loads automatically in Preview mode. But why,
> when I try to change either parameter value, it seems to automatically reload
> the report on simply setting focus to the text box for the other parameter.
> I can't seem to stop this from happening, and it actually prevents me from
> being able to run the report with any other values than the default values.
> Am I missing something?
> Thanks,
> John

Front end display of two fields

I am doing a report which needs to display a field like

totals/percentages...

the actual data values is something like this

=(Sum(Fields!B.Value))& " / " &

(Sum(Fields!B.Value))/(sum(Fields!A.Value) + sum(Fields!B.Value)+sum(Fields!C.Value)+sum(Fields!D.Value)+sum(Fields!E.Value)+sum(Fields!F.Value))

*100

the problem is sum (fields!B.value) is an integer (sum of students) like 32

and the aggregate value in the denominator is a percentage value (0.014343443%)

I need to approximate the value to 0.014

something like this

totals/percentages... .......32/0,014 instead of 32 / 0.014343443 in the front end of the report properties

Please help

Thanks

Wouldn't math.Round() do the trick? You just want to round the decimal to three decimal places....Right?|||

="32" & " / " & round(0.014343443, 3)

from OLTP, DW, SSAS, to Report

Transaction db (such as AdentureWorks) changes all the time. If I'd like to see Report updated every day, DW and SSAS should be updated every night. Is there any sample (DTS) or ducoment for this issue?

Thanks!

-Z

I'd suggest you take a look at The Microsoft Datawarehouse Toolkit written by Joy Mundy and Warren Thornthwaite from the Kimball Group. It walks through all of the layers of a BI solution using Microsoft technology (from ETL to DW to SSAS to reporting) and discusses issues such as data latency, ETL schedules, near real-time updates, etc.

HTH,

Dave Fackler

|||

Thanks, Dave! It helps a lot!

-Z

From dataset into Report

First of all:

Thanks for the time lost in trying to resolve my problems,
I have 2 Diferent Databases and N Tables in each one.

--------------
Database1 - TableA
CliCod -- CliName -- SalesMan
() () ()
--------------

--------------
Database2 - TableA
UniqueKey -- CliName -- Value
() () ()
--------------

My problem is not to create the SQL Statement but where to put it (implement it).
Select a.*
From database2.TableA A
Inner join Database1.TableA B ON A.CliName == B.CliName
Where A.SalesMan= @.Input String from User.

Please ber with me :(

All the examples I found are for 1 database - N Tables.
I want ->2<- databases - N tables

I think the best choice is to use the Push Model, so that I create a dataset to pass to crystal report, (and crystal report viewer).

But how can I create a dataset from 2 databases when the data adapter connectionString wants just one database to connect to.

How can I cross reference two Tables in different Databases into the same DataSet, so that I can pass this dataset into the Crystal Report.

I will be very grateful you could help me, because I can not find an example doing this any where.
The SQL statement would look something like this:

Thanks for your time.simplest way would be to creat a temporary dataset, and then connect to that:
SQL sample as follows, to get data from table1 and table2 and store in tableTemp

SELECT table1.PDATE, table1.PLINE, table1.PSHIFT, table1.RUNTIME, table2.RTIME INTO tableTemp
FROM table1 INNER JOIN table2 ON table1.PDATE = table2.PDATE
WHERE (table1.PDATE=#11/19/2004#);

That gives you your server-side table ready for connection.

dave|||I'm not sure how a dataset works...

I use VB6 and Crystal Reports 8.5...

In VB 6, I use ADO to get my data, then I pass the recordset to Crystal Reports (using RDC). See this link (http://www.dev-archive.com/forum/showthread.php?t=309534&highlight=ado) for an example. Doing it this way would allow you to easily pull data from more than one table or database.|||Have you tried using the Merge method of the dataset?...you can generate
2 datasets from the 2 databases...and then merge these dataset into a single one and bind your crystal report to it..just make sure that the 2 datasets have the same structure.

dataset1.merge(dataset2)

yourReport.setdatasource(dataset1)

i hope this helps :)

Fresh Starter in ReportViewer Needs Some Guidance

Hi,

I just started to learn ReportViewer and Reporting Services recently. A few days ago, I created a report project with some reports in it. A few moments ago, I tried to create a page with a ReportViewer in it by using Visual Studio. In smart tag of this ReportViewer, I set the Report Server Url and the Report Path so the ReportViewer refers the reports that I made previously. When I run my application, I receive "The permissions granted to user 'IT-HARIS\IUSR_IT-HARIS' are insufficient for performing this operation. (rsAccessDenied)" message. What should I do next? How to set the permission of a user so he / she is authorized to do an action?

Thanks in advance

Try this cool linkhttp://www.gotreportviewer.com/

|||

Hi,

From your description, it seems that the "IT-HARIS\IUSER_IT-HARIS" is the anonymous user in IIS you set, right?

If so, I think that you should disable the anonymous visiting in your IIS first. And then try to open the SQL reporting service configuration, try to make sure that the user registered in web service identity has been in theSQLServer2005ReportingServiceWebServiceUsers$UserName$XXX andSQLServer2005ReportServerUser$UserName$XXX group, if not, add the user into these two groups.

Thanks.

Freezing matrix groups

In Excel we can freeze panes and split report data so that when you scroll
over you don't loose focus of the groups on the leftmost pane. Can we do
something like this in Report Manager? I want to be able to freeze my row
groupings so that when the report is exported to Excel, the users won't have
to do it. So basically, my question is how can I "feeze" the row groups of a
matrix in Report Manager so that I don't lose focus of these when I scroll to
the right?On Oct 10, 11:00 am, dataGirl <dataG...@.discussions.microsoft.com>
wrote:
> In Excel we can freeze panes and split report data so that when you scroll
> over you don't loose focus of the groups on the leftmost pane. Can we do
> something like this in Report Manager? I want to be able to freeze my row
> groupings so that when the report is exported to Excel, the users won't have
> to do it. So basically, my question is how can I "feeze" the row groups of a
> matrix in Report Manager so that I don't lose focus of these when I scroll to
> the right?
You will want to right-click the top left-hand corner of the matrix
control and select Properties. Then select the Groups tab and below
'Rows' select the 'Edit...' button and select 'Group header should
remain visible while scrolling.'
Regards,
Enrique Martinez
Sr. Software Consultant

freezing column and header in report

I have report with large records and many columns

I would like to freez header and specific column like excel

I tried to freez header it self it's worked

I tried to freez a column it self it's worked

when I tried to freez both in same report it does not work..

any help?

This should work. I assume that you are useing the Matrix type. Are there mutiple groups (rows)?
Are you specifying the

Freeze table header

When exporting a report to excel, Is there any way to keep the table
header from scrolling up in the excel output when a user scrolls down
through the data?
I noticed that anything that's put above the page header is frozen
when the report is exported to excel.
But when I tried placing the table headers in text boxes and putting
them in the page header area, the headers are out of alignment when
it's exported to excel.On the table you can have the header freeze when you scroll.Right click for
properties and last option.
Amarnath
"bevarg" wrote:
> When exporting a report to excel, Is there any way to keep the table
> header from scrolling up in the excel output when a user scrolls down
> through the data?
> I noticed that anything that's put above the page header is frozen
> when the report is exported to excel.
> But when I tried placing the table headers in text boxes and putting
> them in the page header area, the headers are out of alignment when
> it's exported to excel.
>|||I have that option set to True but it doesn't work when I export it to
Excel. It seems to work only when you are viewing the report within
report manager and you have multiple pages.
On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> On the table you can have the header freeze when you scroll.Right click for
> properties and last option.
> Amarnath
> "bevarg" wrote:
> > When exporting a report to excel, Is there any way to keep the table
> > header from scrolling up in the excel output when a user scrolls down
> > through the data?
> > I noticed that anything that's put above the page header is frozen
> > when the report is exported to excel.
> > But when I tried placing the table headers in text boxes and putting
> > them in the page header area, the headers are out of alignment when
> > it's exported to excel.|||On Apr 26, 1:16 pm, bevarg <benovargh...@.gmail.com> wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> > Amarnath
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
You are correct. Unfortunately, you would have to manually set this in
Excel (via Window -> Freeze Panes).
Regards,
Enri|||What you can do is to just align all the table header on the header of the
page then remove the table header, so that header will be frozen. yes page
header is frozen and not table header.
Amarnath
"bevarg" wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> >
> > Amarnath
> >
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> >
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
>
>

Freeze Report Header

Is there a way to freeze the report header so when a user is looking at the
report, on the web, and they scroll down the page that they can always see
the header?
Thanks,
Jasonthis is not yet acheived by microsoft but it is to be done by them (as
they said so ) in any next version wait till that|||Yes, fixed headers will be available in SQL Server 2005 Reporting Services.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"** Spirits **" <muhammadhammad78@.gmail.com> wrote in message
news:1113385952.494987.10490@.z14g2000cwz.googlegroups.com...
> this is not yet acheived by microsoft but it is to be done by them (as
> they said so ) in any next version wait till that
>

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

Freeze Panes in Excel

Is there anything I can do so that when my users export their report from
reporting services to Excel that it freezes the columns'
I also need to set a default zoom %
Is there anyway to do this - thanksI also have that problem. Because when it expands, it can be really time
consuming..
"dragon" wrote:
> Is there anything I can do so that when my users export their report from
> reporting services to Excel that it freezes the columns'
> I also need to set a default zoom %
> Is there anyway to do this - thanks
>

Freeze Pane functionality during Export to Excel

Hi All,

I have created a Report using Sql Server 2005 Reporting Services.

When I export the report to excel, I want to freeze the pane of the headers in the exported excel.

Any pointers on how to achieve this will greatly help me.

Thanks,

S Suresh

There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you.|||Will you please tell me how to set a freeze pane fo rthe page headers? We do not want to export the page headers to the excel because it merges servera columns for one actual data column. That makes it impossible to change the sorting columns. Thanks,|||I'm not sure I understand what you mean, but the only thing exported to a freeze pane is the page headers. There is no way to put any other part of the report into a freeze pane.

If you are trying to have the headers not show up in Excel, you can have them export as "simple" headers. This would put them into Excel as actual Excel headers, and not as part of the worksheet. To do this, you need to set the SimplePageHeaders device info setting:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx

Hope that helps...|||

Thanks a lot for your reply.

What I want to do is exactly what you said not to put page headers into the excel. My page header has two textboxes, so I do not know if that working. I will try your suggestion tomorrow. Thanks again!

|||

Geoff,

Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway.

I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code? Below is the code, please help me out. Thank you very much for your help!

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Render>

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ImageReport,Microsoft.ReportingServices.ExcelRendering">

<Configuration> <DeviceInfo>

<SimplePageHeaders>True</SimplePageHeaders>

</DeviceInfo> </Configuration> </Extension>

</Render>

<PageHeader>

<ReportItems>

<Textbox Name="textbox7">

Error message:

c:\catsreports\catsreports\Contractor.rdl(4): Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Render'. An error occurred at , (4, 4).