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

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

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

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

Hi All, I want to perform Manual QA on "Oracle Views" written by another developer. Please let me know what are the steps for doing manual QA, where to start from and I am using TOAD for Oracle. I never did this before. Please help me out. Thank You mak

Hi, I have a report with customer name field from one database table and date field with null values from a different database table. I want to display only records from last 7 days by grouping on customer name field? Please anybody let me know how to do that. Thanks in advance

Hi Everyone, I am new to the reporting world,please help me out. I would like to know what are the steps involved in creating report specifications? OR When the end-user ask you to build a report what are the questions I should ask him? Thanks!