Hiding a Subreport: February 2012

Sunday, February 26, 2012

hiding/password Protecting Enterprise Manager

I have installed SQL 2000 and Enterprise Manager. I have a .Net application
I am developing. I need Enterprise Manager to make data table changes as I
finish my application, but I am afraid my test and final users will use the
Enterprise Manager to change data. I do not want users to change data
without using my application. Can I limit Enterprise Manager or password
protect or block access to other users?
Thanks
Paul DeWitt
Paul DeWitt wrote:
> I have installed SQL 2000 and Enterprise Manager. I have a .Net
> application I am developing. I need Enterprise Manager to make data
> table changes as I finish my application, but I am afraid my test and
> final users will use the Enterprise Manager to change data. I do not
> want users to change data without using my application. Can I limit
> Enterprise Manager or password protect or block access to other users?
> Thanks
> Paul DeWitt
Users can only perform operations that they have security to perform. If
you don't grant access to the tables and use stored procedures to change
and select data, then users logging into the database using any tool
(SQL Enterprise Manager, Query Analyzer, ISQL, OSQL, etc.) will not be
able to change any data unless they call the stored procedures from
those apps. If you do not provide some underlying security in the
database or your users have dbo or admin rights in the database, there
is nothing to prevent them from changing data and nothing you can really
do to stop it, short of encrypting yourself in the application.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Check out application roles (sp_setapprole).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul DeWitt" <PaulDeWitt@.discussions.microsoft.com> wrote in message
news:E0B9510C-7A3A-4EBB-8EA7-A202FC715D1E@.microsoft.com...
>I have installed SQL 2000 and Enterprise Manager. I have a .Net application
> I am developing. I need Enterprise Manager to make data table changes as I
> finish my application, but I am afraid my test and final users will use the
> Enterprise Manager to change data. I do not want users to change data
> without using my application. Can I limit Enterprise Manager or password
> protect or block access to other users?
> Thanks
> Paul DeWitt

Hiding/Collapsing Report Sections

I have lot of information to display on one report. I am trying to come up with a reasonable layout, that could include all the information on one page without over whelming the user. Essentially I would like to divide the report in three sections, ideally with a collapse/expand functionality. Is it possible with Reporting services. How?

- Section1 Heading....(Expanded/Visible)

<Table, text boxes, lists go here>

<...>

+ Section2 Heading (Collapsed/Hidden)

+ Section3 Heading (Collapsed/Hidden)

Any help will be appreciated.

Thanks.

DNG

This is possible using the visibility and toggle properties of report items. Experiment with tables, one for each section. You can add extra header/footer rows as appropriate for your lists and other fields. The same can also be accomplished using rectangles, but I haven't heard good results on the layout of rectangles when rendered in production. It all depends on how the report will be laid out, but in the end, the primary properties are visibility and toggle.

Simone

|||

Very Cool. I am able to use the text box as toggle item but have to use rectangles as it needs to contain multiple tables and other data regions..Hopefully it wont do anything funky in production.

Thanks much.

DNG

Hiding without grouping

hi,
I'm using a matrix to try and display web traffic. For the rows I
can drill down by date. For the columns I am trying to make them be
able to expand based on categories that I define. For example, I would
like to be able to expand/collapse all columns that have to do with
traffic from google. However, I can't seem to check the toggle box. I'm
assuming it's because the columns are not grouped by the item that
toggles them, the way dates are grouped by year. The item that toggles
their visibility is a static text box. The closest I can get is to
toggle the visibility of the column names. Any suggestions?Nevermind, I was just using the wrong table. turns out you can hide
entire columns in the tabular table based on arbitrary toggle items.
You just have to do it in the property window on the side, rather than
right clicking. Has anyone noticed that there's extra unsupported chart
types there? What's a polar graph?|||"What's a polar graph?"
A circular plot showing amplitudes as a function of angle.
http://www.dplot.com/polar.htm

Hiding UserID parameter

