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