Hi,
In my report, I have used a table. In the table, I want to display all the
duplicate rows in red color, i.e if Field1 is listed twice in the table
details, then I want to display the duplicate row in red color.
ANy ideas on how to achieve this?
Thanks
--
pmudSet the Color property of the textbox of Field1 to use an expression,
like this:
=IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
"Black")
Matt A|||Thanks MattA. This is extremely helpful. :)
--
pmud
"MattA" wrote:
> Set the Color property of the textbox of Field1 to use an expression,
> like this:
> =IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
> "Black")
> Matt A
>|||I was wondering if you can refer to the textbox.value from within a property
like:
=iif(textbox98.value > 0, "green", "red")
--
William Stacey [MVP]
"MattA" <mattarabas@.gmail.com> wrote in message
news:1138312093.490398.115610@.g14g2000cwa.googlegroups.com...
| Set the Color property of the textbox of Field1 to use an expression,
| like this:
|
| =IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
| "Black")
|
| Matt A
||||=IIF(ReportItems!textbox98.Value > 0, "GREEN", "RED")
Note that scope rules apply to ReportItems collection, so you'll have
scope limitations on being able to use it (not on aggregates, for
example...)
Matt A|||Thanks Matt. Are these processing "rules" layed out in BOL or somewhere.
Cheers!
--
William Stacey [MVP]
"MattA" <mattarabas@.gmail.com> wrote in message
news:1138370026.412815.53510@.g44g2000cwa.googlegroups.com...
| =IIF(ReportItems!textbox98.Value > 0, "GREEN", "RED")
|
| Note that scope rules apply to ReportItems collection, so you'll have
| scope limitations on being able to use it (not on aggregates, for
| example...)
|
| Matt A
|
Showing posts with label twice. Show all posts
Showing posts with label twice. Show all posts
Friday, March 9, 2012
Saturday, February 25, 2012
display vocuher report twice with same data on CR 8.5
Hello ,
I need to display a voucher report twice in crystal reports 8.5 . I DONT want to print them on printer but display the same report twice with exactly the same data only with the 'COPY' printed in the 2nd voucher in crystal report.
Pls tell me how to write the formula n in which section.I am new to crystal reports n dont know how to write formulas in such a situation!
Pls help me
I get the following result set from my Stored Proc attached to report.
51 XML Markup Language Active 128 Copy
53 Team-Woodbury Audit Active 128 Copy
55 Team 4 Beebe's Team Active 128 Copy
56 Team 5 Bill's Team Active 128 Copy
51 XML Markup Language Active 128 Original
53 Team-Woodbury Audit Active 128 Original
55 Team 4 Beebe's Team Active 128 Original
56 Team 5 Bill's Team Active 128 Originali want to print twice in single page
I need to display a voucher report twice in crystal reports 8.5 . I DONT want to print them on printer but display the same report twice with exactly the same data only with the 'COPY' printed in the 2nd voucher in crystal report.
Pls tell me how to write the formula n in which section.I am new to crystal reports n dont know how to write formulas in such a situation!
Pls help me
I get the following result set from my Stored Proc attached to report.
51 XML Markup Language Active 128 Copy
53 Team-Woodbury Audit Active 128 Copy
55 Team 4 Beebe's Team Active 128 Copy
56 Team 5 Bill's Team Active 128 Copy
51 XML Markup Language Active 128 Original
53 Team-Woodbury Audit Active 128 Original
55 Team 4 Beebe's Team Active 128 Original
56 Team 5 Bill's Team Active 128 Originali want to print twice in single page
Subscribe to:
Posts (Atom)