Recent content by makk07

Hi Everyone, At my job my manager ask me to prepare documentation on "Report Design & Coding Standards" for Crystal Reports XI. I mean she ask me to write down the best "report standards" by keeping in mind that reports get published to "Business Objects Enterprise". And these report...

Hi Everyone, 1. I have a formula @LM Reasons in my report, its code is as follows: if {@LM Bonus Reason}<>'' or {@LM PP Reasons}<>'' or {@LM PTO Reason}<>'' then {@LM Bonus Reason} & ', '& {@LM PTO Reason}& ', '& {@LM PP Reasons} else '' i).code for @LM Bonus Reason: if {#LMBonus} > 0...

Hi Everyone, In my database the employee number is stored as follows: 8,367.00 29,785.00 140,742.00 And in the report I have a group based on formula to display employee name and employee number. My formula is as follows: {@Full Name} & ' - ' & {table.EMPLOYEE NO} and in the group tree...

Hi, I have three columns in my report as follows: "Actual Amount" "Budget Amount" "Variance Amout"(this is Actual Amount - Budget Amount) in dollars Now I want the fourth column which should show the percentange difference of Actual Amount and Budget Amount. Please anybody let me...

Hi, Anybody please let me know how to do manual testing of oracle 9i views created for crystal reports XI. I never did this before. Also I am new to oracle database. At my job, crystal reports are created by using oracle 9i views. Thanks!!

Hi Everyone, Anybody please let me know where can I get the technical support for oracle 9i views. Thanks in advance! mak07

I tried this date(left({lrs0186_Command.CUPED},4),mid({lrs0186_Command.CUPED},5,2),right({lrs0186_Command.CUPED},2)) But its giving me the error for the following code: mid({lrs0186_Command.CUPED},5,2),right({lrs0186_Command.CUPED},2) saying "Too many arguements have been given for this...

Hi All, I have a field for date in sql server database which is of datatype varchar and the data in it is in this format 20071031. I am using this field in my report but I want the date in the format 10/31/07. Please anybody suggest me how to do that. Thanks!

HI Everyone, I would like to have an alternate grey row shading in my detail section to make the data easier to read. I am using crystal XI, please help me out. Thanks in advance mak

Hi Everyone, I would like to know "How to keep page header from a subreport?" Thanks!

Hi, I would like to learn Arrays in Crystal Reports XI from scratch. Please anybody let me know the good source or good web site for information on arrays with different examples. Thank You! makk07

Hi, Below is my formula code: Formula:@Display SecType Desc TOTEXT({vtsm_liaison_security_type.security_type_id},0,'') & " " & "-" & " " & {security_type.security_type_desc} security type id is coming from one table and security type desc is coming from another table. Thank You mak

Hello All, I am using CR XI.I have a group on UserGroup Name & security type id columns. My UserGroup Name is in detail section but I suppressed it. And I am using formula to display security type id and description together under SecurityType Desc column. And I placed my formula in...

Please Ignore the earlier code.Sorry to bother you. Here is the updated code in bottom,Please go through it.I really appreciate your help,also I am new to reporting field and I am facing difficulty. Using Arrays I am trying to display usergroup name and security type description from diff...

thanks for your help. I tried doing that but still its not working, do you have anyother suggestion. thanks a lot again.please let me know if you have any other idea.