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 bkrike 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: janedane
  • Content: Threads
  • Order by date
  1. janedane

    Javascript opener statement

    I am writing a small menu program for a restaurant. I have a parent window with a list of menu items on it which when selected fill a selection list on the same page. This works fine so when I select a menu item from the list, it then appears in the selection list. The problem I am having is...
  2. janedane

    schedule a task in Brio

    Does anyone know if you can schedule a task in Brio (I know it can be done in Crystal). We have a report we need to run and then we need BRIO to FTP the results to a server. Thanks in advance
  3. janedane

    Restricting Groups

    Hi All, I have a very difficult report, unfortunately a lot of the database is laid out like this so I really need some help! I have a field in my reports ProductID it contains codes for products however, a customer many have many products Name ProductID No. of...
  4. janedane

    JDBC and Sybase

    JDBC, Sybase, Crystal Reports 10 When I try to use the Data Direct 4.0 Sybase Driver to my Sybase database. I can't connect properly. It lets me see the table I cannot see the fields in the table. I have downloaded InstallNewDriversv10.zip but it does not contain anything for Sybase. Does...
  5. janedane

    Ordering the days

    Hi All, CR9.2 I have a report that is run over a date range. It displays the number of appointments in a crosstab by Day and time. The Formula I use to display the Days is as follows... if DayofWeek({AEA.date}) = 1 then "Sunday" else if DayofWeek({AEA.date}) = 2 then "Monday" else if...
  6. janedane

    Working Out Age from Date of Birth

    CR 9.2 Hi All, I need to work out the Age from the Date of Birth. AT the moment I am doing a DateDiff("YYYY",DateofBirth,CurrentDate) But That is not completely correct. If the are born in Dec 00 and it's Jan 04 it says that they are four years old. Has anyone done this before?? Any help...
  7. janedane

    Disable the ability to drill down on GroupHeader One

    CR9.2 Oracle 9i Win XP Hi all, I have two Groups GH1 - Consultant GH2- Category On my preview page I have both groups showing. I want to be able to disable the ability to drill down on GroupHeader One(Consultant). If I move GroupHeader One into GroupHeader Two then Consultant is repeated if...
  8. janedane

    Parameters and ASP

    Hi All, I am trying to call a report through the browser using the aspxmps9 supplied by business objects. I am using the simplesetlogon.asp method. When I call a report with no parameters this works fine. However if I have a parameter, I am not prompted to enter a parameter and the report...
  9. janedane

    Unable to connect: incorrect logon parameters

    Hi All, I have a report that runs fine in the report designer HOWEVER in Enterprise I get an error. It schedules fine and I can open the report but when I try to drill down past the first level I get the following error. "Unable to connect: incorrect logon parameters. File ~ce4354sdf54szxa.rpt...
  10. janedane

    Disable the Group tree

    Hi All, CR9.2 Crystal Enterprise Active X viewer Does anyone know how to disable the Group tree if there are no groups?? Thanks, Jane
  11. janedane

    American Date Format in Enterprise

    CR 9.2 re: Scheduling a report in enterprise. I have a report that has a date parameter. When I choose the date from the calender it populates the fields with an american date format. YYYY/MM/DD Doea anyone know how I can change this to DD/MM/YYYY Thanks, Jane
  12. janedane

    Display a number as a time

    Crystal 9.0 Hi All, I have a number field which is actually an appointment time. Is there a way I can display the number as a time i.e 1020->10.20, 843->8.43 Thanks, Jane
  13. janedane

    Cumulative Totals

    Hi, I am having trouble with cumulative Data. I have two fields, a treatment date and a return to work date. To work out the difference between the two I use DateDiff Return to Work: Datediff("D",{Table1.Treatment Date},{Table1.Date returned to Work}) To Divide them in One month, Three...
  14. janedane

    Crystal Reports String Parameters

    Hi All, I have a two parameters as a range on a string field. Medical Number, it's alphanumeric. I have following TrimLeft({PM_CHART_NUMBER_TABLE.MEDICAL_RECORD_NUMBER}) IN ({?param}) to ({?param2}) as a record selection. HOWEVER when I enter 500 and 550 as my parameters, crystal returns...

Part and Inventory Search

Back
Top