Search results for query: *

Hi, Im using CR V10 on a BW environment. Our users need to have the possibility to change some of the data in their report (like adding or substacting an amount to the one displayed) untill the last minute, which they can easily do now with excel (Bex), but not with Crystal or any other...

Hi I'm using CR8.5 I have a report which lists the people who created and then financed a contract. ex : Contract 1 Paul 08/05/2003 creation John 09/05/2003 financing Normally it shouldn't be the same person who does it, so I only want to identify the contracts where the same...

Hi Synapsevampire Thanks for replying but I did that already, and it makes my report display the lowest date but it does it for every group. In my report I only want to see the lowest date of the action, whoever did it. Ex : Paul creates contract1 on 06/02, and then Mike enters some new data on...

Hi I'm using CR 8.5 I have a pb with a report which I want to show only the data corresponding to the lowest date. ex : I have 2 groups of employees, who did an action on a contract at a certain date. I only want to see the first action done (ie at the minimum date) It works well untill I create...

Hi I'm using CR 8.5 I'm trying to do a sum of a field (sum by contract), but as the field is repeated several times in my report my sum is wrong as it counts all the times the field is displayed example Contract ID Field1 Field2 1 250 5 1 250 8...

Hi, I'm using Crystal 8.0, and I have a problem with a shared variable (date format). I'm creating it in a subreport, so that I can get it in the main report. It works fine, though in the main report it doesn't seem to be recognized as a date in the main report, as when I try do do a select...

Thanks very much to all of you guys, synapsevampire's solution worked very well Cheers Oona

Hi I'm using CR 8.0 I have a report with several subreports and I would like it to show me values included in a date range. The values should be within yesterday 5.00 pm and today 5.00 pm. I think I need a parameter to do this, but how? I've created 2 variables to get the begin and end dates...

Thanks very much Naith, it works! Oona

Hi I'm using CR8 I created a variable I named @yesterday: datevar yesterday; yesterday := (currentdate-1) I'd like to turn this variable into a Datetime variable that would give me yesterday's date AND time and the time should be 5pm all the time. I tried various types of formulas, such as...

Thanks very much Ken it's working fine now Oona

Hi I'm using cr 8 I have a report based on one group, which is quite long (about 3 pages) I would like the group header section to repeat on top of every page so that the user doesn't have to flip pages back and forth to see Group header info. But it doesn't work, it only repeats when a new...

HI I'm using CR8 I have a report to which a query is linked. When I refresh the main report the query doesn't display the most up to date records. I can't get to update the query data either. I have unchecked Save data with report but it doesn't change anything Any idea?

Well I've put everything that was in the detail sections in the footer sections and it seems to work fine now... Thanks very much!

Hi I'm using CR 8 I have several detail sections (8) group by contract_ID, and for some of these contracts, some of the detail sections repeat themselves after the last section. It's like header detail a detail b detail ... detail h detail a detail b etc.. while I want it to stop after h and...

Thanks Naith, I checked the links which seemed OK and tried the group soution which works very well Thanks again

Hi I'm using CR 8.5 I have a problem with a selection which gives me too many records, something like: Result 1. Product name Price Rebate Assistance 2.00 0 % Assistance 2.00 0 % Assistance 2.00 0 % Assistance 2.00 0 % Insurance 3.00 4 % Insurance 3.00 4 % Insurance 3.00 4 %...

Hi, I'm using CR 8.0. I'd like to get a formula that would allow me to get the following result: "01.01.2001 to 12.31.2001" if the report is published in 2002. Basically I need last year dates, always first day to last day. How can I do this? It's a bit different from year to date...

Thanks but I think it should be a formula as the selection expert is not enough as it gives me more records than I should have. I've seen some kind of formula with 'record selection' and thought something like that could work, any idea about the syntax of this formula? Cheers

Hi , I' d like to know if it's possible to do a selection of datas in a formula, like we can do in a report. I need to see a date (named dt_op)that corresponds to a specific event (named id_fin). the problem is that the date can correspond to other events. How can I just see the date which...