How do you use SQL Server Reporting Services (SSRS) expression to get sub-string from the inputted text?
I am going to show you few SSRS expressions that you can use in your SSRS reports:
Here’s the same in a text:
||SSRS Expression used:
In this post, you saw how to use the split function in SQL Server Reporting Services (SSRS) expressions to get a sub-string.
In MDX, How to search for a sub-string using something similar to LIKE operator in SQL?
here’s an example using Contoso Sales Cube, please use this to get started for your scenario:
Note the use of INSTR function.
[Geography].[Region Country Name].[Region Country Name]
,instr([Geography].[Region Country Name].CURRENTMEMBER.MEMBER_CAPTION,'United')>0)
if you are looking for NOT LIKE then replace >0 with =0 and you should get the desired results.
In this post, you saw how to write a MDX query that does sub-string search for you similar to LIKE and NOT LIKE operators in SQL.
Need a chart on a SQL Server Reporting Services chart with a secondary axes.
Need measure #2 on a secondary axes:
1. In the Design Mode > Open the Chart Date Pane > For Measure #2, navigate to Series properties:
2. From the Series Properties Dialog box, navigate to “Axes and Chart Area” and choose the option “Secondary” under vertical axes.
3. Click OK to go back to the design mode and preview the report to test it:
4. Make sure to rename the axis title of the secondary axis, format the number to make it consistent with the report layout.
SSRS Version needed: SQL Server 2008 and above.
In this post, you saw how to add a secondary axis on a SSRS Chart.
RSVP URL: http://bit.ly/PASSBAVC052914
How do I change the query that’s being used to populate tables in SSAS Tabular Model?
Here are the steps that you need to follow:
1. After you’ve the solution open in SQL Server Data Tools, go to menu > Table Properties
2. On the Edit Table Properties, you can change the query. you can also change the tables if that’s what you have used using the “switch to” box on the right side of the dialog box.
3. If you need to change the server name or instance, used then you will need to modify the connection, for that go back to menu bar and click on Model > Existing Connections. you should be able to edit the connection from here:
In this post, you saw how to change the query used for the tables in SSAS Tabular models.
The goal of this blog post is to share a quick tip on SQL Server Reporting Services (SSRS): How to add Trademark TM special symbol in Text?
In SSRS, you can put following code in the Expressions:
="Text"& ChrW(8482) &" Dashboard"
what an inspiring keynote by David McCandless! Here are some the things that I noted:
1. Play with your data, get your hands dirty
“Data is the new Soil” – David McCandless
2. set the context while communicating what data is trying to tell.
Example: China has the largest army but compared it to their population they are 120ish! So measuring just the army size does not give you necessary context & sometimes it can meaningless
3. Data visualizations help you combine the language of the mind (numbers) with language of the eye (visuals)! Humans are better at processing visuals.
4. Make sure your data is true & keep your personal bias out of analysis.
5. Other than making sure that the data integrity is achieved in visuals, they should be interesting and functional.
6. Design is about removing unwanted things & distilling the visual to it’s functional essence.
You can check out David’s work at http://www.informationisbeautiful.net/