Hide and Show Background image dynamically

I am trying to place a background image on a report based on a database
field called watermark. I have not found a way to create an expresion
or code that would allow me to display this background image on some
pages based on the water mark field. Is it possible to do this?I have been working hard to try to figure this out. I would really
appreciate any help. I need to be able to stamp certain pages on a
multiple paged report with a watermark that says "PAST DUE".
Thanks in advance for any help you can give me|||> I have been working hard to try to figure this out. I would really
> appreciate any help. I need to be able to stamp certain pages on a
> multiple paged report with a watermark that says "PAST DUE".
We use an expression in the background image property of the Report Body.
This is how we do it:
=IIF(your condition, "image name", Nothing)
Hope this works for you...
MK

hide a database image when there is no image in database

well i ve an image field in database and then using an image in a
report that is connected with the image database field (carrying image
details in bits) what i want is to hide the image in report when the
image field in database is null (image database field is 0x00 when it
contains NO IMAGE)
i m trying to put following expression in the HIDDEN property of the
IMAGE in the report :
=iif(Fields!image.value=NOTHING,true,false)
but it says that this expression cant b put probably (rather surely)
coz of the datatype of image database field (BIT) so plz help me out
how to do that i ve also tried
iif ( isnothing(Fields!image.value)=NOTHING,true,false)
then it doesnt give error but it always return NON-NULL VALUE (ie
always returns false part of the expression) even the image database
field is EMPTY is (0x00)
how to resolve that issue any suggestion
thanx in advanceHey Spirits,
How about changing your SQL query to something like this:
SELECT imgImage, CASE WHEN imgImage IS NULL THEN 0 ELSE 1 END AS
bitImageExists
FROM tblSomethingImage
And then set the Hidden expression for the image to
"=IIf(Fields!bitImageExists.Value = 1, False, True)"?
Cheers,
-Geoff R G Williams
Primal Blaze Ltd.
"** Spirits **" <muhammadhammad78@.gmail.com> wrote in message
news:1124863203.576215.182520@.g47g2000cwa.googlegroups.com...
> well i ve an image field in database and then using an image in a
> report that is connected with the image database field (carrying image
> details in bits) what i want is to hide the image in report when the
> image field in database is null (image database field is 0x00 when it
> contains NO IMAGE)
> i m trying to put following expression in the HIDDEN property of the
> IMAGE in the report :
> =iif(Fields!image.value=NOTHING,true,false)
> but it says that this expression cant b put probably (rather surely)
> coz of the datatype of image database field (BIT) so plz help me out
> how to do that i ve also tried
> iif ( isnothing(Fields!image.value)=NOTHING,true,false)
> then it doesnt give error but it always return NON-NULL VALUE (ie
> always returns false part of the expression) even the image database
> field is EMPTY is (0x00)
> how to resolve that issue any suggestion
> thanx in advance
>|||geoff thanx for concern actually the solution u provided wont work as
i ve tried that n then i got another solution to my problem n i m
sharing it with u it is as followed
well in sql server there is a function named DATALENGTH(ImageDataField)
and returns no of bytes occupied by the image
u should use this to check how many bytes r of a pic better to make a
calculated field in ur data set
then use this calculated field to hid or show the image in the report
by using the following expression in the HIDDEN property of the IMAGE
=iif(imagelengthfield.value=1,true,false)
when image wont b avaiable ur this calculated field ll return 1
otherwise some bigger value representing bytes of the image
u can further go to restrict data set by using
datalength(imageDatabaseField)>1 to come up in the dataset of the
report with the records having images only
choice is urs
take care
regards

HelpColumnar Report with 3 Groupings?

Hi

I have sales data that needs to be grouped by Company, State and
Date. I would like to format the report as shown in image.

I am using Crystal Reports XI. I am new to Crystal Reports and
would like to find out whether this report is possible using either
columnar format or cross-tab?

Many ThanksPost a sample of your table(s). I can't help without knowing what you have to start with.

I have a feeling you'll need a crosstab|||Hi

I have data in two tables - Sales and Dealers.

Sales
-------
DealerCode
WeekEnding
NumberSold

Dealers
-------
DealerCode
CompanyName
State

I have a command in Crystal as follows:

SELECT d.CompanyName, d.State, s.WeekEnding, s.NumberSold
FROM sales s
LEFT JOIN dealers d
ON s.DealerCode = d.DealerCode
AND s.WeekEnding BETWEEN '2006-04-01' AND '2006-04-30'

I would like to group the data returned by CompanyName, State and Date to get a Total of NumberSold.

I would like to format the report in columns (as in image attachment). I would also like to have a two week total and a week-on-week figure.

If you need any further info, let me know. Thanks for your help!|||Look for cross tab reports in help file