Search results for query: *

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

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

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

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

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

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

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

Thanks for that, I have this working fine when my report does not require a database logon HOWEVER when I add the code <% '================================================================== '================================================================== ' WORKING WITH SETLOGONINFO ' ' The...

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

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

Thank you!

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

thanks!

Our client does not want to run any custimised CSP files. I have checked my system default date and it's set to English(Ireland). Any other ideas??? Thanks, Jane

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

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

Hi, Thanks for your help but I figured this one out. Instead of adding the count for {@one month} etc.. I have created running totals and added them instead. Thanks, Jane

Hi, Thanks for the suggestion but it's the count() I am using that doesn't work. Even when I change it to If Datediff("D",{Table1.Treatment Date},{Table1.Date returned to Work}) < 31 then 1 else 0 This Still counts all the regards of the 1 or 0 if {@One Month} = 1 then count({@One Month}...

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

Here is an example of Setlogon ' WORKING WITH SETLOGONINFO ' ' The datasource here is called "Pubs Sample Database". It is a System ' Datasource (DSN), and points to the "pubs" database, which is installed ' with SQL Server. You will also need to change your user id and ' password. 'Create a...