someone would bump into check_dependencies error. and the work around is to modify the rdl file performance_dashboard_main.rdl with date time format change.   REPLACE =min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY") AS =Year(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + "-" + Month(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + "-" + Day(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + " " + Hour(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + ":" + Minute(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() + ":" + Second(min(Fields!EventTime.Value, "CPU_UTILIZATION_HISTORY")).ToString() THEN IT WORKS!! |
sql | SQL Server > sqlsrv | DB ENGINE >
