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!

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

Recent content by kutoose

  1. kutoose

    .udl file prompting in Crystal Reports XI 2

    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...
  2. kutoose

    Need MonthtoDate without weekends

    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])
  3. kutoose

    error: "blob field or memo field cannot be used in a formula"

    Which version of Crystal you are using ?
  4. kutoose

    Displaying the data in page header

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

    Report on Server not connecting to Oracle 9.2 databse

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

    Hiding Group Tree in BO XI

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

    CE 10 - List of report

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

    CE 10 - List of report

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

    Changing the currancy based on location

    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
  10. kutoose

    END OF A LINE

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

    Convert Number to Date

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

    Convert Number to Date

    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...
  13. kutoose

    Two chart types in one graph

    That worked !!!! Than You
  14. kutoose

    Two chart types in one graph

    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 ?
  15. kutoose

    Calling API from Crystal Reports

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

Part and Inventory Search

Back
Top