Search results for query: *

Hello All ! I am facing an issue with .udl file and Crystal Reports XI 2. Currently we are using .udl file ( Oracle OLEDB provider ) with Crystal Reports XI 1 and it works well. Now we are moving to Crystal Reports XI 2 and the .udl file does not work. It prompts for database credentials. Is...

You may try the function DayofWeek().By default the DayofWeek() returns 7 for Saturday and 1 for Sunday. So something like not(DayofWeek(Date) in [1,7])

Which version of Crystal you are using ?

I have a report in which I need to display the values from a field in the page header. When the report is run this field can have 3-5 values. These need NOT be placed in detail section or any where else, but ONLY on the page header, HORIZONTALLY. Example Advt List : Advt1, Advt2,Advt3...

You have to enter the database information for the report through CMC. Log on to CMC, select the report, click on database and fill the user name and password.

Hi How will I hide the 'Group Tree' in Business Objects Enterprise XI ? I have reports which are viewed from infoview, and group tree shows up. Need to remove that functionality. I remember, in CE 10, there was an option for the same under Servers -> WCS Thank You

I am looking for the syntax in query builder to get the list of reports grouped by folders

Hello ! I will like to query that will return me the list of reports in Crystal Enterprise, grouped by folders.

Crystal Reports XI Business Objects Enterprise XI Is there any way a currency field can be dynamically changed based on where the user runs the report ? If the user is in USA, then US dollars is displayed, in Canada, it should be converted to Canadian Dollar and in UK to pounds etc etc. Thank You

You may use the Right() function. Example Right({Table.Field},4)

I found this link useful http://www.hammerapps.com/techtips/techtipsasp/techtipsdynamic.asp?TTID=156

I have a database field in 'Number format'. I need to convert it to date. The number is of format YYYYMMDD. For example 20050920 stands for 2005/09/20. I could not find a function which directly do the conversion. Can any one help me with a formula which convert it to date ? Crystal Reports...

That worked !!!! Than You

Crystal Reports Version XI I need to create a report with graph. The report has a line graph and a bar graph overlapped. The graphs have the same x axis. So that is two chart types on one graph. How can this be achieved ?

Is it possible to call an API from Crystal Reports XI ?

Subreports were giving me performance issues( I am not displaying the info in report footer ). Is there a formula or some thing which will be of help ?

I am using Crystal Reports 10, SQL Server I need to add the invoice amount for unique invoice in a group. The report is grouped by Purchase Order creator, PO Order Number - PO LIne and Invoice ID. In the detail section I have PO line information An invoice can appear under more than one PO...

I have a report which has date range parameter - Need to display the date range on the report... Now since this a date range, the report can have 'no upper Value' , 'No Lower Value'. I need to reflect this on the report - How can this be acheived ?? For example if the user select 4/1/2005 and...

Humm.. I need the detail section there - since I am already doing summary calculation from the detail section... Is there any formula which can help me ?

Crystal Reports 10/ Crystal xi I have a report in which I need to find the Sum of a field in Group header1 and Group header 2. This report has three groups – Region - Group 1 City - Group 2 Invoice No.- Group 3 In Group 3 Header, I am displaying the invoice amount. Now in the detail section...