Search results for query: *

Saw the issue after I posted that.. the last line - true else true... that was causing my issue.. Thanks for your time

This is the formula: if {?Posted Date} = 'MonthToDate' and date({JDT1.RefDate}) in MonthToDate then true else if {?Posted Date} = 'YearToDate' and date({JDT1.RefDate}) in YearToDate then true else if {?Posted Date} = 'LastFullWeek' and date({JDT1.RefDate}) in LastFullWeek then true else if...

I have the following formula within my report header: "Date: " & date(Minimum ({DT1.Date})) & ' to ' & date(Maximum ({DT1.Date})) & chr(013) & "Generated: " & currentdatetime; My issue is, the min / max values being displayed are incorrect. I use a boolean formula to select data Example...

Hi Kate8, You wouldn't be able to 'go get' the url, the application would need to pass the report the needed parameter information using the sdk.

Are you logging onto CE with the Administrator account?

BTW.. If others feel this is a need, I could write up a paper on it.. .. .

We where able to get XI R2 running on Windows 2008 with a few tricks. Main issue is/was, the installer does not recongize IIS 7. We did a normal install, then went into IIS and created the virtual directories by hand.. Once we did that, it ran..

Does the report generate an error message?

Change the parameter type from a date to datetime. You can than add defaults to the parameter to return the desired time when first opened. Make sure you set 'allow range value' to true.. Then place that in your select statement {?yourparameter} in {yourdatetimefield}

Don't save data with your report..

More then likely you need to hardcode the database login information for the report within the cms or have infoview prompt for the database info which can also be done within the cms. As far as I know, the job/page service does not pass database logon information to a report... but I've been...

Sorry about that. The results should mirror the following. FIELD1 is the name field. FIELD1 FIELD2 FAC PRIMARY SLS PRIMARY AKS IDK SLA

I searched the forum without any luck. So, looking for a little help. I have the following data: FIELD1 FIELD2 IDK FAC Primary SLA AKS SLS Primary I am looking to list out the data by it's name, with primary being first. I know I could group it by FIELD2 than by the...

I would think something like this should work: (That's if the Departure_Time is a date/time field.. If not, you can use the related date field. if DayOfWeek ({PAT_ENC_HSP.ED_DEPARTURE_TIME})= 7 and TimeValue ({PAT_ENC_HSP.ED_DEPARTURE_TIME}) < time(19,00,00) then "Sunday" else if TimeValue...

Thanks LB

Hello all.. I've been knocking my head against the wall.. I have a birthdate field.. I just need to know who has a birthday coming up within the next 45 days. Thought Dateadd would do the trick, but I can't seem to get it to work.. Thanks for any help given..

Duh.. always forget about ubound.. That did it.. many thanks.

I have the following select statment, which fails if the user doesn't enter more then one value for the parameter. Does anyone know of a cleaner way of doing this? Using BOXI against sql if {?Location}[1] <> "" and {Name} like '*'&{?Location}[1]&'*' then true else if {?Location}[2] <> ""...

Ah.. SELECT id, CAST(WorkFromDate AS CHAR) FROM Work_History Many thanks for the direction..

Hello all, Trying to create my first stored procedure and I am seeking a little help. I need to combined two tables and thought a union would be best. SELECT id, thru_date FROM Hospitals UNION SELECT id, FromDate FROM History; My issue is, the thur_date is a string and the Fromdate is a...