Search results for query: *

Hi, I figured it out. In command, the query syntax should work for your database. Since my report runs against Oracle database, so I do the following and it works. register_date between TRUNC(sysDate,'YEAR') and sysDate Hope that will help anyone who has the same issue. Thanks!

I have a report that needs to be ran by schedule. So I need to set the time range to the first date of the year to the current date in Command. Here is what I am doing, but does not work in command: register_date between date(year(currentdate),1,1) and sysdate date(year(currentdate),1,1) works...

Dell, Thank you!! I did pre-define the record type for the result set in a package. Maybe I should try using Package instead of Stored Procedure. The way that I am doing is a work around method, I want to surely solve this problem. Thank you for the idea.

Dell, Thank very much!! I have tried to run the SP separately in TOAD, from sqlplus. All worked fine, only when it works with Crystal Report Server, the report failed to retrieve data. Inside of the Stored Procedure, it called other two Stored Procedure to get values, looks like that makes...

Hi, I changed the default value for the parameter "startDate" to "1/1/1900", but the report still failed to run. The error is "Can't retrieve data from database. Database Vendor Code: 20102". Is there anyone know what this error mean? I google it but have no idea what that means when it is in...

kray4660, Dell, thank you so much for the reply!! Dell, thanks a lot!! You are right. The null can't be passed from Crystal Server into SP. But in CMS, there is a option in Prompt setting to let users set the value to null (set to null) which is really misleading.Since I haven't worked on CR...

Hi, I am not quire sure which Crystal Report forum I should post my questions. I haven't worked on Crystal Report for a while. Recently I have a Crystal Report which is created from Crystal Report 11 and set in SAP BusinessObjects BI Platform 4.1 Support Pack 3 Version: 14.1.3.1257. The...

Hi, I am a general excel user, rarely use formula or functions. Now I need create a drop down list in my spread sheet, when the user select one from the list, a value is set on the cell (what are listed are not the values set in the cell). For example, the drop down list list all the states...

Hi, I figured it out. This is how I do it: =Switch ( Fields!APPTIME.Value > 0 AND Fields!APPTIME.Value < 1000,Left(Fields!APPTIME.Value,1)+":"+Right(Fields!APPTIME.Value,2) + "am", Fields!APPTIME.Value > 1000 AND...

Hi All, I have a field which suppose should store time, but instead they all are integers. For example, 1400 is 2:00 pm, 1100 is 11:00 am, 930 is 9:30 am,etc. Now in my report, I need to display them as Time. How can I display 1100 as 11:00 am, 1400 as 2:00 pm. I tried to use Text Box...

Hi All, I need to select data from a table, process them, then insert into a new table. When I just select, I used case to process the data, and found out that is not working the way I expected. I select ID which is the key, the records are group by ID. Each field might have two values, one is...

Dan, Thank you so much for your response!! You are right, the way I tried to get the quarter day is not the efficient way to do it.The report was ran for a year which was set in the report before, and I was asked to modify it to let users select the year to run. Now I use DATEADD() to do it...

Hi All, I need add a parameter which it is the year into the report, then pass it to a stored procedure, then sp passes it to a function. In the function, base on the Year user selects, for example, Year 2014, value is 14, the set up the start date and end date for each quarter (the company's...

Hi imex, Thank you for the information!! I created a table variable and insert all select into it, then select from the table variable and sum the field.

Hi All, I need a total amounts from a column which is also sum of other columns. How can I do it? select sum(coalesce(payment1,payment2)) payment from mytable1 t1 left join mytabel2 t2 on ti.id1=t2.id1 where ... group by .. Now I need total of payment, how can I do it? Thank you so much for...

Thanks George!! Yeah, I checked it and found out the differences.

Hi George, Thank you so much!!! It works perfectly.

Hi All, I left join two tables, need keep all the records in first table, but also need check the the date field in second table if the date field is not null. Since some records in first table are not in the second table,those records have no date field, when I check the date field, those...

Hi Madawc, Thank you so much for your response!! I just remember that I had similar situation before, and got helps from this forum. I create a running total and use formula in Evaluate, then insert running total to the Provider group footer. it is working. Again, thank you!

Hi, I have a report that checks if providers review the patient medications in certain visits. The first group in the report is provider, second group is patient, and third group is visit. In each visit, the report compare the number of reviewed medications with the active medications that...