Browse by Tags

Configuring Available Memory for Report Server Applications
27 April 11 07:11 PM | Ronen Chenn | with no comments

Although Reporting Services can use all available memory, you can override default behavior by configuring an upper limit on the total amount of memory resources that are allocated to Reporting Services server applications. You can also set thresholds that cause the report server to change how it prioritizes and processes requests depending on whether it is under low, medium, or heavy memory pressure. At low levels of memory pressure, the report server responds by giving a slightly higher priority...

תגים:ITPRO, DEV, SSRS, TECH, REPORTING SERVICES

Displaying Timezone along with Global.ExecutionTime
21 September 10 10:21 AM | Ronen Chenn | with no comments

If we would like to display in our reporting services report the timezone along with Global.ExecutionTime, then, these are the steps... In report > properties add this function to the code section Function GetOffset() As String Return TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).ToString() End Function Then in your report footer add a textbox where you want the value displayed and set the Value expression to: =Code.GetOffset()

תגים:DEV, SSRS, TECH

hyperlink in a new window in Reporting Services Report
19 February 09 12:20 PM | Ronen Chenn | 7 comment(s)

Reporting Services gives you several ways to navigate within your report or navigating to external item (i.e. Navigating to other reports or any web URL). You can use a feature called "Jump to URL". Use the following steps to set "Jump to URL" Method-1 - Drag a datafield on the report - Click on the Textbox - Find the Action property of Textbox the property window - Select Jump to URL option - Type any valid URL (i.e. http://blogs.microsoft.co.il/blogs/bilive ), valid URL must...

תגים:ITPRO, DEV, SSRS, TECH

Reporting services TIP #10
05 February 09 10:03 AM | Ronen Chenn | with no comments

Hi all, I decided to blog each time I run into nice trick at the BI services. I have counted 9 tips, so I will numerate them... ( just for fun)- it is always good to start from 10. (-: Problem : You have a table. you need to hide/unhide columns by specific parameter. For example: You have this table, you need to hide the Qi columns by a value of the parameter. site Q1 Q2 Q3 Q4 a b c d Solution : Past this expression on each column visibility: IIF(INSTR(Join(Parameters!StatementName.Value, "...

תגים:SQL 2008, DEV, SSRS, USER GROUP

Nice Undocumented feature in Report Builder 1.0
17 January 09 05:28 PM | Ronen Chenn | with no comments

1. You can add a textbox that shows the date the report was run by setting the value of the textbox to the following: =String.Format("Date: {0:MM/dd/yyyy}", DateTime.Today) 2.Another potential use of this undocumented feature is to display the values selected by the user for each report parameter. This is a helpful workaround for the fact that the auto-generated filter description does not insert the run-time values for each parameter. Here's an example of an RDL expression that would...

תגים:SQL 2008, DEV, SSRS, Report builder

Use SQL 2008 reporting services with template
17 January 09 04:48 PM | Ronen Chenn | 1 comment(s)

HI, One common best practice for enterprise reporting system is one template for all the reports . In order to use one template follow this steps: 1. Develop one report with all the template item you wish to include at your template. 2. save it on this folder : C:\Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject 3. There is a file called report.rdl; that is the default one from MS. One caveat, you will have to do this on every machine as the template...

תגים:SQL 2008, BI 2008, SSRS

SSRS Templete
22 December 08 11:22 PM | Ronen Chenn | 2 comment(s)

Hi, You can use template behavior by creating specific reports you'd like to have your team use as starters and placing them at C:\ProgramFiles\Microsoft SQL Server\80\Tools\ReportDesigner\~ProjectItems\~Report-Project directory . Those report "templates" will then show up in Report Designer's. Add New Item dialog along with the Report Wizard, Report, and Data Source templates when you go to add a new report to a project. Ronen Technorati Tags: SSRS 2008

תגים:PPS SQL2008, DEV, SSRS