Search results for query: *

I've found the answer. Once again thanks guys!!

Brilliant!! It all works fantastically except like you say when I have nulls for some of my shared variables. How did I have resets for any shared variables which may be null?

Thanks. I still have a problem though. When I run the report the total section just displays the last values from the Income and Revenue columns. I forgot to add that the subreport has the following layout: GF2 Sum({Contract.c_Revenue}) Sum({Contract.c_Income}) RFa sharedRevenue sharedIncome...

It is a little vague. Main report consists of the following columns Region ContractNo Revenue Income Revenue Income Revenue Income where the first Revenue and Income columns are for the required month, the second and third Revenue Income columms are for the previous months. The report needs...

I have a report which contains 3 subreports which are the same subreport. My main report contains 3 subreport objects which refer to the same subreport. For example I have Reg Con A B C D A B C D A B C D 1 2 1 1 1 1 2 2 2 2 3 3 3 3 4 5 4 4 4 4 5 5 5...

Thanks for that. I realised this when I tried to export from Crystal Reports itself to csv. Crystal Reports needed to install some extra bits and pieces and now everything works as expected.

I have a report which needs to be run via a webpage. I have used the export sample that comes with the crystal reports developers guide (CS_Web_RDObjMod_Export) as a basis to write my own export functions. The problem I am having is intermittent. By that I mean I can export to several format...

wahey!!!! Cheers ;-)

Thanks for that... How do you exactly 'Select the links and change them'? As I can see, you can only link them one way and thats by dragging and dropping. How do you change the sql generated from an INNER JOIN to LEFT JOIN?

In my report I want to join two tables Contracts and Turnover. When I use Database Expert and join the fields, the generated sql produces an INNER JOIN instead of the LEFT JOIN I wanted. Two tables are joined on region, contract, period and year. The generated SQL is SELECT Crt.year...

Sample data is as follows: Table Contracts id region contract period year dispute income 1 100 401 2 2006 200.00 100.00 2 100 501 2 2006 100.00 50.00 3 100 401 2 2006 100.00 50.00 Table Turnover id region contract period year turnover...

I have two tables called summary and turnover which has a many to one relationship. The joins are based on region, contract, period and year. In my report I have grouped by region and contract. I am summing some fields and displaying them in the GF and RF of the report page. My problem is I...

Sorted.

Hi, I have an accounts report which has two columns called Dispute and Income. These two report columns refer to one singe database field called incomevalue (numeric(18,2) field). The report is grouped by region and contract and I need to sum up all the negative incomevalues and show them under...