Hidding rows disappearing in Excel export

I have a report that looks fine in Report Server, but when I export to
Excel, I lose data.
I have a group that I am repeating the group footer 3 times. The
original footer is the toggle. when I hit the + in Rep Services, it
expands with no problem, showing all of my hidden rows.
when I export it to excel and hit the toggle, it only shows the first
hidden row and loses the other two.
Any ideas?What version of Report Server and Office do you have?
daw
"M@." wrote:
> I have a report that looks fine in Report Server, but when I export to
> Excel, I lose data.
> I have a group that I am repeating the group footer 3 times. The
> original footer is the toggle. when I hit the + in Rep Services, it
> expands with no problem, showing all of my hidden rows.
> when I export it to excel and hit the toggle, it only shows the first
> hidden row and loses the other two.
> Any ideas?
>|||Microsoft SQL Server Reporting Services Version 8.00.1038.00
Excel 2003
thx,
M@.
On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> What version of Report Server and Office do you have?
> daw
> "M@." wrote:
> > I have a report that looks fine in Report Server, but when I export to
> > Excel, I lose data.
> > I have a group that I am repeating the group footer 3 times. The
> > original footer is the toggle. when I hit the + in Rep Services, it
> > expands with no problem, showing all of my hidden rows.
> > when I export it to excel and hit the toggle, it only shows the first
> > hidden row and loses the other two.
> > Any ideas?|||Are you sure that the rows are not just hidden rows in Excel? Are the row
numbers consecutive?
"M@." wrote:
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> Excel 2003
> thx,
> M@.
> On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > What version of Report Server and Office do you have?
> >
> > daw
> >
> > "M@." wrote:
> > > I have a report that looks fine in Report Server, but when I export to
> > > Excel, I lose data.
> >
> > > I have a group that I am repeating the group footer 3 times. The
> > > original footer is the toggle. when I hit the + in Rep Services, it
> > > expands with no problem, showing all of my hidden rows.
> >
> > > when I export it to excel and hit the toggle, it only shows the first
> > > hidden row and loses the other two.
> >
> > > Any ideas?
>
>|||I have a group footer (group1) that I repeat. The first line is the
toggle, lines 2-5 are details. I'm using running values. Row 1 is
the sum. Row2 is a sum when a field = PRV, Row3 is a sum when a field
= MCD and so on.
It looks fine in Reporting Services, but if I export it to excel and
hit the toggle, only the first hidden row pops in.
Yeah, the row numbers are consecutive.
On Mar 21, 4:32 pm, daw <d...@.discussions.microsoft.com> wrote:
> Are you sure that the rows are not just hidden rows in Excel? Are the row
> numbers consecutive?
>
> "M@." wrote:
> > Microsoft SQL Server Reporting Services Version 8.00.1038.00
> > Excel 2003
> > thx,
> > M@.
> > On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > > What version of Report Server and Office do you have?
> > > daw
> > > "M@." wrote:
> > > > I have a report that looks fine in Report Server, but when I export to
> > > > Excel, I lose data.
> > > > I have a group that I am repeating the group footer 3 times. The
> > > > original footer is the toggle. when I hit the + in Rep Services, it
> > > > expands with no problem, showing all of my hidden rows.
> > > > when I export it to excel and hit the toggle, it only shows the first
> > > > hidden row and loses the other two.
> > > > Any ideas... Hide quoted text -
> - Show quoted text -

Hidding report before deployment?

Hi,
does it possible to set the "hidden in list view" option at design time of
the report (or any other objects) in Visual studio prior a deployment?
Because I've a lot of reports and images to send to RS, but some of these
are hidden by default. My front end interface hidde these reports to the
user.
Thanks.
Jerome.No, not from report designer. If you use a script to deploy your reports,
you can manipulate these properties.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jéjé" <willgart@._A_hAotmail_A_.com> wrote in message
news:%23M4yhsJWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> Hi,
> does it possible to set the "hidden in list view" option at design time of
> the report (or any other objects) in Visual studio prior a deployment?
> Because I've a lot of reports and images to send to RS, but some of these
> are hidden by default. My front end interface hidde these reports to the
> user.
> Thanks.
> Jerome.
>|||So, can I add custom information in the RDL file?
My idea is:
Creating a program (or VS add in) to add some deployment option by report,
then my export application will read each report to retrieve my custom
information to know if the report must be hidden or not.
What do you think about this?
or
have you a sample script to deploy RS repotrs?
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> a écrit dans le
message de news:%23CeCTIKWEHA.4032@.TK2MSFTNGP11.phx.gbl...
> No, not from report designer. If you use a script to deploy your reports,
> you can manipulate these properties.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Jéjé" <willgart@._A_hAotmail_A_.com> wrote in message
> news:%23M4yhsJWEHA.4056@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > does it possible to set the "hidden in list view" option at design time
of
> > the report (or any other objects) in Visual studio prior a deployment?
> >
> > Because I've a lot of reports and images to send to RS, but some of
these
> > are hidden by default. My front end interface hidde these reports to the
> > user.
> >
> > Thanks.
> >
> > Jerome.
> >
> >
>|||There is a sample publish script included with the product that you could
use.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23mfVPiYWEHA.1152@.TK2MSFTNGP09.phx.gbl...
> So, can I add custom information in the RDL file?
> My idea is:
> Creating a program (or VS add in) to add some deployment option by report,
> then my export application will read each report to retrieve my custom
> information to know if the report must be hidden or not.
> What do you think about this?
> or
> have you a sample script to deploy RS repotrs?
>
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> a écrit dans le
> message de news:%23CeCTIKWEHA.4032@.TK2MSFTNGP11.phx.gbl...
>> No, not from report designer. If you use a script to deploy your
>> reports,
>> you can manipulate these properties.
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>>
>> "Jéjé" <willgart@._A_hAotmail_A_.com> wrote in message
>> news:%23M4yhsJWEHA.4056@.TK2MSFTNGP11.phx.gbl...
>> > Hi,
>> >
>> > does it possible to set the "hidden in list view" option at design time
> of
>> > the report (or any other objects) in Visual studio prior a deployment?
>> >
>> > Because I've a lot of reports and images to send to RS, but some of
> these
>> > are hidden by default. My front end interface hidde these reports to
>> > the
>> > user.
>> >
>> > Thanks.
>> >
>> > Jerome.
>> >
>> >
>>
>sql

