Search results for query: *

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.

hi everyone, I am using crystal reports XI and I am displaying the usergroup name from usergroup field in the database using arrays. I created two formulas in subreport: formula 1: To Initialize arrays formula 2: To store values into an array And in main report,I have created...

Hi Everyone, I am using Crystal Reports XI and I want to create an array of 5000+ elements,and I know there is a limitation of 1000 elements in crystal reports. Its urgent,please suggest how to do that. Please help me out. Thanks in advance

Hi Everyone, How to write a SQL command for a crystal report for retrieving records only for last 7 days from a SQL Server database. I am using crystal reports XI.Please help me out, I am new to reporting world also its urgent. Thanks in advance for help mak

Hi Everyone, How to write a SQL command for a crystal report for retrieving records only for last 7 days from a SQL Server database. I am using crystal reports XI. Thanks in advance for help mak

I want to check wheather the view is returning the correct records or not. Also I have never used TOAD before.