Search results for query: *

I have a string feild which I have converted into time called PTA(planned time of arrival) and another string feild also converted into a time feild called ATA(actual time of arrival).I have put these feild son my report and they appear fine as time feilds. I want to work out the mins early...

Pls can some one help I have a date feild and I want to run a report over a week period with out the use of parameters so the report will only give me a weeks worth of data. {date.feild} how can this be done pls help

Hi All, an anyone help..... I have a report that I need to run over a week period without the use of a parameter. I need to know how to create a formula that could be implemented into a record selection. {weekly hub date} is the field can any one help with this please

is there away I can tell what database a specific from was generated off. I have 12 forms and two similar databases is there away I can tell what data source a form is using??

pls help I have created a login form which opens up another form teh code looks like this:- ElseIf strUser = "user4" And Password = "user4" Then MsgBox "Access Granted" DoCmd.Close DoCmd.OpenForm "Manchester", , , "[Service Centre / Satellite] = 'Manchester'", , , strUser can any one tell me...

Pls can someone help.... I have created a form called compliance database and I use a password form which opens the compliance form with the code below:- Private Sub Command5_Click() Dim strUser As String Username.SetFocus strUser = Username If strUser = "user1" And Password = "user1" Then...

Can any one help i am using crystal version 2008 I wanted to know if it was possible to run a parameter on a date field over a month period to exclude sunday pls help anyone

I have a time feild {hub arrival time} I need to create an average time for this feild dont know how its done please help

Can any one tell me how to inserta filter onto a report, I have a feild [Service Centre / Satellite] but all I want report to show me the above feild must equal to "Basingstoke". pls help

Hi Guys, can anyone help?? I have created a login screen which opens up a second form (Form1). Is there anyway I could show the login credentials on form1 i.e on the form it tells me who has logged on... so if user1 logs in on the logon screen this will show in the heading of form1 and can...

Pls pls help anyone this is killing me:- I have created a login form using the code below:- Private Sub Command5_Click() Username.SetFocus If Username = "user1" And Password = "user1" Then MsgBox "Access Granted" DoCmd.Close DoCmd.OpenForm "Crystal Compliance Database" Else MsgBox "Please...

I have created a formula based on a condition both results are the same its a simple % formula. If I want to put a condition where :- if {@Controlled / Uncontrolled %}=100 and {@Controlled / Uncontrolled %}=100 then "Controlled" else if {@Controlled / Uncontrolled %}=100 and {@Controlled /...

Dear all I have created a formula such as:- if {Weekday_Hub_Data.Failed Connections, Explanation}="Saturday Collections No Sunday service" then "Controlled" else if {Weekday_Hub_Data.Failed Connections, Explanation}="Trunk Overload" then "Controlled" else if {Weekday_Hub_Data.Failed Connections...

I want to be able to run my report over a month period but I want it to exlude all data for sundays only is there a way I can do this??? I have two parameters a start date and an end date If I want to run it over a month period to not include sundays. Thanks

I have a subreport placed in RHk and RHL for eaxample I have suppressed each section in my subreport using this formula isnull({Weekday_Hub_Data.Arrivals, Vehicle Route ID})and isnull ({Weekday_Hub_Data.Late Number Notified Y/N}) and isnull ({@PDT})and isnull ({@ADT})and isnull ({@ATA})and...

can anyone one help my subreport appears twice in my report I have tried to fix it so it appreas once when I do this and save it it keeps on comming back pls help anyone... I am using crystal 2008

Pls can some one help I have created a summary feild i.e sum({nse value}) can i find a highest value and a lowest value of this feild. there is date parameter on the report hence why I have summed this feild, I have tried max and min but this does not give me a cumulative value when I run the...

Please can someone help I am trying to suppress a subreport when there is no data. and I want to show the word "no data" I keep getting the page heading appearing and the subreport does not suppress pls advise

Hi people I wonder if anyone could help??? I have created a report which I want to schedule in business objects but I want my report to only bring back data for yesterdays date automatically. I tried to create a formula to put into the recorde selection currentdate-1 but it wont pick it up can...

Hi Can anyone help I want to highlight a date feild in red. I have a feild {Vehicle Ins Expiry Date} I want to be able to higlight this feild in red when there is one month left before the Expiry Date. Is this possible??? basically create a flag on this feild. I am using crystal reports 2008...