Recent content by BlurredVision

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