Reporting Services BP

JavaScript

//===================================================================
    // Null values in parameteres
In report builder:
1. Left pane.Data set: select dataset --> parameters --> delete param you want to NULL.
2. Left pane.Params: select param --> properties --> copy Name to buffer and change it ot some other value
3. Save report
4. Rename param back
5. Add param to Data set (without specifing param value just name needed '@Name')

//===================================================================
    // report manager
http://vm-srvdoccli3/Reports/Pages/Folder.aspx
На отчёте [^] Управление --> Параметры отчёта (время обработки отчёта)
                          
//===================================================================
    // rsProcessingAborted
/* Не удалось считать следующую строку данных для набора данных ReportData. (rsErrorReadingNextDataRow)
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. */
Искать поле данных, возвращающее склейку данных (точнее несколько значений вместо склейки)

//===================================================================
    // Navigate to new window/tab by click
Action...
="javascript:void(window.open('http://server/folder/filename.aspx?ds=" & Parameters!UserName.Value & "&bu=" & Fields!Business_Unit.Value & "&in=" & Fields!Item_No.Value & "','_blank'))"

//===================================================================
    // 

//===================================================================
    //