Recent content by kagee

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

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

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

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

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!

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

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

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

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!

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

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

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!

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

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

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