CAN SOMEONE HELP ME CREATE A DATE FIELD IN A WEB PAGE THAT AUTOMATICALLY UPDATES EVERY 2 WEEKS? FOR INSTANCE, WHEN THE WEB PAGE IS ACCESSED, IT WILL SHOW WHAT WAS THE ORIGINAL DATE OF 08/12/2016 (NOT NECESSARILY IN THIS FORMAT) TO BE 08/26/2016 BUT ON OR AFTER 08/26/2016, THE DATE CHANGES TO...
briangriffin APPRECIATE YOUR IMMEDIATE REPLY BUT I NEED TO COMPARE THE DATA IN EACH SUBREPORT WITHIN THE CRYSTAL REPORT WHICH WILL THEN GIVE ME A REPORT OF THE DATA THAT MATCHES AND A REPORT OF THE DATA THAT DOES NOT MATCH. ANYWAY, THANKS AGAIN FOR YOUR SUGGESTION.
HELLO FELLOW CRYSTAL REPORTS PROGRAMMERS. DOES ANYONE KNOW HOW TO COMPARE DATA IN ONE SUBREPORT TO ANOTHER ONE? FOR INSTANCE, CHECK TO SEE IF A LINE OF DATA IS IN ONE SUBREPORT AND IF A LINE OF DATA IS IN ANOTHER SUBREPORT AND VICE VERSA? ANY HELP OR SUGGESTIONS WOULD BE VERY MUCH APPRECIATED.
MADE ANOTHER MISTAKE BUT LAST TIME. ANYWAY, THE CORRECT CODE IS BELOW.
if ({?Code} = "F" and {?Product} = "T35") then SUPPRESS
else
if ({?Code} = "F" and {?Product} <> "T35") then SUPPRESS
else
if ({?Code} <> "F" and {?Product} = "T35") then DO NOT SUPPRESS
else
if (?Code} <> "F" and {?Product}...
I WAS WRONG. THE 2 LINES OF CODE THAT I GAVE DO NOT SUPPRESS PROPERLY IF {?Product} <> "T35" AND {?Code} <> "F" HOWEVER THE CODE BELOW WORKS GREAT. THANKS AGAIN EVERYBODY FOR ALL YOUR HELP.
if ({?Code} = "F" and {?Product} = "T35") then SUPPRESS
else
if ({?Code} = "F" and {?Product} <> "T35")...
THIS THREAD IS CLOSED. THANKS TO THE TIPS FROM ALL OF YOU WAS ABLE TO JUST USE THE CODE BELOW TO SUPPRESS MY TEXT OBJECT WHEN IT NEEDED OR DID NOT NEED TO BE SUPPRESSED.
if {?Product} = "T35" then FALSE;
if {?Code} = "F" then TRUE;
APOLOGIZE FOR NOT BEING CLEAR. HOWEVER IN ANSWER TO pmax9999:
1. {?Code} = "F" and {?Product} = "T35" *** SUPPRESS TEXT OBJECT BECAUSE {?Code} = "F"
2. {?Code} = "F" and {?Product} <> "T35" *** SUPPRESS TEXT OBJECT BECAUSE {?Code} = "F"
3. {?Code} <> "F" and {?Product} = "T35" *** DO NOT...
EXCELLENT SUGGESTION HOWEVER I NEED TO BE MORE SPECIFIC. IF {?Code} = "F" THEN THE TEXT OBJECT IS SUPPRESSED REGARDLESS IF Product} = "T35" BUT IF {?Code} <> "F" AND Product} = "T35" THEN THE TEXT OBJECT SHOULD NOT BE SUPPRESSED.
THANKS SO MUCH FOR YOUR PROMPT RESPONSE. THE {?Code} = "F" IS A GREAT IDEA HOWEVER I NEED TO NOT SUPPRESS THE TEXT OBJECT IF {?Product} = "T35". SOMETIMES BOTH PARAMETERS ARE {?Product} = "T35" AND {?Code} = "F" AT THE SAME TIME.
NEED TO SUPPRESS A TEXT OBJECT DEPENDING ON 2 PARAMETER FIELDS. IF {?Product} = "T35" THEN DO NOT SUPPRESS BUT IF {?Code} = "F" THEN SUPPRESS. TRIED USING THE FORMULA BELOW IN FORMAT EDITOR CLICKING THE X-2 BUTTON LEAVING THE SUPPRESS CHECKBOX UNCHECKED IN THE COMMON TAB BUT WILL NOT WORK IF...
Appreciate your immediate reply. I am using CR 2011 however it only does it if i use the Group Name Field in the Group Footer but when i used a Database Field in the Group Footer, the date format did not change so i was able to solve my problem. Still, thanks again for your response. This thread...
Have a problem with the data format in a Group Footer. The date is supposed to be YYY-MM-DD in the Group Footer total but when it is the first line in a next page, it changes to M/DD/YYY as shown below:
HEADING
PH =======
-----------------------
GF1 Total for 6/30/2004
GH Example...
kray4660, the only reason your formula didn't work was because I'm now using the GF for yearly calculations so I need the Detail to show all the records which some columns have more than one record. Should have said that each column is really a monthly column so I have 12 columns for each month...
Appreciate your help but think i didn't make myself clear. I need the records in the report to all be in the same line but in their own columns:
From This:
GH (suppressed)
(Column1)(Column2)(Column3)(Column4)(Column5)
D XX:123
D ........ ZZ:345
D ................. YY:567
D...
Still no luck with this so if anyone can help me, i'd really appreciate. The fields can be referenced as {col1}, {col2}, {col3}, etc. and they are all VarChar.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.