In my report I am using 4 parameters i.e UID, LocationID, StartDate and
EndDate.
I am passing the UID parameter to a report in a URL. Based on UID, Locations
will be displayed. I don't want to Show UID on the report parameters header,
But I want to show all other parameters on the report, so that the user can
select locations and StartDate and EndDate.
I have tried &rc:Parameters=false, but this is hiding all the parameters.
I want to Hide only one parameter i.e UID
Please help.Hi,
when you define your paramters within the "Report Parameters"-Window
leave the "Prompt" field of the UID empty.
So it won't be presented to the user parameter but it's still
accessible within your reports.
By the way, if you want to use the current login user (often NT
account) then you could also use the RS internal User!UserID variable.
best regards
BB|||Hi BB
Many thnx for your quick response.
I have applied your logic.
when the "Prompt" field of the UID empty, it does allow for saving the
report and follwoing error is coming
"c:\documents and settings\dimpu\my documents\visual studio
projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
DefaultValue that has both or neither of the following: Values and
DataSetReference. DefaultValue must have exactly one of these elements."
So I have selected a default value for UserID. then it is ok and retrieving
data for that default userid.
But we can not pass a different user through URL.
Suppose the default value for the UserID =100
I want to pass UserID = 101 through URL
then the following error is coming
The report parameter 'UserID' is read-only and cannot be modified.
(rsReadOnlyReportParameter) Get Online Help
"BB_Reporting" wrote:
> Hi,
> when you define your paramters within the "Report Parameters"-Window
> leave the "Prompt" field of the UID empty.
> So it won't be presented to the user parameter but it's still
> accessible within your reports.
> By the way, if you want to use the current login user (often NT
> account) then you could also use the RS internal User!UserID variable.
> best regards
> BB
>|||After you have removed your Promt of UID, please, add a "dummy" value
to List e.g 100 as well as an default value "100". That should work...
cheers
BB|||After you deploy the report, go to the Report Manager and view the parameters
for the report. For the UID parameter, make sure the Prompt String is empty
and that Prompt User is checked. This should fix the problem. When you set
the Prompt String to empty from VS, it sets Prompt User to unchecked when
deployed.
"dimpu" wrote:
> Hi BB
> Many thnx for your quick response.
> I have applied your logic.
> when the "Prompt" field of the UID empty, it does allow for saving the
> report and follwoing error is coming
> "c:\documents and settings\dimpu\my documents\visual studio
> projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> DefaultValue that has both or neither of the following: Values and
> DataSetReference. DefaultValue must have exactly one of these elements."
> So I have selected a default value for UserID. then it is ok and retrieving
> data for that default userid.
> But we can not pass a different user through URL.
> Suppose the default value for the UserID =100
> I want to pass UserID = 101 through URL
> then the following error is coming
> The report parameter 'UserID' is read-only and cannot be modified.
> (rsReadOnlyReportParameter) Get Online Help
>
>
> "BB_Reporting" wrote:
> > Hi,
> >
> > when you define your paramters within the "Report Parameters"-Window
> > leave the "Prompt" field of the UID empty.
> >
> > So it won't be presented to the user parameter but it's still
> > accessible within your reports.
> >
> > By the way, if you want to use the current login user (often NT
> > account) then you could also use the RS internal User!UserID variable.
> >
> > best regards
> >
> > BB
> >
> >|||can you set the Prompt String from another parameter?
IIF(Parameter!A="A",Paramter!B.PromptString="",Paramter!B.PromptString="Something")?
"David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
news:4168C1A3-5098-4E43-BC86-01AAA8E40ED9@.microsoft.com...
> After you deploy the report, go to the Report Manager and view the
> parameters
> for the report. For the UID parameter, make sure the Prompt String is
> empty
> and that Prompt User is checked. This should fix the problem. When you
> set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
>> Hi BB
>> Many thnx for your quick response.
>> I have applied your logic.
>> when the "Prompt" field of the UID empty, it does allow for saving the
>> report and follwoing error is coming
>> "c:\documents and settings\dimpu\my documents\visual studio
>> projects\fsreports\CustomerReport.rdl The report parameter 'UID' has a
>> DefaultValue that has both or neither of the following: Values and
>> DataSetReference. DefaultValue must have exactly one of these elements."
>> So I have selected a default value for UserID. then it is ok and
>> retrieving
>> data for that default userid.
>> But we can not pass a different user through URL.
>> Suppose the default value for the UserID =100
>> I want to pass UserID = 101 through URL
>> then the following error is coming
>> The report parameter 'UserID' is read-only and cannot be modified.
>> (rsReadOnlyReportParameter) Get Online Help
>>
>>
>> "BB_Reporting" wrote:
>> > Hi,
>> >
>> > when you define your paramters within the "Report Parameters"-Window
>> > leave the "Prompt" field of the UID empty.
>> >
>> > So it won't be presented to the user parameter but it's still
>> > accessible within your reports.
>> >
>> > By the way, if you want to use the current login user (often NT
>> > account) then you could also use the RS internal User!UserID variable.
>> >
>> > best regards
>> >
>> > BB
>> >
>> >|||Thnx David, Solved this problem now.
"David Siebert" wrote:
> After you deploy the report, go to the Report Manager and view the parameters
> for the report. For the UID parameter, make sure the Prompt String is empty
> and that Prompt User is checked. This should fix the problem. When you set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
> > Hi BB
> >
> > Many thnx for your quick response.
> >
> > I have applied your logic.
> >
> > when the "Prompt" field of the UID empty, it does allow for saving the
> > report and follwoing error is coming
> >
> > "c:\documents and settings\dimpu\my documents\visual studio
> > projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> > DefaultValue that has both or neither of the following: Values and
> > DataSetReference. DefaultValue must have exactly one of these elements."
> >
> > So I have selected a default value for UserID. then it is ok and retrieving
> > data for that default userid.
> >
> > But we can not pass a different user through URL.
> >
> > Suppose the default value for the UserID =100
> >
> > I want to pass UserID = 101 through URL
> >
> > then the following error is coming
> >
> > The report parameter 'UserID' is read-only and cannot be modified.
> > (rsReadOnlyReportParameter) Get Online Help
> >
> >
> >
> >
> >
> > "BB_Reporting" wrote:
> >
> > > Hi,
> > >
> > > when you define your paramters within the "Report Parameters"-Window
> > > leave the "Prompt" field of the UID empty.
> > >
> > > So it won't be presented to the user parameter but it's still
> > > accessible within your reports.
> > >
> > > By the way, if you want to use the current login user (often NT
> > > account) then you could also use the RS internal User!UserID variable.
> > >
> > > best regards
> > >
> > > BB
> > >
> > >

Hiding URL from User

I have a web application written in ASP, not ASP.Net. We set up a page with an iframe that we populate the SSRS reports into. The url of the report is visible through a right click/properties. Is there a way to either disable the right click or hide the url?

you can disable the right click by adding oncontextmenu="return false" in the body tag:

Hiding two fields.

My report has two fields that are only visible if the report is for the
company "HOOSIER".
so in the two fields I wonted to hide I did this:
Visibility-->Hidden-->=iif(Fields!AgencyCode.Value = "HOOSIER","false","true")
Why does this generate an error?
The Hidden expression used in textbox "Textbox60" returned a data type that
is not valid.
Is not "false" and "true" not false and true?
or is there another way false and true have to be returned from an iif
statement?
Scott BurkeOn Oct 17, 11:28 am, Scott Burke
<ScottBu...@.discussions.microsoft.com> wrote:
> My report has two fields that are only visible if the report is for the
> company "HOOSIER".
> so in the two fields I wonted to hide I did this:
> Visibility-->Hidden-->=iif(Fields!AgencyCode.Value = "HOOSIER","false","true")
> Why does this generate an error?
> The Hidden expression used in textbox "Textbox60" returned a data type that
> is not valid.
> Is not "false" and "true" not false and true?
> or is there another way false and true have to be returned from an iif
> statement?
> Scott Burke
Try this: =iif(Fields!AgencyCode.Value = "HOOSIER",False,True) ,
further it would be good to check for NULL against AgencyCode using
Nothing(..
Thnaks.|||Try
iif(Fields!AgencyCode.Value = "HOOSIER",False,True)
Also good to check value of AgencyCode for NULL using nested IIF
Sambhaji|||That did it.
Normally I get an error if I dont "" the true and false.
I guess when they turn blue you dont need "".
Thank you
Scott Burke
"Sanraj" wrote:
> Try
> iif(Fields!AgencyCode.Value = "HOOSIER",False,True)
> Also good to check value of AgencyCode for NULL using nested IIF
> Sambhaji
>
>

Hiding Top Banner In Subscriptions

Hi there
Does anyone know how to hide the banner on the top of the subscriptions
page when you are viewing via a URL. I have managed it in the reports
by setting the parameters to false etc but cannot do it in the
subscriptions.
Thanks in advance
DaveI would like to second Dave's request for information. I am struggling with
the same problem.
Thanks,
Joe
"Bungle" wrote:
> Hi there
> Does anyone know how to hide the banner on the top of the subscriptions
> page when you are viewing via a URL. I have managed it in the reports
> by setting the parameters to false etc but cannot do it in the
> subscriptions.
> Thanks in advance
> Dave
>|||Add me in as well. I thought I figured this out once, but for the life of me
cannot get this to work anymore.
"Joe" wrote:
> I would like to second Dave's request for information. I am struggling with
> the same problem.
> Thanks,
> Joe
> "Bungle" wrote:
> > Hi there
> >
> > Does anyone know how to hide the banner on the top of the subscriptions
> > page when you are viewing via a URL. I have managed it in the reports
> > by setting the parameters to false etc but cannot do it in the
> > subscriptions.
> >
> > Thanks in advance
> >
> > Dave
> >
> >

Hiding Tooltip text displayed when mouse is over a Crystal Report Field

I want to Hide the Tooltip kind of text
which is displayed when mouse is over a
Crystal Report Field be it a parameter field
or database field in Crsytal Report with
VB.Net.
Thanks in adv.
RitamI am also facing the same problem is there any one available for help??|||I'm using CR 10. Under File -> Options -> Layout Tab there is a checkbox option for Tool tips both in design and preview. Hope that helps.|||You need to put a code in the tag fields... Sorry but thats the only way..

Put Chr(9) in every tag.

FredjeV|||Hi:

How can I put the tag fields with vb6 and crviewer?

Thanks

Hiding the Title Output ?

is there a way to suppress the output of the title of each column ?

i.e.

if that query would normally return

Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

Can i get it to return just:

John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prtwhere ru runing this script? in QA?|||yes you can
select name as ' ' ,age as ' ',rank as ' ' from table_name

Originally posted by ontheDB
is there a way to suppress the output of the title of each column ?

i.e.

if that query would normally return

Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

Can i get it to return just:

John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt|||actually the proposed query will return this:

| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

this means that the heading will not be suppressed, but rather renamed to empty strings.

in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.|||Originally posted by ms_sql_dba
actually the proposed query will return this:

| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

this means that the heading will not be suppressed, but rather renamed to empty strings.

in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.

This question is related to the reply, is it possible to "uncheck Print Column Headers" with actually going to Tools>Options>Results? Is there is a script that would do that same? For example in Oracle you can say:

Set Headings off

Is this possible in Query Analyzer 2000?

Hiding the report parameters when i click on the View report button

hi All,
i am working in SQL reporting services 2005, i have requirement that i
need to show all the report parameters in the report layout and user
can enter or select the values when i click on the view report button,
the report parameters should be hided. i am not sure that we could hide
the report parameters when i click on the view report button.
anyone knows how to implement this. please let me know.
Thank you in advance.
VinodAny idea on the below issue!!!!
thanks
Vinod
Vinod wrote:
> hi All,
>
> i am working in SQL reporting services 2005, i have requirement that i
> need to show all the report parameters in the report layout and user
> can enter or select the values when i click on the view report button,
> the report parameters should be hided. i am not sure that we could hide
> the report parameters when i click on the view report button.
> anyone knows how to implement this. please let me know.
> Thank you in advance.
> Vinod

Hiding the Find option in REPORT Manager - Viewing report

Hi,
I want to suppress the "Find" option in Report Manager when I am viewing the report. Is it possible?
How can we do this?

Thanks in advance.You can do this by creating a custom CSS for the viewer toolbar, modifying the RSReportServer.config file to use this CSS, and setting the find section of the toolbar to display:none in the CSS file.

I am planning on writing a blog entry for more details about this.

Hiding the DB Design.

Hi all,

I am going to install my application at my Client's place.

I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.

The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).

