Search results for query: *

two formulas if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 and len(trim({'Administrative_Action_Report_'.Sanctions: Sanction})) = 8 then 1 if instr ({'Administrative_Action_Report_'.Sanctions: Sanction},"Dismissal")>0 and...

beat me to it Ken.. Im not sure I would have thought to ask but I was wondering what the query looked like. _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

Are you using a record select formula? if so, please show it _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

Do you have multiple tables? Are they linked correctly? _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

Trying to understand your issue... If you group by #1 Customer and #2 Transaction then drop the department field from your data table in the detail section are you saying they ALL show XYZ? _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

ok i see that was a little unclear .. my apology Create a new formula called xyz (or whatever you want to call it If {yourdeptfieldfromtable} = "XYZ" then 1 else 0 Create another formula if sum({@xzy},{fieldgroupedon}) >0 then "Text of the note you want to add" else ""...

Do you have groups in this report? Maybe for customer? If so change the formula you are using to If {yourfield} = "XYZ" then 1 else 0 Then create a formula similar to this and place in the group header or footer if sum({yourfield},{fieldgroupedon}) >0 then "Text of the note you want to add"...

I dont have data to test against but maybe this would work if you need to find ranges other than 0 through 99. otherwise the above will work without the VAL split({CLAIM_DIAGS_VS.DIAG},".")[1] = "A40" and val(split({CLAIM_DIAGS_VS.DIAG},".")[2]) in [50 to 99]...

not sure hwy the VAL is being used. try without it {CLAIM_DIAGS_VS.DIAG} startswith "A40." _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

{bt_images.img_desc} like "* "+{?Image Desc}+" *" Note the additional spaces _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

You should rethink that .. what if you run the report tomorrow? Will you have to manually change it to Currentdate-3? maybe this will work on the third line {table.CreatedDate} = maximum(LastFullWeek)+1 and {table.CreatedTime} < "070000") you would need to change the first line accordingly...

I stand corrected! Thanks for keeping me straight Ken. It absolutely is in CR XI _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

CurrentFieldValue is not available in CR XI so if you aren't in the market to upgrade I believe you are stuck with the field name unfortunately _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

another interesting option. This will also account for measurements without inches ex.. 6' numbervar feet := val(split({@field},"'")[1]); numbervar inches := if instr(split({@field},"'")[2],"""") > 0 then val(split(split({@field},"'")[2],"""")[1]) else 0; (feet*12) + inches...

another option.. untested and hoping i got all my ()'s correct {TABLE.DATEFIELD} in {?DATE Parameter} to dateadd('d',7,{?DATE Parameter} or {TABLE.DATEFIELD} in dateadd('yyyy',1,{?DATE Parameter}) to dateadd('yyyy',1,dateadd('d',7,{?DATE Parameter}) or {TABLE.DATEFIELD} in...

Can you explain what sort of errors or issues you are seeing? And just to get an idea of your CR experience level where are you entering your SQL statement in CR? _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

use the code Charliy gave above with a slight modification to create a formula called prodcodesel if {table.product_code} IN ['5001', '5005', '5010', '5015'] then 1 else 0 //fix if numeric in GROUP selection formula (not record selection) sum({@prodcodesel},{yourtranscodefield}) > 0...

{148_vwArbordeckCP.Name} like {?My Parameter - Name} and {148_vwArbordeckCP.ProductCode} = {?My Parameter - ProductCode} _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

just quickly looking at your post you should have a , between zA _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

Each formula or database field has an object name assigned. (right click field>format field>common Tab>Object Name) Does anyone know if the text in that box is accessible in a formula? _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection