Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: action
118 results found
SSAS Reporting Actions with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a br
Author:
MikeDavis
Date: 4/22/2011 Section:
Blog
tags :
Action
,
Cube
,
Dilldown
,
Report
,
SSAS
,
Reporting action
,
SSRS
SSRS: Click Through / Drill Through / Action to go to another report
Today in class I was asked a very interesting question. One of the attendees asked if SSRS 2008 was limited to a specific number of drill through's in a report. At the time, I created a report, that enabled the end user to click on the Reseller Name and g
Author:
SMcDonald
Date: 4/13/2011 Section:
Blog
tags :
Action to go to another r
,
Click Through
,
Drill Through
,
Reporting Services
,
SSRS
,
Sherri McDonald
Action Packed Maps in Your Reports
A couple weeks ago I went over some tips for customizing your maps in Reporting Services 2008 R2. This week I'm going to stay on the same topic, but instead of customizing your legend ranges , I thought I'd go over a pretty cool interactive option that is
Author:
kylewalker
Date: 3/31/2011 Section:
Blog
tags :
maps
,
MDX
,
report actions
,
SSRS
Drill Through ACTION on Calculated Measure on SSAS Cube
Hi All, I have been tried to implement Drill Through ACTION on calculated measure on the cube.But later I found it is not possible to perform Drill Through ACTION on calculated measure, only on physical measure from the fact. I came across one of the link
Author:
maruthi.vm
Date: 1/13/2013 Section:
Forum
tags :
Action
,
drill through
,
SSAS 2008 R2
SSRS Action to Open Outlook Email
The process to open a MS Outlook email from a report action is a very simple task. The only requirement should be obvious but you will need the email addresses of the contacts. All you have to do is setup an SSRS action with or without an SSRS expression
Author:
ChrisAlbrektson
Date: 5/6/2011 Section:
Blog
tags :
MailTo
,
SSRS Action
,
SSRS Action to Open Outlook Email
SSRS Action to Open a URL in a New Window
When developing reports in SSRS, you will often want to click on a given value and go to a URL on the Internet. This is an easy concept in SSRS with Actions with the "Go to URL" option as shown in the below screenshot. The challenge comes in where most pe
Author:
BrianKnight
Date: 8/13/2010 Section:
Blog
tags :
action
,
expression
,
ssrs
Drillthrough not working with data level securtiy enabled in SSAS cube for a read user role
I have a read user role in which the users are restricted to some of the attributes of a dimension. Created a drillthrough action in cube with some set of measures and dimensions (dimension or dimension attributes which has data level securtiy enabled are
Author:
Vidyasagar
Date: 2/6/2012 Section:
Forum
tags :
data level security
,
drillthrough action
,
ssas cube
Drillthrough Action
Hi All, I Have couple of issues in drillthrough development. Please review and give me your valuble suggestions. 1. Is there any way to set Maximum Rows number dynamically with MDX. For example I need to set max rows value based on client input in a DB ta
Author:
Venkat
Date: 3/18/2011 Section:
Forum
tags :
cube action
,
mdx
,
ssis
Action not executing in SSAS 2008 r2
Hi All, Refering to the blog http://sqlblog.com/blogs/mosha/archive/2008/11/03/custom-filters-with-mdx-subcubes.aspx . I created the Action (Standard Action) . I want to Created a Named set which will show description of Only this two department. Whenever
Author:
faiz_bidn
Date: 1/17/2013 Section:
Forum
tags :
Action
,
Action SSAS 2008
,
Custom Filter in SSAS
Drill through report render as Excel
Is there a way to pass a paramater in a drill through action to have the report render is a non standard (html) format like Excel. I would like to create a drill through action that calsl a report, passes paramaters and have that report render in excel wi
Author:
dmcgivney
Date: 6/27/2012 Section:
Forum
tags :
drillthrough
,
Renderer
MDX Action Type URL
I am trying to create an Action URL using my Dimension Agency. I would like ot have the action show for any attribute within the Agency dimension like 'Name', 'Agency Number', etc. I'm new with MDX and can not find the right function, if there is one, to
Author:
mwinn
Date: 3/15/2011 Section:
Forum
tags :
Action URL
,
Attribute Names
,
MDX
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as the row group, with year and quarter as t
Author:
MikeDavis
Date: 2/7/2011 Section:
Blog
tags :
interactive
,
matrix
,
sorrting
,
ssrs
SSRS Action to Open Office Communicator
On a recent reporting project I was assigned to create a Project Management Dashboard. Part of the specs for the report was to be able to click on the Project Managers name in the dashboard that would launch Office Communicator (OCS). In order to achieve
Author:
ChrisAlbrektson
Date: 4/22/2011 Section:
Blog
tags :
SIP
,
SIP fo
,
SSRS
,
SSRS action for Communicator
,
SSRS action for OCS
,
Open MS Communicator from SSRS
Chart synced with other data
SSRS 2008 r2 I have 2 datasources, 2 datasets and 2 objects on the report. 1st object is a chart, 2nd object is a tablix Chart gets data from 1st dataset, x axis is time Tablix has some other data from 2nd dataset that I want to filter dependent on time p
Author:
syale
Date: 4/9/2012 Section:
Forum
tags :
parameters
,
syncs
,
tablix
XML export issue
I have an SSIS package that extracts data from SQL server as xml and exports it as xml files. I am having issues with 3 of the extracts (the large ones). Now the package runs for sometime and croaks out without outputting any file, or when it does, the si
Author:
temitaio
Date: 5/4/2011 Section:
Forum
tags :
SSIS
,
XML
MDX Puzzles: Double Deuce Action - Answer
The key to solving Puzzle 2 was using the PrevMember function. The PrevMember function returns the previous member of the current member on the same level. That means if the current member is March 2002, the previous member would be February 2002. So the
Author:
DustinRyan
Date: 11/5/2010 Section:
Blog
tags :
MDX
,
PrevMember
,
MDX puzzle solution
Passing SSRS T-SQL Values to SSRS MDX Parameters
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source. A requirement of the report was to create an action that drilled-through to another report. No big deal, right? This is SSRS 101. Well, th
Author:
PatrickLeBlanc
Date: 12/1/2010 Section:
Blog
tags :
MDX
,
T-SQL
,
SSRS
Rock Your Reports Series 3 of 3
In this series finale, Sherri McDonald will show you to create a drill through from 1 map report into a detailed report for the state as well as include a map of the state.
Author:
SMcDonald
Date: 3/28/2011 Section:
Article
tags :
Maps
,
Pragmatic Works
,
Reporting Services R2
,
Spatial data
,
SSRS R2
,
Sherri McDonald
Action Filters in ASP.NET,MVC
In a ASP.NET MVC Application ,Controllers have action method which include all the code which executes a request ,for eg , when a user clicks on a link or clicks on a submit button, the corresponding controller is called,which than routes the control to t
Author:
priti1desai
Date: 7/8/2011 Section:
Blog
Replacing Null or Blank Values In SSIS With Task Factory
In my last blog post, I wrote about how easy it is to replace unwanted characters in ssis with task factory. This week, I'll be discussing another common request; replacing null or blank data from an SSIS source. Again, this task was built to save develop
Author:
ChrisRock
Date: 3/27/2011 Section:
Blog
tags :
replace empty strings ssis
,
replace null values ssis
Passing Multi-Value Parameters to SSRS Sub-Report using Action Hyperlink
When using SSRS Report Action to hyper link to sub-report --> Single vs. Multi-value parameter syntax makes all the difference. For more info read on. I have been working in SSRS Report Builder 2008 on a report that has 10 parameters. The steps are lik
Author:
MichaelSimon
Date: 2/14/2013 Section:
Blog
Using Messages to Navigate in an MVVM Structure
As a C# Noob, I've pretty much thrown myself in head first with my latest project. However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good reason). I won't go into detail about what MVVM is, or why it can h
Author:
RCharCox
Date: 2/21/2013 Section:
Blog
tags :
C#
,
GalaSoft
,
MVVM
,
navigation
,
programming
,
XAML
Rock Your Reports Webinar Coming Up!!!!
Rock Your Reports I am really excited to announce that on Thursday, March 10th at 11 a.m. (EST), I will be presenting on Sql Server Reporting Services. Last month I did a presentation on the Introduction to the Reporting Services environment. We talked ab
Author:
SMcDonald
Date: 3/7/2011 Section:
Blog
tags :
Free Reporting Services
,
Introduction to Reporting Services
,
Pragmatic Works
,
Sherri McDonald
,
SSRS
SSRS Self Referencing Drill Through
When looking at a report and wanting to drill through to get more detail, we often create two reports for this. This can be accomplished by just one report by creating a self-referencing action that links to the same report. This can be done even if the r
Author:
MikeDavis
Date: 10/19/2010 Section:
Blog
tags :
Action
,
Drill Down
,
Drill Through
,
SSRS
CHM File Action Canceled Screen/Unable to View CHM
Late last week, I was able to assist a BI Documenter customer who was having an issue opening a .chm file generated by BI Documenter. Every time he tried to open the compiled help file, his screen showed “Action Canceled” and he was unable to view the .ch
Author:
DustinRyan
Date: 11/23/2009 Section:
Blog
tags :
chm file action canceled
,
unable to view chm file
,
can't view chm file
Page 1 of 5 (118 items)
<< Prev
1
2
3
4
5
Next >>
Go to page:
[Go]