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

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

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.

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

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

How do I get CR (8.5) to display the number of records associated to an Nth most frequent value? I've placed the 5 most frequent values of my report in the report footer, I want to display alongside each one of them their corresponding number of records. ie: Most frequent values Number...

Hi everyone, does anybody know hot to get CR 8.5 to display just the last detail of any given group. The data I'm using looks like this: Group header(order number) 21a detail a detail b Group footer count of details=2 Group header(order number) 21b detail a Group footer count of details=1 I...

Hi to all experts... I am working on the following report: GH1: Department GH2: Employee D: Number of transactions completed, time elapsed. GF2: Hidden Displays the following calculated summary field for each employee: @number_of _transactions_per minute=Sum ({TOT_TRAN}, {EMP_ID})/Sum...

Hi, I need to print two reports at once, that is, by providing a parameter value to my first report, I'd like to trigger the printout of a second one. I've heard one of the ways (probably the only one???) to do this is using subreports. Now, I know how to link a subreport to a main report, but...

Hi, I need to know how to use a parameter field to select records based on a related field, here's some sample data and an explanation: We need to print shipping documents whenever our warehouse ships an order , we use the order number as our parameter field to do this. Now, we want to be able...

Hello all, I'm using a date parameter range value in my report, I can let the user pick whatever start date they wish but I need to force the end date to always be TODAY, does anyone know how to do this?? or perharps there's a better approach than using a date range value?? thank you.

Hi all, I have a report on our employee table grouped by department_id where I'm showing employee_id, first, last name and productivity. I need to display at every group footer the highest productivity and the first and last name of the corresponding employee. Displaying the highest productivity...

I need to calculate the difference (in hours) between two dates, I know I can use the datediff function but I think both fields should be in exactly the same format. {field1} is a string and has the following format: "yymmddhhmm" and {field2} is a datetime: #yyyy, mm, dd, hh, mm, ss#...

Does anyone know of a way to have CR (8) display data in a linked subreport even when the main report does not show any records? Basically, what I'm doing is I have a main report and a subreport, they both use the same parameter field and I have this parameter field selected in the "select...

Does anyone know how to use ranges when using the case function in Crystal 8. I can use the case function when I compare {field} to a specific value or if I want to test if {field} is just less than value or greater than value: select {field} case is > value: "something" case value...

Does anyone know a better way to solve the following issue?? I want to able to display the date range value my report is using when printing a copy of the report. I've tried the following: "From: " & Minimum ({?Dates}) & " To: " & Maximum({?Dates}) But I don't think...