Is there any way i can encrypt my DB design and the data in the DB.

Or is there any other way of restricting the Client from viewing my DB design and data?

Thanks

VishalDisallowing access to the Super User ... i dont think its possible in any system ...|||So how do i hide the DB design?
Is there any way?
May be encription?

Pls suggest...|||Not posible to hide anything from the System Admin user|||Though you may encrypt your stored procs .. decryption algorithms for those are readily availible on the net.|||Hi,

Thanks.

So there is no way that the DB design can be hidden.

Except that I hold the Super Admin password with myself?

Hiding the Database list from a certain user\group

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.

I have read and see that I am not able to do this.|||OVDaddy (dan@.wemhoff.com) writes:

Quote:

Originally Posted by

On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

>Is there a way to limit what user will see in Enterprise Manager? I
>would like them to only see there db's and not all them.

>
I have read and see that I am not able to do this.

I believe that in EM, you will see only the databases you have access to.

In SQL Server Management Studio that comes with SQL 2005, it's a different
story. Here you cannot hide databases.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||By default users see all databases in Enterprise Manager. The following KB
shows a method that you can use so users can see only databases that they
have access to (the title of the article is a bit off topic but in fact it
does show a good method):
http://support.microsoft.com/default.aspx/kb/889696
For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||Plamen Ratchev (Plamen@.SQLStudio.com) writes:

Quote:

Originally Posted by

For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.

Quote:

Originally Posted by

>
Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.
>

Yes, but my understanding of the original post is that it asked for
configuration where users can see only their own databases, so this applies
here. This is what I meant. :)

Plamen Ratchev
http://www.SQLStudio.com

HIDING TEXT BOX IN RDL

Hi All,
I have a text box with static data, I need to hide the textbox based on the
condition, if =Sum(Fields!TotalSessions.Value) > 1 then I need to show the
text box else I need to hide the text box.
How to write the condition and where do I add the text to the text box.
Balaji
--
Message posted via http://www.sqlmonster.comProperties
Visibility
Hidden Expression
Example;
=Iif(Sum(Fields!PO_.Value, "CustomerSubContractsDetail") <> 0, False, True)

Hiding tables in a report

Hi,

Can anyone help me with the expression I need to use in order to hide a table with no rows? I have put my table inside a rectangle with the idea that I would just hide the rectangle if there weren't any rows but I can't find any examples of what expression I can use to specify the no rows condition.

Thanks!

Debi

Something like for the Hidden property of the rectangle:

=iif(RowCount("NameofDatasetPopulatingTheTabe") > 0, "false", "true")|||

Andy,

Thanks for the posting. RowCount doesn't work for me (unrecognized identifier). That may be because I am using the ReportViewer control in an ASP page and not actually using SQL Server Reporting Services. I probably should have included that in my original posting. Also, if it makes a difference this is a subreport that is using a filter based on a parameter passed from the main report. I'm not sure if that will makes a difference but the datasource will usually have records but a table may not have any rows due to the filter. I want to eliminate the header that gets displayed when there are no rows to show.

Thanks!

Debi

|||

I have made some progress on this. The correct syntax is:

=IIf(CountRows("table1") > 0, false, true)

I added this to the visibility of the table and it does hide the table header if there aren't any rows. The only problem is that it still leaves the white space that would have been occupied by the table header. I had read some tips about creating a rectangle and then moving the table into the rectangle and setting the visibility for the rectangle but I can't get it to work. If I use the same expression I get the following error:

Error 1 The Hidden expression for the rectangle ‘rectangle1’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

It seems that table1 is out of scope in this instance but I can't figure out how the scope should be defined. Any one have any suggestions?

Also, will this even accomplish what I want (eliminating the whitespace)? This rectangle/table is in a subreport if that makes any difference.

Thanks!

Debi

|||You can use the same logic for a rectangle, but your scope parameter needs to be the name of the dataset, not the name of the table.

So if your table uses a dataset like "MyDataSet", then use that instead of "table1". The Rectangle will be aware of that scope.|||

Just thought I would mention that there is also the ability to set a message when a table has no rows. This automatically hides the table and displays your message. Setting the "No Rows" property expression to = "" will also hide the table with no message.

Simone

hiding table with null dataset

=iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
visibility expression of table properties. any ideas for using
expressions to hide a table with a null dataset would be great.
tia
mikeHi Mike,
In my reports when there is not data to display (null data set) I have a
textbox that is hidden until the NULL dataset is verified. They it shows "No
Data To Display For the Report Criteria" You can use an expression similar
to the following, just revers the True,False logic if you need to.
=iif(rownumber("DataSetName") = 0, false, true)
Hope this helps,
--
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
http://www.apress.com/book/bookDisplay.html?bID=365
"michaelwall" <michael.w.i@.gmail.com> wrote in message
news:1102355383.431101.270290@.f14g2000cwb.googlegroups.com...
> =iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
> visibility expression of table properties. any ideas for using
> expressions to hide a table with a null dataset would be great.
> tia
> mike
>|||perfect ! thanks
"Rodney Landrum" wrote:
> Hi Mike,
> In my reports when there is not data to display (null data set) I have a
> textbox that is hidden until the NULL dataset is verified. They it shows "No
> Data To Display For the Report Criteria" You can use an expression similar
> to the following, just revers the True,False logic if you need to.
> =iif(rownumber("DataSetName") = 0, false, true)
> Hope this helps,
> --
> Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
> http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
> http://www.apress.com/book/bookDisplay.html?bID=365
>
>
> "michaelwall" <michael.w.i@.gmail.com> wrote in message
> news:1102355383.431101.270290@.f14g2000cwb.googlegroups.com...
> > =iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
> > visibility expression of table properties. any ideas for using
> > expressions to hide a table with a null dataset would be great.
> > tia
> >
> > mike
> >
>
>|||I responded early - The expression hides the table whether the dataset is
emprty or not.
any further ideas? what do you mean by "until the NULL dataset is
verified" how is this done in the report designer, do i need custom code ? It
seems as if the visibility by expression should cover this but I find very
little documentation and no intellisense to experiment... thanks again ...
"Rodney Landrum" wrote:
> Hi Mike,
> In my reports when there is not data to display (null data set) I have a
> textbox that is hidden until the NULL dataset is verified. They it shows "No
> Data To Display For the Report Criteria" You can use an expression similar
> to the following, just revers the True,False logic if you need to.
> =iif(rownumber("DataSetName") = 0, false, true)
> Hope this helps,
> --
> Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
> http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
> http://www.apress.com/book/bookDisplay.html?bID=365
>
>
> "michaelwall" <michael.w.i@.gmail.com> wrote in message
> news:1102355383.431101.270290@.f14g2000cwb.googlegroups.com...
> > =iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
> > visibility expression of table properties. any ideas for using
> > expressions to hide a table with a null dataset would be great.
> > tia
> >
> > mike
> >
>
>|||=iif(ReportItems!txtTotalDistribution.Value >= 1, FALSE, TRUE)
works by looking at an aggregate SUM() field in the table footer
"Rodney Landrum" wrote:
> Hi Mike,
> In my reports when there is not data to display (null data set) I have a
> textbox that is hidden until the NULL dataset is verified. They it shows "No
> Data To Display For the Report Criteria" You can use an expression similar
> to the following, just revers the True,False logic if you need to.
> =iif(rownumber("DataSetName") = 0, false, true)
> Hope this helps,
> --
> Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
> http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
> http://www.apress.com/book/bookDisplay.html?bID=365
>
>
> "michaelwall" <michael.w.i@.gmail.com> wrote in message
> news:1102355383.431101.270290@.f14g2000cwb.googlegroups.com...
> > =iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
> > visibility expression of table properties. any ideas for using
> > expressions to hide a table with a null dataset would be great.
> > tia
> >
> > mike
> >
>
>|||Data regions (table, list, matrix, charts, subreports) have a NoRows
property. If set, the NoRows message will be shown instead of the data
region. In addition, style properties (fonts, colors, etc.) directly set on
the data region reportitem (e.g. table) will apply to the NoRows message.
Alternatively, you could use the RowCount aggregate functions to determine
the number of rows in a dataset. E.g. =RowCount("DataSetName")
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_0k6r.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"michaelwall" <michaelwall@.discussions.microsoft.com> wrote in message
news:4D53BEB6-D542-49B1-A8F5-A144990CB93C@.microsoft.com...
> perfect ! thanks
> "Rodney Landrum" wrote:
> > Hi Mike,
> > In my reports when there is not data to display (null data set) I have a
> > textbox that is hidden until the NULL dataset is verified. They it shows
"No
> > Data To Display For the Report Criteria" You can use an expression
similar
> > to the following, just revers the True,False logic if you need to.
> >
> > =iif(rownumber("DataSetName") = 0, false, true)
> >
> > Hope this helps,
> > --
> > Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
> >
http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
> > http://www.apress.com/book/bookDisplay.html?bID=365
> >
> >
> >
> >
> > "michaelwall" <michael.w.i@.gmail.com> wrote in message
> > news:1102355383.431101.270290@.f14g2000cwb.googlegroups.com...
> > > =iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in
> > > visibility expression of table properties. any ideas for using
> > > expressions to hide a table with a null dataset would be great.
> > > tia
> > >
> > > mike
> > >
> >
> >
> >

Hiding Table Rows

Is it possible to hide full table rows depending on data in a record?Yes. Highlight a table row in Layout view. Expand the Visibility property.
Underneath there is a Hidden property. You can set this to an expression. So
you could do something like:
=iif(MyCondition, True, False)
HTH
Charles Kangai, MCT, MCDBA
"MER78" wrote:
> Is it possible to hide full table rows depending on data in a record?|||When I do that... it hides the row... but instead I just get blank space
where the row would have been.
"Charles Kangai" wrote:
> Yes. Highlight a table row in Layout view. Expand the Visibility property.
> Underneath there is a Hidden property. You can set this to an expression. So
> you could do something like:
> =iif(MyCondition, True, False)|||I see. Then do the following:
1) Remove all previous expressions.
2) Highlight the entire detail row again.
3) In the Properties sheet, select the Grouping property and click on the
ellipsis button to its right.
4) On the General tab, select a unique expression in the Expression column.
You want a unique expression for each row so that each row is in its own
group. You are not really grouping, but just pretending to, so that we can
use the Visibility feature.
5) Now click on the Visibility tab. For the Initial visibility radio button,
select Expression.
6) Now enter your expression, such as =IIF(Fields!MyRevenue.Value<100,True,
False)
This will now hide the (entire) row if MyRevenue is less than 100. You will
not get blank rows like before.
HTH this time
Charles Kangai, MCT, MCDBA
"MER78" wrote:
> When I do that... it hides the row... but instead I just get blank space
> where the row would have been.
> "Charles Kangai" wrote:
> > Yes. Highlight a table row in Layout view. Expand the Visibility property.
> > Underneath there is a Hidden property. You can set this to an expression. So
> > you could do something like:
> >
> > =iif(MyCondition, True, False)

hiding Table Rows

