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 TouchToneTommy 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 kagee

  1. kagee

    Sorting YTD and LYTD values by month

    Hi, Am using Crystal 10 and SQL Server. Each of my reports consist of 3 sub-reports. Problem at Hand How do I group YTD values and LYTD values line-by-line per month irrespective of the year? Current Report Structure: Group1 : ---> Shows overrall total Group2 : ---> shows sum of...
  2. kagee

    Problems with Shared Formulas on Groups...

    Thanks -LB, I got it working by changing to the following (based on your ideas) My Sub-reports formulas are: //for travel IF (GroupName({table.accountDesc})= 'Travelling') then Shared CurrencyVar FINTravel := (Sum({table.Amount},{table.accountDesc})) //for Entertainment IF...
  3. kagee

    Problems with Shared Formulas on Groups...

    Hi Crystal Version: 10 Database: SQL Server. Am having a problem with my shared CurrencyVar Formulas. I have a main report, which summarises values from 7 subreports. The subreports pass data using shared CurrencyVar formulas. The sum of each group in the subreport is meant to be passed as...
  4. kagee

    Displaying headers for subreports

    Crystal Version: 10 Database: MsSQL server I have a main report which summarises values from 3 subreports(all subreports are in the report footer sections) Each of the subreports has a header in the Page Header section and this is displayed on each page (when i run the subreport alone) The...
  5. kagee

    YTD and LYTD formulas give same values

    Thanks guys, i actually discovered that my record selection formula was discarding previous yr records - i modified this plus the 'y' problem and now it works like cheese ... Thanks!
  6. kagee

    YTD and LYTD formulas give same values

    Hi, Am using crystal 10 with SQL server 2000. My sequel view returns all the data i need for both current financial yr and Previous financial yr. (Date, AccountNo, AccountDesc, Amounts) The financial year spans Sept 2004 to August 2005, with reporting being sept 2004 to date Problem @ Hand...
  7. kagee

    Grouping with sum based account

    Hi there, I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, AccountNo, AccountDesc, Amounts. (Data entry is done at...
  8. kagee

    Help with YTD formula

    Hi, I am kinder stuck with some crystal YTD formula, and now seeking help. Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a MS SQL server view to select the following data Date, Account No, Account Desc, Amounts Ps: Currently am using a record selection...
  9. kagee

    Year to date & Last Year to date (spanning over 2 calendar years)

    Tried and cant quite figure it out, any directions (am rather new to Crystal and seriously in need for training though can't afford it) - Forums my only way out .. Pls assist!
  10. kagee

    Year to date & Last Year to date (spanning over 2 calendar years)

    Still not working... all figures from Sept-Dec 2004 show 0 whereas those from Jan-march 05 have the correct values Just wondering; Is there something wrong with the two formulas i am using: YTD AMOUNT if {table.date} in YearToDate and {table.date} <Minimum(MonthToDate) then {table.amount}...
  11. kagee

    Inserting totals from sub reports to main report

    thanks Lbass for your comments, the formula however doesnt work - it says a number is required.. maybe its the use of the variable numbervar.. I still got my summary (main report) in the details section, now its suppressed and my sub reports (each shows on a separate page) on the report...
  12. kagee

    Year to date & Last Year to date (spanning over 2 calendar years)

    Thanks Madawc for the comment, tried the stuff but didnt work - still shows ZEROz for last years values yet the DB had data. Where do i put the code. In the record selection formula or in the formula that i place in the form. Please assist!
  13. kagee

    Inserting totals from sub reports to main report

    Hi there, I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, Account No, Account Desc, Amounts. The SQL view is able to...
  14. kagee

    Year to date & Last Year to date (spanning over 2 calendar years)

    Hi there, Am stuck with a major financial reports and need some technical assistance: Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, Account No, Account Desc, Amounts The SQL view is able to return both income...
  15. kagee

    CRPE32.dll Error when trying to Load report from Delphi

    Hi, Crystal Reports :11 (very similar to 10) Database: SQL Server am trying to load my reports from a Delphi App and when I run the form that's supposed to call my reports it gives the the following error: Error:104 Failed to obtain version information from CRPE32.DLL - getCrpeVersion Windows...

Part and Inventory Search

Back
Top