Conditional Visability in a table

Hi,
I'm new to RS and want to know how to write an expression which will set
visablility of a table group header to false if group1.value = "Account".
Any ideas?
Thanks
Jonthe basics of using an expression to hide a text box is this:
Type an expression that evaluates to a Boolean: True to hide the item and
False to show the item. Click the expression (fx) button to edit the
expression.
Remember, true = hidden, false = show
I don't know if that will work for your table group header as well, but
thats how it works with text boxes.
Karl
"jonwolds" wrote:
> Hi,
> I'm new to RS and want to know how to write an expression which will set
> visablility of a table group header to false if group1.value = "Account".
> Any ideas?
> Thanks
> Jon

Conditional totals for matrix report

I have a matrix report that has the value of one (1) in the row field when my
row header has that value.
agent air hotel cruise
-- -- -- --
bob 1 1
jim 1
jane 1 1
What I want is a total at the bottom of the report counting the numbe of
ones in the column. I am very new to SSRS as a whole, so please help!!
Thanks in advance!Carl,
Right click on the data row cell and click on "subtotals". Thats it you
have column totals.
--Venkat
Carl Henthorn wrote:
> I have a matrix report that has the value of one (1) in the row field when my
> row header has that value.
> agent air hotel cruise
> -- -- -- --
> bob 1 1
> jim 1
> jane 1 1
> What I want is a total at the bottom of the report counting the numbe of
> ones in the column. I am very new to SSRS as a whole, so please help!!
> Thanks in advance!|||Thank you for responding. I have tried the right click method, but the cell
that I need the subtotals on does not have "Subtotal" on the menu. Is there
some other way?
Thanks!
"venkat.oar@.gmail.com" wrote:
> Carl,
> Right click on the data row cell and click on "subtotals". Thats it you
> have column totals.
> --Venkat
> Carl Henthorn wrote:
> > I have a matrix report that has the value of one (1) in the row field when my
> > row header has that value.
> >
> > agent air hotel cruise
> > -- -- -- --
> > bob 1 1
> > jim 1
> > jane 1 1
> >
> > What I want is a total at the bottom of the report counting the numbe of
> > ones in the column. I am very new to SSRS as a whole, so please help!!
> > Thanks in advance!
>|||If possible pls send me the rdl file.. i will work on it and send it to
u back..
Carl Henthorn wrote:
> Thank you for responding. I have tried the right click method, but the cell
> that I need the subtotals on does not have "Subtotal" on the menu. Is there
> some other way?
> Thanks!
>
> "venkat.oar@.gmail.com" wrote:
> > Carl,
> >
> > Right click on the data row cell and click on "subtotals". Thats it you
> > have column totals.
> >
> > --Venkat
> > Carl Henthorn wrote:
> > > I have a matrix report that has the value of one (1) in the row field when my
> > > row header has that value.
> > >
> > > agent air hotel cruise
> > > -- -- -- --
> > > bob 1 1
> > > jim 1
> > > jane 1 1
> > >
> > > What I want is a total at the bottom of the report counting the numbe of
> > > ones in the column. I am very new to SSRS as a whole, so please help!!
> > > Thanks in advance!
> >
> >

Conditional Page Header

Will Crystal Reports have a page header that will hide if a condition is not met or viceaversa? If so how is this done?
Example: If Company_Name = 'xyz' then unhide page header A
thanks in advance
cgInstead of hard coding the header,write a formula like :

if companyname = 'xyz' then

'Header name'

else

' '

and drag the formula in page header!

or

right click on Page header section,select Section Expert,select Common Tab,
click formula button on right of suppress button ,and write

companyname <> 'xyx'|||how exactly do i do this in Crystal? I will have to do the same for the footer too.

thanks
cg|||you mean writing the formula ?

I think you should go for 2nd option for both header and footer i.e suppress the section based on your condition.|||i tried the conditional supressing the header and it is not working.
i have tried with and with out checking the supress box with the formula in there.

this is what i have in the formula, the first 2 are the same. i was testing if it was case sensitive or not. this is a parameter field instead of a db field.

{?CustomerName} <> "Typenex Medical, LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL, LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL L.L.C."
or
{?CustomerName} <> "TYPENEX"
or
{?CustomerName} <> "TYPENEX LLC"

not sure if this makes a difference but i have version 8.5

thanks
cg|||i tried the conditional supressing the header and it is not working.
i have tried with and with out checking the supress box with the formula in there.

this is what i have in the formula, the first 2 are the same. i was testing if it was case sensitive or not. this is a parameter field instead of a db field.

{?CustomerName} <> "Typenex Medical, LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL, LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL LLC"
or
{?CustomerName} <> "TYPENEX MEDICAL L.L.C."
or
{?CustomerName} <> "TYPENEX"
or
{?CustomerName} <> "TYPENEX LLC"