Is it possible to determine whether or not another row in a table is visible? The example is in a multiple detail row table, where I want to display a 'header' row (really just another detail row), if any of the other detail rows in the 'section' are visible.  Is there some syntax like ReportItems!TableRow7.property("Hidden")=?? that I could use to determine the visibility state of a row?Thanks
Anil

Hi,
in Layout Tab, select the row and in the Property Panel select Visibility -> Hidden -> Expression.
Best Regards
|||

Thanks for your response but it does not solve my problem.

My Problem is I have master detail records.

If detail records are not existing then I have to make the master row invisible

Could anybody help me out fom this problem.

Ofcourse I solved it by modifying the database query but still want the solution of this problem

Thanks

Anil

|||

Hi...Yes u can hide the Rows using If Expressions...do onething...what ever the textbox u want hide...go.
1)..selct Property Window(F4) ...
2) then click Visibility -> hidden -> Select <Expressin..>
then write like this....I am writting One Example Only.....use this...

=iif(ReportItems!textbox2.Value="Y",False,True)
False-- Visible
True- Hide of textbox
U cAN WRITE FOR ANY THING....
Ok..Good Luck...

Hiding Table Header on First Page

I would like to hide a header row on page one and only display it on the
consecutive pages. Since I can't refer to the global page number variable,
I can't think of any way to accomplish this.
Basically, my end result is that I want to have a report header that
contains a bold graphic and other details like report name and execution
time, which will only display on the first page. Then I want to have the
same header display without the graphic on consecutive pages.. I tried
simply supressing the graphic on pages > 1, but then there is still empty
space since their is no way of dynamically sizing the page header. My goal
is to conserve real estate.
So then I tried adding a table into my body that mirrors my page header,
sans graphic, but then I run into the issue not being able to supress it on
page one.
Does anyone know of an alternate solution for what I am trying to do?
Thanks,
LisaThe technique here is to
* Add a page header that to the report that does not contain the graphic.
Set the PrintOnFirstPage to false. This will supress it from appearing on
page 1 of the report.
* Add a report header to the report that contains the graphic. This will be
the first item
item in the report body. In your case you would want to use a rectangle that
contains the image and other text.
* Next add the rest of your report below the report header.
The sample report that demonstrates this technique is at the end of this
posting.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:%23HnQ5i7XEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I would like to hide a header row on page one and only display it on the
> consecutive pages. Since I can't refer to the global page number
variable,
> I can't think of any way to accomplish this.
> Basically, my end result is that I want to have a report header that
> contains a bold graphic and other details like report name and execution
> time, which will only display on the first page. Then I want to have the
> same header display without the graphic on consecutive pages.. I tried
> simply supressing the graphic on pages > 1, but then there is still empty
> space since their is no way of dynamically sizing the page header. My
goal
> is to conserve real estate.
> So then I tried adding a table into my body that mirrors my page header,
> sans graphic, but then I run into the issue not being able to supress it
on
> page one.
> Does anyone know of an alternate solution for what I am trying to do?
> Thanks,
> Lisa
>
ReportHeader.PageHeader.rdl
----
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>2.75in</Width>
<CanGrow>true</CanGrow>
<Value>def</Value>
</Textbox>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<ZIndex>1</ZIndex>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>Northwind</DataSetName>
<Top>0.75in</Top>
<Width>6.70833in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox10</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox11</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<TableColumns>
<TableColumn>
<Width>2.23611in</Width>
</TableColumn>
<TableColumn>
<Width>2.23611in</Width>
</TableColumn>
<TableColumn>
<Width>2.23611in</Width>
</TableColumn>
</TableColumns>
</Table>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>textbox2</rd:DefaultName>
<Height>0.625in</Height>
<CanGrow>true</CanGrow>
<Value>abc</Value>
</Textbox>
</ReportItems>
<Style />
<Height>2.25in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>5c316211-903e-46bc-822a-eeb33657050e</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.75in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactName">
<DataField>ContactName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactTitle">
<DataField>ContactTitle</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Address">
<DataField>Address</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Region">
<DataField>Region</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PostalCode">
<DataField>PostalCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Phone">
<DataField>Phone</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Fax">
<DataField>Fax</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>select * from customers</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>c669cf6f-4e17-4f54-9599-e857f8ed9a14</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>|||Thank you very much. This brings me much closer to the results I want to
achieve. Although, I am noticing that although the Page Header is not
displayed on the first page, it is still taking up a bit of space. On page
one, my "psuedo" page header is beginning about an inch below the top. I
don't want my margin to be this large. I checked both the report margins
and the body and page header margins. All are set to the lowest possible
top height. Maybe I am missing something?
Thanks,
Lisa
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:uFSEjQ9XEHA.3988@.tk2msftngp13.phx.gbl...
> The technique here is to
> * Add a page header that to the report that does not contain the graphic.
> Set the PrintOnFirstPage to false. This will supress it from appearing on
> page 1 of the report.
> * Add a report header to the report that contains the graphic. This will
be
> the first item
> item in the report body. In your case you would want to use a rectangle
that
> contains the image and other text.
> * Next add the rest of your report below the report header.
> The sample report that demonstrates this technique is at the end of this
> posting.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
> news:%23HnQ5i7XEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > I would like to hide a header row on page one and only display it on the
> > consecutive pages. Since I can't refer to the global page number
> variable,
> > I can't think of any way to accomplish this.
> >
> > Basically, my end result is that I want to have a report header that
> > contains a bold graphic and other details like report name and execution
> > time, which will only display on the first page. Then I want to have
the
> > same header display without the graphic on consecutive pages.. I tried
> > simply supressing the graphic on pages > 1, but then there is still
empty
> > space since their is no way of dynamically sizing the page header. My
> goal
> > is to conserve real estate.
> >
> > So then I tried adding a table into my body that mirrors my page header,
> > sans graphic, but then I run into the issue not being able to supress it
> on
> > page one.
> >
> > Does anyone know of an alternate solution for what I am trying to do?
> >
> > Thanks,
> >
> > Lisa
> >
> >
> ReportHeader.PageHeader.rdl
> ----
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
> tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <PageHeader>
> <ReportItems>
> <Textbox Name="textbox1">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>2.75in</Width>
> <CanGrow>true</CanGrow>
> <Value>def</Value>
> </Textbox>
> </ReportItems>
> <PrintOnLastPage>true</PrintOnLastPage>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> <Height>0.25in</Height>
> </PageHeader>
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <Height>0.75in</Height>
> <ZIndex>1</ZIndex>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox3">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>8</ZIndex>
> <rd:DefaultName>textbox3</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>Company Name</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox4">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>7</ZIndex>
> <rd:DefaultName>textbox4</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox5">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>6</ZIndex>
> <rd:DefaultName>textbox5</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Header>
> <Details>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="CompanyName">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>CompanyName</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Fields!CompanyName.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox7">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>1</ZIndex>
> <rd:DefaultName>textbox7</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox8">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox8</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Details>
> <DataSetName>Northwind</DataSetName>
> <Top>0.75in</Top>
> <Width>6.70833in</Width>
> <Footer>
> <TableRows>
> <TableRow>
> <Height>0.25in</Height>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox9">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>5</ZIndex>
> <rd:DefaultName>textbox9</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox10">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>4</ZIndex>
> <rd:DefaultName>textbox10</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox11">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>3</ZIndex>
> <rd:DefaultName>textbox11</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> </TableRow>
> </TableRows>
> </Footer>
> <TableColumns>
> <TableColumn>
> <Width>2.23611in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.23611in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.23611in</Width>
> </TableColumn>
> </TableColumns>
> </Table>
> <Textbox Name="textbox2">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <rd:DefaultName>textbox2</rd:DefaultName>
> <Height>0.625in</Height>
> <CanGrow>true</CanGrow>
> <Value>abc</Value>
> </Textbox>
> </ReportItems>
> <Style />
> <Height>2.25in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="Northwind">
> <rd:DataSourceID>5c316211-903e-46bc-822a-eeb33657050e</rd:DataSourceID>
> <ConnectionProperties>
> <DataProvider>SQL</DataProvider>
> <ConnectString>data source=localhost;initial
> catalog=Northwind</ConnectString>
> <IntegratedSecurity>true</IntegratedSecurity>
> </ConnectionProperties>
> </DataSource>
> </DataSources>
> <Width>6.75in</Width>
> <DataSets>
> <DataSet Name="Northwind">
> <Fields>
> <Field Name="CustomerID">
> <DataField>CustomerID</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="CompanyName">
> <DataField>CompanyName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactName">
> <DataField>ContactName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactTitle">
> <DataField>ContactTitle</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Address">
> <DataField>Address</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="City">
> <DataField>City</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Region">
> <DataField>Region</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="PostalCode">
> <DataField>PostalCode</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Country">
> <DataField>Country</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Phone">
> <DataField>Phone</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Fax">
> <DataField>Fax</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>select * from customers</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <rd:ReportID>c669cf6f-4e17-4f54-9599-e857f8ed9a14</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
>

