Search results for query: *

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

CRYSTAL VERSION: 8.5 DATABASE : SQL Server I have a report with 3 sub-reports and they are drill down reports. when i drill down on the report heading, it shows on a new preview page but without the report headings (only the drill-down data shows) (My report data-headings are currently in the...

Hi, Am rather new to Crystal and urgently need to do some data selection for financial reporting purposes. 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...

Hi again, I was following some answers you gave to shummy1 on YTD and LYTD and have managed to separate the two columns. Thanks man! But am still having problems.... ====== How do i get the user to specify both the start date(month & year) and end dates. (the start month need not be Jan)...

Thanks Kskid for your comments.. The year starts 1 Sept and runs to 31 August. The report can be run any day ( but i'd prefer to work with end-of-month dates) Am very new to Crystal but my boss doesnt want to pay for training and i must do this thing else am sunk! I got a view that pulls out...

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 view to select the following data Account No, Account Desc, Amounts The SQL view is able to return both income amounts and...