not sure if this makes a difference but i have version 8.5

thanks
cg

You have written the expression wrong.
Whatever you have written will be always true in any condition. Just check it properly. Use

NOT (condition1 AND condition2 AND so on)|||Make it simple :

- Right click on Formula field in field explorer

- click New

-name your formula

Type this

if {?CustomerName} <> 'ABC' and {?CustomerName} <> 'XYZ' then

' '
else

'HEADER'

Drag the formula field in report where you want to print the header.

Conditional Image in Page Header

I have an image defined as:
="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
"DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
"DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
I want to move this image to the report header. But am getting a message
stating that Fields cannot be used in report headers or footers. I think I
can hide it in the report and reference it in the header. But I don't know
how to reference an image.
Anyone know how to get an image in a header?Stephanie,
Can you store the path to the image in a hidden textbox in the body of the
report, then your image in the header will refer to the textbox for it's
image source value.
Make sense?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
>I have an image defined as:
> ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> I want to move this image to the report header. But am getting a message
> stating that Fields cannot be used in report headers or footers. I think
> I
> can hide it in the report and reference it in the header. But I don't
> know
> how to reference an image.
> Anyone know how to get an image in a header?|||Yes, makes sense and I just did that. The report is not erroring out now
(yea!) but the image is blank. This has got to be something people do on a
regular basis, isn't it? I don't want an embedded image because the image
changes based on the database the report is run against.
Any other suggestions on how to put an external image in a page header?
"Andy Potter" wrote:
> Stephanie,
> Can you store the path to the image in a hidden textbox in the body of the
> report, then your image in the header will refer to the textbox for it's
> image source value.
> Make sense?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
> >I have an image defined as:
> > ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> >
> > I want to move this image to the report header. But am getting a message
> > stating that Fields cannot be used in report headers or footers. I think
> > I
> > can hide it in the report and reference it in the header. But I don't
> > know
> > how to reference an image.
> >
> > Anyone know how to get an image in a header?
>
>|||Nevermind my last reply. I tried it again and it worked just fine. THANK YOU!
Stephanie ; )
"Andy Potter" wrote:
> Stephanie,
> Can you store the path to the image in a hidden textbox in the body of the
> report, then your image in the header will refer to the textbox for it's
> image source value.
> Make sense?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
> >I have an image defined as:
> > ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> >
> > I want to move this image to the report header. But am getting a message
> > stating that Fields cannot be used in report headers or footers. I think
> > I
> > can hide it in the report and reference it in the header. But I don't
> > know
> > how to reference an image.
> >
> > Anyone know how to get an image in a header?
>
>

Conditional Group Header

Here is my scenario. I have 3 Groupings, lets say Group A, B, and C.

Group A
Group B
Group C
Detail
Group Footer C
Group Footer B
Group Footer A

Group A and Group B will be starting from new page, but not group C. I am having problems when Group C change values on same page. Like on one page I have

Group A -Header
Group B -Header
Group C (value 1) header
Detail
Group C (value 1) footer
Group C (value 2) header
Page footer
and then on next page, same Group C (value 2) header and then detail. I am not sure how to check like, if Group C (value 2) header does not have detail for it or Group C (value 2) header is followed by page footer then skip that header and put Group C (value 2) header on new page. Could someone please guide me how to code it please.

Please let me know if I could not explain my scanrio properly and I will try to explain it in different way.

Thank you in advance.I think I already answered this on another forum. Please check.

Conditional Display of report Header/footer data

Is visibility of the header/footer regions able to be turned on off
based on some expression?Yes. Select the header or footer whichever you'd like, and find the
Visiblity/Hidden section, choose "expression" from the drop down, or simply
type your expression in the space provided. This will be evaluated at
runtime and set the visibility to its proper state.
Michael
"Weston Weems" wrote:
> Is visibility of the header/footer regions able to be turned on off
> based on some expression?
>

Conditional Colour in Report Header

All,
I need to alter the Header Bar background colour in my report
depending on who the report is being prepared for. For example, client
accounts that start **P need to have a blue background whereas client
accounts that start **A need a red background.
Any help on how to switch the colour conditionally would be greatly
appreciated.
Thanks,
Scott.Just put a formula in the appropriate Color property:
=iif(...)
Cheers,
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"scottf" <scottfuk@.yahoo.co.uk> wrote in message
news:b4349ea7.0411230619.2f1771c7@.posting.google.com...
> All,
> I need to alter the Header Bar background colour in my report
> depending on who the report is being prepared for. For example, client
> accounts that start **P need to have a blue background whereas client
> accounts that start **A need a red background.
> Any help on how to switch the colour conditionally would be greatly
> appreciated.
> Thanks,
> Scott.