Configuring Available Memory for Report Server Applications

יום רביעי, אפריל 27, 2011

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 to interactive or on-demand report processing. At high levels of memory pressure, the report server uses multiple techniques to remain...
אין תגובות

Displaying Timezone along with Global.ExecutionTime

יום שלישי, ספטמבר 21, 2010

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()
תגיות: , ,
אין תגובות

hyperlink in a new window in Reporting Services Report

יום חמישי, פברואר 19, 2009

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., valid URL must start with protocol like http: ,ftp:, mailto: ... Method-2- Drag a datafield on the report- Right click and open properties dialog box (or just...
תגיות: , , ,
7 תגובות

Reporting services TIP #10

יום חמישי, פברואר 5, 2009

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  ...
תגיות: , , ,
אין תגובות

Nice Undocumented feature in Report Builder 1.0

יום שבת, ינואר 17, 2009

  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 provide this info: =String.Format("Sales Year: {0}", Parameters!OrderYear.Value) One problem with it is that you will have to guess the...
אין תגובות

Use SQL 2008 reporting services with template

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 is on your local PC. Enjoy, Ronen Technorati Tags: DEV,SSRS 2008,SSRS TEMPLATE
תגיות: , ,
תגובה אחת

SSRS Templete

יום שני, דצמבר 22, 2008

  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
תגיות: , ,
2 תגובות