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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: idehen
  • Content: Threads
  • Order by date
  1. idehen

    Crystal report export to CSV

    Good day, Hoping someone can help. I exported my report from crystal report to CSV format with the headers and all columns coming out right as expected. I have a client platform that says a file must be imported as CSV and the CSV format exported from crystal report seem to fail during import...
  2. idehen

    Highlight matching entries in a column

    Hello, I have a report that has a grouping and the amount is a sum of Amount totals based on this group. What i will like to do is check within the same column if an entry already exist and highlight it in bold or colour. Example: I am grouping by example Stock Name: Stockname: Amazon Shares[...
  3. idehen

    Display Quarter Period Date

    Hi, I am using Crystal 2008 and am trying to display the actual dates used in my record selection. I have a formula used in the record selection run for quarter period as: Formula: If currentdate in Calendar1stQtr Then {CLIENT.VALUATION_DATE} in...
  4. idehen

    Number toword

    Hi All, I am using CR 2008 and i want to convert number to word. Number is 39.4030 and i used a formula 1: called this "Convert units to word" ToWords(truncate({@Units to Sell},0),0)+" point "+ToWords(Val(Right(totext({@Units to Sell}),2)),0) Then Formula 2: called this "Display"...
  5. idehen

    Sum Group Total & Percentage

    Hello Everyone, Need some help please. Using CR 2008 and will like to calculate percentage. Situation: I have the follwoing info Name Value Percentage Joe 20 Ann 50 Prince 10 Total 80 Note that my Total = 80 is a formula because the individual values are...
  6. idehen

    Reverse Calculation

    Hello Everyone, Using: CR XI Example of Actual Data: Grouped at ID Level Id Amt price total 1 220.00 1.205 265.5 2 50.568 1.205 609.93444 3 85.29 1.205 2473.41 Sum total=3348.84444...
  7. idehen

    Rounding & Non Rounding calculation.

    Hello Everyone, Am using CR XI: I have 2 similar fields which has a difference based on rounding issues. such Ref Amount Amount2 A123 23.2555 23.26 B255 15.1233 15.12 C564 20.8955 20.90 Amount is what i...
  8. idehen

    Percentage calculation

    Good Afternoon I am using CR 2008. I have a grand total amount that is calculated based on value from a sub report and value from a main report. However i want to create a percentage of the total sum and not sure how to do this in crystal cos in excel you simply use the $field for fixed data...
  9. idehen

    sum of Non-Supressed Data

    Hi People, am using CR.10. Problem: I have a report where some data are supressed and some are not based on certain condition. e.G Actual Data: Customer Id Name Leave_Date Amount Opening Balance 620.00 1 Joe...
  10. idehen

    Extracting Data from formula field

    CR version: 10 I have a report that displays as: Name Currency Amount John USD EUR GBP 12345.00 5647.00 891.00 Mike USD GBP 1258.21 56.0 Notice that Currency and Amount are showing multiple data on each line. This is because i used a formula to...
  11. idehen

    Value or character search

    Hope you all had a merry xmas and nice holiday. I am using CR10 and want to search using a formula for a character as in the example. Nos Name 12345 ABC 6788 DEF 69885 KLM In this example, what i am trying to get is, where the 4th...
  12. idehen

    Looping process

    I do apolgise if this already looks like what's probably been answered in other post, i just couldn't get any that closely match what i am trying to do. Basically i have my table and fields as: Date Change reason Amount 28/11/2006 Reinstatement 450 27/11/2006...
  13. idehen

    Sum a String or Text to one Row

    Hi, I am using crystal version 10 and have data displaying as: Plan Name Surname Flex1 Flex2 Flex3 ABC Smith GBP ---------------------------------------------------------- ABC Smith SP...
  14. idehen

    Cross Tab and Dates

    Hello, Need some help please. I am using CR 10 and not very familiar with cross tab, however i know it should help with this problem. Problem: I have a table called participant_awards (PA) and a second called award_dates(AD). Each PA is linked to one or more dates in the AD table. I want to...
  15. idehen

    Data calculation or Selection

    Hi Guys, I am using crystal version 10. I have the following information. Grant Date Action Date Status 01/01/2002 01/02/2004 Hold 01/02/2003 01/08/2006 Release 20/08/2003 30/01/2006 Hold 21/09/2004...
  16. idehen

    Formula or If Statement question

    Crystal version - CR10 I am using two tables example Fees and FX/Exchange rates. Fees Table info: ID Date1 Amount Currency Fx/rates 1 01/01/2007 20.24 USD 1.120 2 03/05/2007 10.22 EUR 1.090 3 09/01/2008 50.62...
  17. idehen

    Sum of Group figures

    I am using CR 10 and want to get grand total of figures displayed in a group. Example Group name: IDNos and have fields displayed as: IDNos Date Amount 123 01/01/2007 220 345 01/02/2007 620 678...
  18. idehen

    Passing variable between main and Sub-report.

    Good-day everyone, Just wondering if anyone could assist me with a problem am having. Crystal version - 10 I understand how to pass a variable or data from a sub-report to a main report. However i am having trouble passing multiple lines of date from the sub-report to the main report...
  19. idehen

    Supressing a Blank sub-report section

    Happy new year everyone!! Just wondering if you can help with an issue am having with sub-report. I have 3 subreports in a main report and the subreports are placed in 3 different sections. However, the subreport sometimes returns a data and some other subreports could be blank. I have used...
  20. idehen

    Data replication

    I am using crystal Version 10 and trying to replicate a line of data but with a different Title or name. Example. Type Date Available Amount AB 01/01/2007 21.00 BC 06/10/2007 32.15 Above information are all...

Part and Inventory Search

Back
Top