Hiding Table Header on first Page

Hi,
In my report, I am displaying two tables. Both table has headers.The
first table will end at 1st page itself & the second table will start from
1st page of my report & continue for n number of pages.I want to show the
header of the second table from second page onwards.How can I implement the
same. Is there any solution please?I would use a snippit of custom code personally to set the visibility
property of the table header row, e.g.
=code.getShowHeader(Globals!pageNumber)
The getShowHeader Function returns either true of false depending on the
value of the page number you pass in.
In case you don't already know you define custom code from the report menu,
properties, code tab
Hope this makes sense.
Mike
"Sathiya" <Sathiya@.discussions.microsoft.com> wrote in message
news:91DB93FC-2BBF-4836-9A8E-4DE3A2654AD0@.microsoft.com...
> Hi,
> In my report, I am displaying two tables. Both table has headers.The
> first table will end at 1st page itself & the second table will start from
> 1st page of my report & continue for n number of pages.I want to show the
> header of the second table from second page onwards.How can I implement
> the
> same. Is there any solution please?|||Hi Mike,
Thanks for the suggestion. But like you said If I use
Globals!Pagenumber in table header row's visibility property then in preview
I am getting error as "These global Variables can be used only in the page
header and page footer". Is there any other way to solve my issues?.
Please....
"Michael Knee" wrote:
> I would use a snippit of custom code personally to set the visibility
> property of the table header row, e.g.
> =code.getShowHeader(Globals!pageNumber)
> The getShowHeader Function returns either true of false depending on the
> value of the page number you pass in.
> In case you don't already know you define custom code from the report menu,
> properties, code tab
> Hope this makes sense.
> Mike
> "Sathiya" <Sathiya@.discussions.microsoft.com> wrote in message
> news:91DB93FC-2BBF-4836-9A8E-4DE3A2654AD0@.microsoft.com...
> > Hi,
> > In my report, I am displaying two tables. Both table has headers.The
> > first table will end at 1st page itself & the second table will start from
> > 1st page of my report & continue for n number of pages.I want to show the
> > header of the second table from second page onwards.How can I implement
> > the
> > same. Is there any solution please?
>
>

Hiding Table Grid Lines

I have a table that duplicate data in some of the columns. I have the
property set to hide the duplicates, but I also want to turn off the borders
for those cells that are duplicated so I gives the same appearance as a
Matrix report when it has duplicated items in a column. Does anyone have an
expression that will turn off the grid lines for a cell if there are
duplicate items and change the background colors of the whole row that are
duplicates?
I am using SSRS 2005.
John WrightOn May 1, 11:27 am, "John Wright" <riley_wrig...@.hotmail.com> wrote:
> I have a table that duplicate data in some of the columns. I have the
> property set to hide the duplicates, but I also want to turn off the borders
> for those cells that are duplicated so I gives the same appearance as a
> Matrix report when it has duplicated items in a column. Does anyone have an
> expression that will turn off the grid lines for a cell if there are
> duplicate items and change the background colors of the whole row that are
> duplicates?
> I am using SSRS 2005.
> John Wright
I'm afraid not; however, if you can determine the duplicates in the
query/stored procedure that is sourcing the report, you can avoid the
duplicates entirely and/or return a flag column (i.e., IsDuplicate) to
the report that can be used for conditional border hiding. Then as
part of the cell properties under BorderStyle for Left/Right/Top/
Bottom you can use an expression like the following to suppress the
borders:
=iif(Fields!IsDuplicate.Value = 1, "None", "Solid")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||If you use the previous function for each grid line (top,bottom, right,left)
and use an IIF statement you can hide or show the lines just fine. Thanks
for the help.
John
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1178073564.091263.171200@.n59g2000hsh.googlegroups.com...
> On May 1, 11:27 am, "John Wright" <riley_wrig...@.hotmail.com> wrote:
>> I have a table that duplicate data in some of the columns. I have the
>> property set to hide the duplicates, but I also want to turn off the
>> borders
>> for those cells that are duplicated so I gives the same appearance as a
>> Matrix report when it has duplicated items in a column. Does anyone have
>> an
>> expression that will turn off the grid lines for a cell if there are
>> duplicate items and change the background colors of the whole row that
>> are
>> duplicates?
>> I am using SSRS 2005.
>> John Wright
>
> I'm afraid not; however, if you can determine the duplicates in the
> query/stored procedure that is sourcing the report, you can avoid the
> duplicates entirely and/or return a flag column (i.e., IsDuplicate) to
> the report that can be used for conditional border hiding. Then as
> part of the cell properties under BorderStyle for Left/Right/Top/
> Bottom you can use an expression like the following to suppress the
> borders:
> =iif(Fields!IsDuplicate.Value = 1, "None", "Solid")
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Hiding table contents without sacrificing too much on performance?

An application uses a database table having proprietary information. We do not want our customer to be able to look at that.

