Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by makk07

  1. makk07

    Report Standards

    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...
  2. makk07

    How to handle null values in formula

    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...
  3. makk07

    Displaying employee no without separator and decimals

    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...
  4. makk07

    How to calculate percentage

    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...
  5. makk07

    Manual Testing

    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!!
  6. makk07

    Technical Support for Oracle 9i Views

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

    Convert varchar to date

    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...
  8. makk07

    Convert varchar to date

    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!
  9. makk07

    Alternate Grey Row Shading in Detail Section

    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
  10. makk07

    Subreport

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

    Tutorial on Arrays

    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
  12. makk07

    How to avoid duplicate records in formula

    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
  13. makk07

    How to avoid duplicate records in formula

    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...
  14. makk07

    Using Arrays to display data from database field

    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...
  15. makk07

    Using Arrays to display data from database field

    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.
See more

Part and Inventory Search

Back
Top