Search results for query: *

Hi, I am trying to calculate the time elapsed between two events. I have a field in my table that gives me the time at which some event was logged. What I want is to display the time elapsed between that event and the previous one: Event, Date/Time logged, Time elapsed. 1...

Crystal version 11.0 I need to display group values horizontally instead of vertically, I know I can use the section expert and check the “format with multiple columns” option on my details section (which is currently hidden), this plus the "multiple columns format" option allows me to get the...

I found the problem! Your question about whether I was linking by the item field gave the problem away... I guess because I was trying to keep my post from becoming too complex I didn't mention there was another group both on the subreport and the main report (order number). What I did was move...

Sorry I had to leave yesterday....Thank you for staying with me on this one. This is the actual formula: whileprintingrecords; shared numbervar ReturnedQty; ReturnedQty:=Sum ({TRHRETNSTK.QTY}, {TRHRETNSTK.ITM_NUM}) I also tried removing the group condition like you suggested to no avail. I...

Yes, linked on the item number. I tried placing the shared variable formula on the report footer in the subreport but still shows up as 0 on the main one. I also tried removing the group condition like you suggested... still no luck.

No, the other records are correct.

I double checked that I don't have any conditional suppresion... and yes you are correct, the values are showing as 0 (not blank), my mistake.

I inserted a new section below GF1... I then did move the reset formula to GF1b and also copied it to the report header. First record still showing up as blank.

I have a report where I'm passing the value of a shared variable from a subreport to the main report and it's working as expected... almost every time... the only problem I'm seeing is in the very first record of the main report, in this case the shared variable seems to be blank. Here's a...

Great, this worked just fine. Thanks.

That would be: {ORD_NUM} = {?Order} and {SHIP.DATE} = {?DateRange}

Hi... How can I let my users decide which parameter field to use when they run a report? On my report, I have a list of orders that have been shipped out of our warehouse. I want my users to decide how to filter out data, either by a specific order number or by a certain date time range. (I'm...

I have a frame inside a sequential section. I want this frame to be visible when viewing the report, but at the same time to be both invisible AND not take up any space on the page when printed. I have set the 'ShowWhenPrinting' property to False but this only prevents the frame from showing up...

Thank you dboehne, one follow up question, I have added this date control and used now(). However, I think Now() will give me the date and time the report was run, not neccesariily the time when the report was printed. Is there a separate function that can provide the exact datetime of printing?

Hi, I want to display the print date/time whenever a report gets printed. This information should be in an order header section of the report, can anybody help me to do this? thank you.

Thank you all, I finally went with lbass´s solution since it was the one more closely resembling what I wanted the end users to be able to do.

Does anyone know what I need to do in the select expert when I want my end users to be able to choose whether they want to see report data from the last week, last month or current year date ranges. What I currently have in the select expert is a simple statement: {DeliveryDate} in...

Thank you, that did the trick.

I need to be able to select data based on an if then else condition. Like this: If {field1}= certain value then select records where {field2}="A" else select all records How can I incorporate this logic into the select expert? PS: I'm using CR XI and Oracle database.

I have a report that needs to be printed twice on a 8.5x11 paper. I have been able to get CR (8.5) to print the report twice by adding a new section to the only group footer in the report and inserting the same report into this section as a subreport: GH1 d GF1a GF1b My problem is that I...