Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goodprg
  • Content: Threads
  • Order by date
  1. goodprg

    How many times a report was accessed?

    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?
  2. goodprg

    thread767-1027831 Description for multiple value parameter

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

    Max values that can be passed to a parameter

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

    Cross tab report with days in a month

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

    formula not working in CE10

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

    displaying dynamic quarters

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

    exporting from CE10

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

    SQL Expressions and Parameters

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

    CE10, CR10 and Oracle 10g

    We have CE10 installed with CR10 and all the reports uses native connecttion to access the database. The database is Oracle 10g. Is anyone using the native connection? Did you all faced any problems with CE10? BO say they don't actually support native connection to Oracle 10g but they do...
  10. goodprg

    conditional suppressing blank section

    In a report I have some blank section which is there if the value of a field is "Group C". I want to suppress this blank section only when the value of that field is "Group C". How can I do that? There is a group on that field. I tried in section expert - suppress blank section - formula -...
  11. goodprg

    Number Parameter formatting in CE 10

    I have a report (CR10) which is has a number parameter and the default values are 11,12,13. When I preview this report in CR it displays the parameter as 11 or 12 or 13 but when I preview this report in CE10 the parameter is getting displayed as 11.00, 12.00, 13.00. I want the parameter to be...
  12. goodprg

    CECP exam

    I am planning to take CECP exam no 1. Does anybody have any tips or questions to share. Also what type of questions are asked in the exam? Thanks.
  13. goodprg

    Displaying 0 instead of a null

    I have a formula which sometimes return null values. I want the report to display 0 instead of null. I know that I can create another function and use ISNULL function but I want to know is there a setting which I can set so that it display's 0 instead of a null value. Thanks.
  14. goodprg

    changing the report viewer

    I am on CE 10. I have created a new user and I want to change the viewer from DHTML to Active X. How can I do that? I tried going in preferences but the drop down list is not enabled. Thanks for your help,
  15. goodprg

    APS database

    How can I find out what database was used for APS? Thanks
  16. goodprg

    format of number parameter changes in CE

    I have a number parameter in crystal reports. When I run the report it asks for the parameter value, the format of number is ok like 1123 and the report run fine but when I publish it in CE and try to preview it the format of the parameter changes to 1123.34 Why is that and how can I fix it?
  17. goodprg

    database logon information

    I have published a report in Crystal Enterprise. In the database tab I have username and password and the prompt user for logon info is unchecked. Still it is asking me for the db info when I try to preview it. Thanks

Part and Inventory Search

Back
Top