Hidding region of a report

Hi,
i have a report with 5 regions. and when all those regions are filled may
report stand on 2 pages. my Pb is that event if the region are empty, the
space use by each region do not desapear.
Is it possible to hide a data region with no row ?
i wnat my report to apear on 1 page when all the data region are not filled .
Think you for your answer.
Kind RegardsDid you look into Hidden property of a report item? You can conditionally
hide the data region based on its number of rows.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> Hi,
> i have a report with 5 regions. and when all those regions are filled may
> report stand on 2 pages. my Pb is that event if the region are empty, the
> space use by each region do not desapear.
> Is it possible to hide a data region with no row ?
> i wnat my report to apear on 1 page when all the data region are not
filled .
> Think you for your answer.
> Kind Regards|||thank you for you reply.
but when i use this expression in the visibility proprety of my data region
i get this message :
r:\samples\reports\Product Line Sales.rdl The hidden expression for the
table â'TopStoresTableâ' has the value â'Iif(CountRows() = 0, "false", "true")â',
which is not a valid Boolean value.
what can i do ?
thank you for help
"Nico Cristache [MSFT]" wrote:
> Did you look into Hidden property of a report item? You can conditionally
> hide the data region based on its number of rows.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
> in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> > Hi,
> > i have a report with 5 regions. and when all those regions are filled may
> > report stand on 2 pages. my Pb is that event if the region are empty, the
> > space use by each region do not desapear.
> >
> > Is it possible to hide a data region with no row ?
> >
> > i wnat my report to apear on 1 page when all the data region are not
> filled .
> >
> > Think you for your answer.
> >
> > Kind Regards
>
>|||i can now hide the data region with the expression CountRows().
But would like to move data region below to the place of the one hidden.
Is it possible to modify dynamically the position of my data region.
Regards.
"Nico Cristache [MSFT]" wrote:
> Did you look into Hidden property of a report item? You can conditionally
> hide the data region based on its number of rows.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tino [Securitas.fr]" <Tino [Securitas.fr]@.discussions.microsoft.com> wrote
> in message news:25A8CA86-8528-4FEB-9743-1853E347D9BF@.microsoft.com...
> > Hi,
> > i have a report with 5 regions. and when all those regions are filled may
> > report stand on 2 pages. my Pb is that event if the region are empty, the
> > space use by each region do not desapear.
> >
> > Is it possible to hide a data region with no row ?
> >
> > i wnat my report to apear on 1 page when all the data region are not
> filled .
> >
> > Think you for your answer.
> >
> > Kind Regards
>
>

Hidding column in query

Here is my code.

SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
[Condo].[Weekly Rate], [Condo].[Linens]

FROM [Owner], [Condo]

WHERE [Condo].[Linens]=True

AND [Owner].[Owner ID]=[Condo].[Owner ID]

ORDER BY [Condo].[Unit Number];

I am trying to not display "Linens" column in my query result.Any idea how
can i achive that. Thanks in advanceW. Adam (wogla@.sbcglobal.net) writes:
> Here is my code.
> SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
> [Condo].[Weekly Rate], [Condo].[Linens]
> FROM [Owner], [Condo]
> WHERE [Condo].[Linens]=True
> AND [Owner].[Owner ID]=[Condo].[Owner ID]
> ORDER BY [Condo].[Unit Number];
> I am trying to not display "Linens" column in my query result.Any idea how
> can i achive that. Thanks in advance

Well, just don't display it!

Seriously, this is likely to be a GUI issue, and you should probably
ask in a forum devoted to the GUI tool you are using.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"W. Adam" <wogla@.sbcglobal.net> wrote in message
news:tL5Cb.11236$aw2.5741825@.newssrv26.news.prodig y.com...
> Here is my code.
> SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
> [Condo].[Weekly Rate], [Condo].[Linens]
> FROM [Owner], [Condo]
> WHERE [Condo].[Linens]=True
> AND [Owner].[Owner ID]=[Condo].[Owner ID]
> ORDER BY [Condo].[Unit Number];
>
>
> I am trying to not display "Linens" column in my query result.Any idea how
> can i achive that. Thanks in advance

There are two answers to this question. The first being, just don't select
the field

SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
[Condo].[Weekly Rate]
FROM [Owner], [Condo]
WHERE [Condo].[Linens]=True
AND [Owner].[Owner ID]=[Condo].[Owner ID]
ORDER BY [Condo].[Unit Number];

- or -

If you need the linens value but don't want to display it, handle this in
business layer (class, dll, module, mts, etc.), or your presentation layer
(application, web page, etc.).

BV.
www.iheartmypond.com