Search results for query: *

Thanks for the answers, although some of you has misunderstod what I was after... The question wasn't how to select rows between for example "2001-01-01 08:00:00" and "2001-01-31 17:00:00" but how to select rows between "2001-01-01" and "2001-01-31&quot...

Hi, My problem/question is this: I want to select the rows that has a date that's within office-hours i e I both want to say that I want the rows that has a date between two dates but also that it should be between 08 and 17 every day. I came up with this (see select statement below), and it...

Hi, I have a question that many of you must have come across some time. I have at table that contains an id, date and some other columns not relevant to the question. What I want is to get the row with the latest date. It's easy to get the max(date) just by: select max(date) from table but...

Thanks for the suggestion, but I have tried that already... Still doesn't use the index. /Pejo

It actually looks something like the select-statement that I posted first. There are of course other tables and statements that I didn't write but they don't make a difference (when it comes to the problem with the index). If I remove all those other tables and statements the explain plan still...

Ok. So how will I know if this is the reason why the index isn't used? And, more important, what can I do to avoid it? /PeJo

Thanks for your reply. Unfortunatly your suggestions isn't helping much. 1) This can't be it as the table has 31 columns and it must be faster to use an index than to load the whole table into memory... 2) I have analyzed the table but the result is still the same. 3) I'm not really using...

I have a pretty big table that among many other columns has a date-column that I have indexed. When I try to run a select-statement that selects records within a date-range the index isn't used and a full table scan is made instead, which means that the select takes very long time to run. The...

Hi, I have a report that is grouped by client and datetime and looks something like this Client A 2001-01-01 08:00 10% (1/10) 2001-01-01 09:00 20% (2/10) 2001-01-01 10:00 50% (4/8) Client B 2001-01-01 08:00 25% (1/4) 2001-01-01 09:00 33% (3/9) 2001-01-01 10:00 20% (12/60) ...

Hi, I need to create a chart that has both bars and lines, ie a mix of line chart and bar chart, but I can't seem to do that in Crystal. Does anybody know how to do that? /PeJo

So how did you do it? I tried to create a new, simple report that has a subreport in the detail section and uses shared variables to display it in the group section of the main report. That works. Then I suppressed the detail section and got zero in my shared variables! Same result if I...

I have a report that uses a subreport to get a value that I need to calculate some averages. I use shared variables to get the result from the subreport to the main report and that works fine. The main report has 3 group sections that summarizes the values from the detail section and the detail...

When you use a stored procedure with Crystal Reports the stored procedure has to return a ref cursor and yours is not returning anything! Also you shouldn't open and loop through the cursor but instead do like this: "OPEN out_cursor FOR SELECT main.ps_id from str.main where main.ps_id =...

Thanks for the answer, but the problem still remains as I don't have a Selection formula because the report is based on a stored procedure. Even if I add one I still don't get anything in my subreport. I think the selection formula is run AFTER the stored procedure and then it's kind of too...

I have a report based on a stored procedure (Oracle 8i and CR 8.5) that has 5 parameters. It works fine. Now I want to add a subreport based on the same stored procedure (with the same parameters of course). When I try to link the subreport to the main report it gets problematic. In the...