This being a real-time application, performance can not be sacrificed. What is the best way to keep the table data non-viewable without sacrificing the performance?

The easiest way to do this without sacrificing performance is to use permissions and deny select or view permissions on the table in question. Create a special group and only grant that one group access to the table.

This, of course, only protects against an online attack (i.e. the server is running). To protect your database against an offline attack (i.e. someone steals your hard drive), you will need to use some form of encryption. Unfortunately, this does require a performance hit. Depending on how you structure your data, this could be either very large or pretty minor.

If your customer is a database admin, the only way to secure against this would be to use encryption.

Sung

|||

I think Rajeev is looking for some DRM type of solution, in which case this has already been discussed on threads like http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52094&SiteID=1.

Thanks
Laurentiu

Hiding table columns creates solid black columns in PDF

Hello all,

I am having a slight problem when dynamically hiding columns in a data table.

When I use the set the "Hidden" property to true, I seem to end up with a solid black column on the far right of the report... but only when generating the report as a PDF.

I've searched the internet quite a bit trying to track down the issue, but I can't seem to find anything.

Has anyone encountered this problem before? Suggestions?

Thanks,

David

check the background color

it should be transperant

|||

All the cells and columns are set to have a background of transparent

no luck :(

|||Anyone else have any thoughts on this problem?|||

ur best bet would be to hide table row itself rather than just hiding a column and u can give a condition instead of just setting the hidden column to true.

Hiding table columns :: urgent

Hi All .. I want to hide columns in a Table based on the level of drilldowns.
Say I have a report with Country,State,City,Count first level I want to show
only Country,Count and second level Country,State,Count and so on. I tried
giving the toggle item property of the Column to a textbox in the first group
but gives an error saying
Toggle items must be text boxes that share the same scope as the hidden item
or are in a scope that contains the hidden item, and cannot be contained
within the current report item unless current grouping scope has a Parent.
Also no items are available in the drop down for the toggle item. Am I doign
something wrong or is this a Reporting svc limitation. I am stuck with this
pls help ..
Thnx in advance
--
Happy Hacking
ThajeerYou need to change "Group" property instead of text item property.
Henry|||Thanx henry .. but there is group involved here . What I am trying to do is
hide a column just like hiding a row or a group and toggle the visibility
using another item. .. but the drop down itslef wont populate with any item
and if I enter the textbox name it gives me a compile error .. hope I am
clear ..
"fanh@.tycoelectronics.com" wrote:
> You need to change "Group" property instead of text item property.
> Henry
>

Hiding System Tables when connecting with non-microsoft clients

I have a user who would like to connect to a SQL Server database using SAS (a
statistical application) and have the system tables not be displayed
Currently, when the user connects they are shown all of the tables
(including system table). We have inquired on the SAS side and have been
told that it is something that must be on the database side.
Do I need to remove some default permissions? Or send a special connection
string? I know in Ent. Manager, you just clear the show system tables
checkbox - but there is not an option like that when connecting with SAS.
No, it is not something that you can do in the database. You'll have to get
your SAS guys to change their query that retreives the table list. For
example, the following query returns system and user tables, where as the
second one doesn't:
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
--AND OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME),
'isMSShipped') = 0
SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME),
'isMSShipped') = 0
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Mike" <Mics_79@.online.nospam> wrote in message
news:AD6C6A91-7912-429F-90BA-7169CA29B641@.microsoft.com...
I have a user who would like to connect to a SQL Server database using SAS
(a
statistical application) and have the system tables not be displayed
Currently, when the user connects they are shown all of the tables
(including system table). We have inquired on the SAS side and have been
told that it is something that must be on the database side.
Do I need to remove some default permissions? Or send a special connection
string? I know in Ent. Manager, you just clear the show system tables
checkbox - but there is not an option like that when connecting with SAS.

Hiding System Tables

Hi,
Is there a way to hide the system tables on EM?
ThanksUncheck Show System Databases and System objects check box during server registration.|||I thought it might be in the server instance properties...but alas

I couldn't find it...

GOOOOOOOOOOOOOOOO M$

Actually if you right click on the server instance and choose edit, you can see it there...

vivek...why are you worried about this...

something sounds like you're going distribute em to end users ...

AAAAAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH HH

Sorry

Yes? No?|||Thanks guys. Works.

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
Bob
Right-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>
|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
>> Can't seem to find how to hide the tables that start with sys in the
>> tables list. I know it can be done, just can't remember how.
>> Any help greatly appreciated.
>> Bob
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> > Can't seem to find how to hide the tables that start with sys in the
> > tables
> > list. I know it can be done, just can't remember how.
> > Any help greatly appreciated.
> >
> > Bob
> >
> >
>

Hiding Subtotals

Is there a way to hide subtotals based on a parameter value?
--
Is that a cursor in your code!Yes! Just have to write a condition statement in visibility option.
"Ammar" wrote:
> Is there a way to hide subtotals based on a parameter value?
>
> --
> Is that a cursor in your code!|||There is no visibility option associated with the value of the subtotals. The
visibility option pertains to the header cell only. I have tried this and
ended up with subtotal columns with no header. What I am trying to do is to
eliminate the sub total columns all together from appearing (disabling the
subtotal) for a given group if a parameter equals to a predefined value.
"Asim" wrote:
> Yes! Just have to write a condition statement in visibility option.
> "Ammar" wrote:
> > Is there a way to hide subtotals based on a parameter value?
> >
> >
> >
> > --
> > Is that a cursor in your code!|||Ammar:
For any report item, you should be able to set the "visibility -> Hidden"
option.
In the "Hidden" option use the expression value to set it with your
parameter.For example, if you have a parameter say, 'HideSubtotal' and you
want to hide the subtotal column from displaying when 'HideSubtotal' is 1,
then in the expression of subtotal column visibility -> Hidden you will use:
=(Parameters!HideSubtotal.Value = 1)
That should do the trick.
"Ammar" wrote:
> There is no visibility option associated with the value of the subtotals. The
> visibility option pertains to the header cell only. I have tried this and
> ended up with subtotal columns with no header. What I am trying to do is to
> eliminate the sub total columns all together from appearing (disabling the
> subtotal) for a given group if a parameter equals to a predefined value.
> "Asim" wrote:
> > Yes! Just have to write a condition statement in visibility option.
> >
> > "Ammar" wrote:
> >
> > > Is there a way to hide subtotals based on a parameter value?
> > >
> > >
> > >
> > > --
> > > Is that a cursor in your code!|||Once again, there is no visibility option associated with the actual values
in the subtotal columns. In a matrix control when you add a subtotal
reporting designer adds a column with a "Total" label. There is a visibility
option when you select the cell, but if you click the green triangle to
modify the properties of the values of the subtotal column you do not see a
visibility option there. If I added an expression in the visibility option by
selecting the â'Totalâ' cell, then that only control the header of the columns
not the values.
Take some time and try it and you will see
"sam" wrote:
> Ammar:
> For any report item, you should be able to set the "visibility -> Hidden"
> option.
> In the "Hidden" option use the expression value to set it with your
> parameter.For example, if you have a parameter say, 'HideSubtotal' and you
> want to hide the subtotal column from displaying when 'HideSubtotal' is 1,
> then in the expression of subtotal column visibility -> Hidden you will use:
> =(Parameters!HideSubtotal.Value = 1)
> That should do the trick.
> "Ammar" wrote:
> > There is no visibility option associated with the value of the subtotals. The
> > visibility option pertains to the header cell only. I have tried this and
> > ended up with subtotal columns with no header. What I am trying to do is to
> > eliminate the sub total columns all together from appearing (disabling the
> > subtotal) for a given group if a parameter equals to a predefined value.
> >
> > "Asim" wrote:
> >
> > > Yes! Just have to write a condition statement in visibility option.
> > >
> > > "Ammar" wrote:
> > >
> > > > Is there a way to hide subtotals based on a parameter value?
> > > >
> > > >
> > > >
> > > > --
> > > > Is that a cursor in your code!

