Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Ankit Agarwal
1.8k
379
234.5k
How to set conditional formatting in crystal report?
Jul 30 2018 2:39 AM
Hello,
How will be set conditional formatting in Crystal Report according to Database column value.
My Database table data:-
select Id,OutputFormat from FormatSample
Result
Id OutputFormat
1 WordStyle=Normal,BgColor=White,TextColor=Black,Font=Vodafone Lt,FontSize=11,MergeCount=10,MergeStartPosition=2
2WordStyle=Normal,BgColor=LightGreen,TextColor=Black,Font=Vodafone Lt,FontSize=11
3WordStyle=Bold,BgColor=Red,TextColor=White,Font=Vodafone Rg,FontSize=18,MergeCount=10,MergeStartPosition=2
4WordStyle=Normal,BgColor=White,TextColor=Black,Font=Vodafone Lt,FontSize=11,MergeCount=5,MergeStartPosition=2
or please suggest me best way for complete this task.
Please help me, how can we achieve this task?
I have tried this code but its getting error:-
local stringvar array x:= Split({FormatSample.OutputFormat},",");
Local numberVar i;
Local numberVar k;
Local stringVar array outputString := "";
Local stringVar BgColor;
For i:=1 to Count(x) do
(
outputString := outputString + x[i];
for k:=1 to Count(outputString) do
(
Local stringVar array Keyvalue := Split((outputString[k]),"=");
if Keyvalue[0]=BgColor then
if Keyvalue[1]="Red" then
crRed
);
);
error:- A number or currency amount is required.
Thanks in Advance.
Reply
Answers (
2
)
Rdlc Reporting direct print without print preview
SCCM, Powershell, VB script