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 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...
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...
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...
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...
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.
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...
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 -...
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...
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.
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,
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?
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.