Hiding subtotal rows when there is only 1 row in the group

How could one do this? I understand you could use the COUNT() function, but I'm not sure which object's visibility would best support this. All that I've tried (subtotal area, group visibility) do not seem to work.

If you change the visible property on the subtotal textbox that RS adds, it will only 'blank out' the area where the subtotal row would have been - this doesn't achieve the desired effect of saving space.

Try this:

Click on the whole row for your group footer
Go to the properties
Put this in the 'Visibility - Hidden' expression.

=IIf(CountRows("GroupName") > 1, False, True)

I tried this on one of my reports and it removed the space used by the group footer, it didn't just blank it out. If there was only one row in that group, the footer wasn't shown, but if there were more than 1 row, it would. Just as a test, you might want to create a new row below your group footer and just add some text in there so that it will show below your subtotals (if you have any). In my case, the row below my group footer was 'moved up' to be directly below the details if there was only one row displayed, otherwise, it was displayed directly below the subtotals.

Hope this helps.

Jarret

|||

It's in a matrix, so group headers and footers aren't apparent options. :(

I could see how that would work in a table though.

|||

When you choose the subtotal option for a group in a matrix, a row does get added. To affect only the subtotal cell in a matrix you need to use the InScope() function. The main thing to understand in the logic is that the subtotal cell for a group is not in scope of that group and hence the function return false for the cell.

For example, say on your rows you have 2 groups called region_group and country_group. You right-click the country textbox and select Subtotal. This adds an additional row containing just the header textbos for the subtotal. You now 3 stages for hiding the subtotal.

1.You now need to add an expression to the details cell for the Visibility -> Hidden property. The expression should be:

=Not InScope("country_group")

This should evaluate to Hidden = True for the total row as it is not in scope of the country_group. If you run this you will probably find that the details cell disappears but the heading remains.

2.Now if you try applying the same expression for Visibility to the subtotal header textbox it should also disappear but will probably leave a blank gap in it's place.

3.If you can apply this same expression to the entire subtotal row (by clicking on the row header) then this should also remove the visible gap.

I'm not sure if the last step is possible as I am unable to test this at the moment (on client site), the first 2 steps should work though.

Hope this helps. Please post the results of your attempts.

|||

Those are great suggestions, but there are no header or footer rows in a matrix.
If I select the entire row that contains the subtotal, a visible property is not exposed.

There are also column groupings after the one I'm mentioning - and if I mess with the group visibility, the successive columns are hidden or blanked out.
I'll see what else can be done to acheive the row hiding.

|||Try taking a look at Actions

Hiding Subtotal in Matrix

Hi,
I have one column group and 3 columns under it in a matrix. I added subtotal
to that column group and now all the 3 columns are summarized and shown. Now
I want to hide one column summary(The other 2 column summary should be
shown). How to do that?
TIA,
SamYou will need to control the Visibility of the textboxes that makeup the
column by using an expression similar to
=iif(InScope("MatrixColumnGroupName"), false, true).
The scope portion of the Inscope() can be the name of a DatasSet, Grouping,
or DataRegion.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ergsc6maEHA.2792@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have one column group and 3 columns under it in a matrix. I added
subtotal
> to that column group and now all the 3 columns are summarized and shown.
Now
> I want to hide one column summary(The other 2 column summary should be
> shown). How to do that?
> TIA,
> Sam
>|||There's no good way to do this in the current version.
But for a sleazy hack workaround, take a look at my reply on the thread from
yesterday titled "Matrix SubTotal"
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:ergsc6maEHA.2792@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have one column group and 3 columns under it in a matrix. I added
subtotal
> to that column group and now all the 3 columns are summarized and shown.
Now
> I want to hide one column summary(The other 2 column summary should be
> shown). How to do that?
> TIA,
> Sam
>|||Hi Chris and Bruce,
Thanks - It works
Samuel
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23TEUIwpaEHA.2812@.tk2msftngp13.phx.gbl...
> You will need to control the Visibility of the textboxes that makeup the
> column by using an expression similar to
> =iif(InScope("MatrixColumnGroupName"), false, true).
> The scope portion of the Inscope() can be the name of a DatasSet,
Grouping,
> or DataRegion.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Samuel" <samuel@.photoninfotech.com> wrote in message
> news:ergsc6maEHA.2792@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I have one column group and 3 columns under it in a matrix. I added
> subtotal
> > to that column group and now all the 3 columns are summarized and shown.
> Now
> > I want to hide one column summary(The other 2 column summary should be
> > shown). How to do that?
> >
> > TIA,
> >
> > Sam
> >
> >
>

Sunday, February 26, 2012

hiding/password Protecting Enterprise Manager

Hiding/Collapsing Report Sections

Hiding without grouping

Hiding UserID parameter

Hiding URL from User

Hiding two fields.

Hiding Top Banner In Subscriptions

Hiding Tooltip text displayed when mouse is over a Crystal Report Field

Hiding the Title Output ?

Hiding the report parameters when i click on the View report button

Hiding the Find option in REPORT Manager - Viewing report

Hiding the DB Design.

Hiding the Database list from a certain user\group

HIDING TEXT BOX IN RDL

Hiding tables in a report

hiding table with null dataset

Hiding Table Rows

hiding Table Rows

Hiding Table Header on First Page

Hiding Table Header on first Page

Hiding Table Grid Lines

Hiding table contents without sacrificing too much on performance?

Hiding table columns creates solid black columns in PDF

Hiding table columns :: urgent

Hiding System Tables when connecting with non-microsoft clients

Hiding System Tables

Hiding system objects in Enterprise manage, how?

Hiding system objects in Enterprise manage, how?

Hiding system objects in Enterprise manage, how?

Hiding Subtotals

Hiding subtotal rows when there is only 1 row in the group

Hiding Subtotal in Matrix

Hiding a Subreport

Blog Archive

About Me