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!

  • Congratulations strongm 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: vj135
  • Order by date
  1. vj135

    formula for cross tab

    hi, Scenario; I have a database full of warranty info for furniture in a company. How do i create a formula where it shows all(COUNT)for the furniture that the warranty info does NOT exist. Secondly, all the warranty info for the furniture that has expired and that will expire within the...
  2. vj135

    percentage change possible in cross tab report?

    when i try to preview it says the ) is missing and highlights 2007
  3. vj135

    percentage change possible in cross tab report?

    I tried again -- but still the same error message. error says "the forumula result must be a boolean" I am praying you will see this today and give advise on this error. thanks very much vj
  4. vj135

    percentage change possible in cross tab report?

    i still get an error saying: the forumula result must be a boolean please advise need this report badly to be able to show tomorrow thanks
  5. vj135

    percentage change possible in cross tab report?

    when i do the last part whileprintingrecords; currencyvar yr2006; currencyvar yr2006; totext((yr2007-yr2006)%yr2006,2)+"%"//for 2 decimals it gives me an error saying the ) is missing and when i click NO it higlights yr2007 any thoughts thansk
  6. vj135

    percentage change possible in cross tab report?

    I have created the report as cross tab -- and everything looks great except for the % change. all i want is % change instead of / or in addition to the total thanks very very much
  7. vj135

    percentage change possible in cross tab report?

    1)This is my report 2)Where i work the fiscal year starts from Sep of a year to august of the next year. So i created a column in the excel sheet with the heading "Report year" and labelled each row Sep 2005 - Aug 2006. Also i labelled Sep 2006 - Aug 2007. 3) no the database fields don't have...
  8. vj135

    percentage change possible in cross tab report?

    if year ({'Terms_Sep_2005_Aug_2007_'.Report Year}) = Sep 2005-Aug 2006 then 1 I am still getting an error. the error says a number, boolean etc is expected here. I am using the formula workshop thnaks
  9. vj135

    percentage change possible in cross tab report?

    when i do that it says the )is missing
  10. vj135

    percentage change possible in cross tab report?

    when i try to save the formula before it says the keyword "then " is missing if year {'Terms_Sep_2005_Aug_2007_'.Report Year} = 2006 then 1
  11. vj135

    percentage change possible in cross tab report?

    hi, in the left hand side(rows) of a cross tab report i have listed all the reasons for employees leaving the company. in the column i have In-voluntary termination, Underneath it i have 2 small columns one called 2005 and the other 2006. now in the total of the cross tab on each row i want...
  12. vj135

    problems with opening an EXCEL file with crystal -- password protected

    hi , I am having trouble opening a password protected excel sheet via Crystal XI. The error i am getting is some error code, cannot decrypt file etc even when putting the right password any suggestions anyone? thanks
  13. vj135

    urgent how to get a report header in cross tab report pag 2

    EXCELLENT -- it worked! thanks very very much vj
  14. vj135

    Parameters --- reqesting ALL experts attention -- please

    Parameters: 3 parameters Parameter 1 ---- LOCATIONS (many) parameter 2 ---- BUSINESS UNITS(many) paramter 3 ---- DATE Problems: Not all locations have all business units. FOr illustration i will choose TeXAS as a location When i choose parameter 1 (location) the drop-down list shows...
  15. vj135

    urgent how to get a report header in cross tab report pag 2

    RH a contains a graph and RH b contains the cross tab report. Both RH a and RH b contain company titles and other small info objects.
  16. vj135

    urgent how to get a report header in cross tab report pag 2

    The cross tab as well as the objects i want repeated are both in report header (RH b).

Part and Inventory Search

Back
Top