Search results for query: *

We are on CE10, CR10 and Oracle10g. Database for CE is MSDE. All of our reports are called on demand from within the application. There is no scheduling of reports. Is there a way to find out how many times a particular report was run?

I would like to add the subreport and get the descriptions. Should I add a parameter in the subreport which is also a multivalued parameter. And then link the parameter (multi values) from main report to the parameter (multi values) in the subreport. How does this work? How is it passing 1 by 1...

I am using CR XI and Oracle 10g. I have a multiple value parameters which has value as a number. I need the descriptions for the parameter selected. I have the descriptions in another table which is in report also. The problem is how to get the descriptions for the particular parameter value...

Thanks for your reply. If I create 2 (or 3 or 4) parameters how will I specify that when >1000 then move to 2nd parameter? and so forth?

Hello We are on CR10, CE10 and Oracle 10g. We have a custom app (java) which uses the sdk to call the reports from CE10. I have a report which has one parameter. If I pass 100 values to this parameter the report runs fine from the app but if I pass 1000 or more value then this report fails...

Sorry abt the confusion. I want all the days in a month and if the leave is taken on any of the days (using begin and end date) then use the leave type to determine the color of hours taken. so page header will look like 11/01, 11/02, 11/03, 11/04 etc. That 40 should be 32 hours of leaves taken...

Hello, I have a table which has emp_id, begin_date, end_date, leave_type, hours_taken. The values are emp_id begin_date end_date leave_type, hours_taken 1 11/02/2006 AL 8 1 11/05/2006 11/08/2006 SL 40 1 11/15/2006...

I have a formula in crystal report {LEAVES_APPROVAL.MONTH_YEAR} = switch ( {?EnterMonth}="Previous","0"+ToText(Month(CurrentDate)-1)+ToText(Year(CurrentDate)) ) and {LEAVES_APPROVAL.DEPT} = "Fiscal" If the value of parameter is "Previous" then it selects the data for the previous month...

For Ex - I want the report between 2nd Qtr of 2003 to 1st qtr of 2004. So report should display 2,3,4 qtr of 2003 and 1st qtr of 2004. if I say ({table.quarter} >= 2 and {table.year} >= 2003) and ({table.quarter} <= 1 and {table.year} <= 2004) Then nothing is reutrned as I have contradiction...

CR10, Oracle 10g(native connection). Example data from the database- Qtr year value 1 2002 Traffic 2 2002 Mis 3 2002 Speed 1 2002 Traffic 2 2003 Mis 3 2003 Speed Expected Output - 1stQtr of 2002 2ndQtr'2002 3rdQtr'2002...

I do have quarters in the database. The user are selecting the start and end quarter and year. I want to dynamically create the quarters between the parameters and display it in report (whatever can fit on a page landscape mode). I am using CR10. Thanks,

I have a report in which user inputs the start quarter,start year,end quarter and end year. I want in the report to dynamically display all the quarters that fall between the selected parameters. For ex if user selected 2 qtr of 2002 to 3rd qtr of 2004 then the report should display 2,3,4 of...

Is there a way to export the reports from the Crystal Enterprise 10 and save them to my local hard disk. Thanks.

I think you will have to use manual running total for this.

it can be done like this. Create a formula and place it in details section (or where ever you want to evaluate the values) - WhilePrintingRecords; StringVar old_val := ' '; StringVar new_val := ' '; if old_dept = new_dept then ' ' else old_val := old_dept; new_val := new_dept...

you can add 10 days to your start date and get a second date. Then you can use the DateDiff Formula. Thanks,

May be this will help - Local DateTimeVar d1 := {Orders.Order Date}; Local DateTimeVar d2 := {Orders.Ship Date}; DateDiff ("d", d1, d2) - DateDiff ("ww", d1, d2, crSaturday) - DateDiff ("ww", d1, d2, crSunday) HTH

you can use the mid function like this Mid ('(03/25/05)Perishable Goods',2,8) to get the date portion out of a String HTH

I gave the CECP exam 1 on saturday and I failed. I got 69% and passing was 70%. As said in this forum, the wording of the question are bad. I am so depresseed that I will failed with 1%, maybe I will give the exam again after 1 week and see. Hopefully I will pass.

How can I use parameters in a sql expression? (select SUM(column_value) from table1 where calender_year = ?parameter_value) ?How can this be done? When I look in the panes above I do not see the parameter listed. Thanks.