Search results for query: *

I am building a high level report, showing total figures per client for all stocks. I need help to show the total of profits on disposals. My Excel spreadsheet is as follows: Client Details Stock Net Charges Smith Purchase AAA 10000.00 Smith Sold AAA -15000.00 Smith Purchase BBB...

I have 6 formulas in my Details section. I have a Summary on each formula in my Footer section. I now need a Sum of 4 of the formulas and another Sum of the remaining 2 formulas. However, when I try to Insert a Summary I can only select one field to Summarise, not four. Is there a...

Hi everyone I am using Crystal Reports XI, and my database is an Excel spreadsheet. I am able to pick up data from all columns, except one. In Excel it contains the numerical value of 'Interest Received'. However, CR is identifying it as a string data type, instead of a number, and when I...

Hello Can I start by thanking all of you for your help and support in 2006 and wish you well in 2007. I am using Crystal XI and am using an excel spreadsheet as my database. I am creating a high level report to show totals. It is grouped by Client. Each row on the spreadsheet has various...

How do I get data from two Excel worksheets I need the curr_price from tblPrice when a record is selected from tblDay. I have linked them in the Database Editor with the field 'Stock' which is on both worksheets. I am using the following formula to pick up the current price: if...

I am getting the majority of my data from one worksheet, however, I need 1 field from another worksheet. My data is grouped by Client ({tbl.Client}&", "&{tbl.Initials}) then by Stock {tbl.Stock}. The data looks like this in the report: Bloggs,J Date______Stock_____________Holding____Price...

I am getting the majority of my data from one worksheet, however, I need 1 field from another worksheet. My data is grouped by Client ({tbl.Client}&", "&{tbl.Initials}) then by Stock {tbl.Stock}. The data looks like this in the report: Bloggs,J Date______Stock_____________Holding____Price...

Dear All I need your help. My source is an Excel spreadsheet and am using Crystal Reports XI. My report is grouped as follows: Group 1: client name Group 2: stock I have set up a formula field to sum the Net+/-Charges for each group of Stock for each client (@SubTotal Net +/- Charges)...

Example spreadsheet: Details Stock Comment Purchase AAA Need this row Sold AAA Need this row Purchase BBB Do not need this row Purchase CCC Need this row Sold CCC Need this row Sold DDD Need this row Dividend AAA Do not...

Example spreadsheet: Details Stock Comment Purchase AAA Need this row Sold AAA Need this row Purchase BBB Do not need this row Purchase CCC Need this row Sold CCC Need this row Sold DDD Need this row Dividend AAA...