Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: SQLBIGeek
88 results found
SQLBIGeek
’s Function Friday – Convert Job Duration to Seconds
Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am hoping that I can provide some of the details about functions that I have either found on the internet or
Author:
briankmcdonald
Date: 10/29/2010 Section:
Blog
tags :
Brian K. McDonald
,
Functions
,
MSDB Job Duration Conversion
,
SQL
,
SQLBIGeek
,
TSQL
Demographics SSRS report - Combining 2 Field values as one
I personally would handle this at the source query, but if I understand your post correctly, you could simply modify your expression like this: =Switch(Fields!LocationDesc.Value = "Bananas","Fruit",Fields!LocationDesc.Value = "Apricots","Fruit",1=1,Fields
Author:
briankmcdonald
Date: 6/1/2011 Section:
Forum
tags :
Brian K McDonald
,
SQLBIGeek
,
SSRS Switch Statement
How to retrieve images from server in ssrs 2005
Bala, When you set the image type to use database, the image itself must come across from the database. Not the path to where the image is stored. Insert the image into the database as a varbinary data type and you should be fine. Thanks, Brian K. McDonal
Author:
briankmcdonald
Date: 6/17/2012 Section:
Forum
tags :
@briankmcdonald
,
Brian K McDonald
,
images stored in database
,
Reporting Services
,
SQLBIGeek
Exit For Each Loop... ?
SchaffnerC, I don't see why you couldn't use a for loop to check for the value of a variable. Call it rolling_number or whatever you want. You could store the current rolling_number variable and you would increment it by what is the current value in the i
Author:
briankmcdonald
Date: 7/5/2012 Section:
Forum
tags :
Brian K McDonald
,
briankmcdonald
,
for each loop
,
For Loop
,
SQLBIGeek
Memorized Reports
While all suggestions are good ones, you could capture the results of the parameters and the users from the ReportServer database. There are executions of each report, who executed them, how long it took and a lot more. With that being said, you would jus
Author:
briankmcdonald
Date: 9/10/2012 Section:
Forum
tags :
Brian K. McDonald
,
parameters
,
Pro SQL Server 2012 Reporting Services
,
SQLBIGeek
Adding expression to Derived Column Transformation
Bhavika, Are you setting the file to use in the connection manager dynamically? Or are you hard coding it? You should be able to get the file name from your connection manager or if you are doing it dynamically, you can use filename and filepath variables
Author:
briankmcdonald
Date: 4/12/2011 Section:
Forum
tags :
Brian K McDonald
,
Derived Column
,
Excel Source
,
SQLBIGeek
,
SSIS
Group Filter impact on Aggregate
It is possible that I don't completely understand your issue. It is sometimes hard to tell unless in front of the problem itself. At any rate, I was so inspired by this post, that I wrote a blog about it. You can see it on SQL Server Central http://www.sq
Author:
briankmcdonald
Date: 4/12/2011 Section:
Forum
tags :
Aggregating Thresholds
,
Brian K McDonald
,
Reporting Services
,
SQLBIGeek
,
SSRS
Dynamic Subscription scheduling / delivery
If you use the way the Devin has suggested (which as he mentioned there are many ways), you could just create a stored procedure the has the logic that you need to verify the "new data" for the report. Then if new data exists, start the job(s) in question
Author:
briankmcdonald
Date: 4/27/2011 Section:
Forum
tags :
brian k mcdonald
,
reporting services
,
sqlbigeek
,
subscriptions
,
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
Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting back up and get in full swing of the things again. This is going to be a short blog post as I am just letting you all know about a local Code Camp that
Author:
briankmcdonald
Date: 10/4/2012 Section:
Blog
tags :
Brian K. McDonald
,
Code Camp
,
presentation
,
sqlbigeek
listing out cube properties
Travis, Yes there is an awesome tool called BI Documenter available from Pragmatic Works. You can not only list all this out for SSAS, but also your SSIS, SSRS and SQL Databases. Check it out and download trial here: http://pragmaticworks.com/Products/Bus
Author:
briankmcdonald
Date: 6/23/2011 Section:
Forum
tags :
briankmcdonald
,
sqlbigeek
,
SQLBIGeek
Embedding comments or tags within report for admins?
Decoy, You have many options here. I personally would just put the execution date and timestamp on the report. Then what you could do is have them email that the report to you. You could use that datetime timestamp to query the report execution log for th
Author:
briankmcdonald
Date: 4/25/2011 Section:
Forum
tags :
brian k mcdonald
,
Reporting Services
,
sqlbigeek
,
SSRS
Derived Column Help
Sonu, number's 1 and 3 are answered by my expressions below. Give them a try. I have provided a link with further details on #2. Please review Jamie Thompson's blog on the subject of ISNUMERIC. 1. [EXTRA4] <= 1 ? [EXTRA3] : 0 2. There is not an ISNUMER
Author:
briankmcdonald
Date: 2/15/2011 Section:
Forum
tags :
Brian K McDonald
,
Expressions
,
SQLBIGeek
,
SSIS
SQLBIGeek
's Function Friday - Return First Day of Quarter
Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting it on Sunday for this first post, rather than Friday. However, going forward I am going to post a new
Author:
briankmcdonald
Date: 10/24/2010 Section:
Blog
tags :
Brian K. McDonald
,
First Day Of Quarter
,
FUNCTION
,
TSQL
Dynamic flat file connection manager for creating
Rockstar, It should be pretty straightforward what you are trying to do. One thing that I noticed is you referenced plan_code but are using plan_id when setting the connection to the file. However, Just to make sure what your doing to set the object varia
Author:
briankmcdonald
Date: 1/26/2012 Section:
Forum
tags :
Brian K. McDonald
,
SQLBIGeek
,
ssis FEL
Expression For Default Parameter Value
Greg, I personally wouldn't start from scratch. I would try to delete the parameters first and then re-add them back in before scrapping everything. That should remove the code from the xml behind the report code. If not, right click on your report in the
Author:
briankmcdonald
Date: 12/12/2011 Section:
Forum
tags :
briankmcdonald
,
report parameters
,
SQLBIGeek
dynamic date range label with hidden cascading parameters
I'm having a hard time following you. Are you trying to load 20 values into a dropdown or actually create "20 dropdowns" as your post states. I read that you don't have create table permissions, but personally, I would try declaring a table variable, load
Author:
briankmcdonald
Date: 4/1/2012 Section:
Forum
tags :
Brian K McDonald
,
SQLBIGeek
Generate Image of Package Programmatically
Cam, A site primarily dedicated to Business Intelligence may not be your best source for learning how to program in C#. You may have better results, so you may want to post a similar question at http://www.tek-tips.com/ . However, I just researched a litt
Author:
briankmcdonald
Date: 10/2/2011 Section:
Forum
tags :
C# development
,
dynamically generating images
Date getting displayed as some random number when it is null
sqlkala, Traditionally, when you are loading a datawarehouse with data and there are no values found during a lookup operation a value assigned to the NULL record is returned. This is what is happening to you and the reason for you getting the 1900-01-01
Author:
briankmcdonald
Date: 12/8/2011 Section:
Forum
tags :
briankmcdonald
,
SQLBIGeek
Parameter multivalues
Parameters are sent in a long querystring to drill through reports. You cannot pass a comma separated list from one report to another. It has to pass in the param=val pair for each pair selected. However, when the parameter goes to a query in the same rep
Author:
briankmcdonald
Date: 8/30/2011 Section:
Forum
tags :
ssrs multivalue parameters
SQLBIGeek
’s Function Friday – Return Last Date of the Prior Month
**Updated: 11/6/2010** Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to the fourth post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am hoping that I can provide some of the details about functions that I have either f
Author:
briankmcdonald
Date: 11/6/2010 Section:
Blog
tags :
Brian K McDonald
,
Functions
,
TSQL
SQLBIGeek
’s Function Friday – Return First Date of Month
Brian K. McDonald SQLBIGeek Twitter: @briankmcdonald Welcome to t he third post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am hoping that I can provide some of the details about functions that I have either found on the internet or
Author:
briankmcdonald
Date: 11/6/2010 Section:
Blog
tags :
Brian K McDonald
,
Functions
,
TSQL
insert excel file data into table using ssis
Assuming the sheet that you are trying to query is named sheet1, try this: SELECT [USD P&L], [WLB 7 & 8] FROM [Sheet1$] WHERE [USD P&L] IS NOT NULL Please mark this as answered if it helps you resolve your issue. Thanks, Brian K. McDonald, SQL
Author:
briankmcdonald
Date: 9/21/2011 Section:
Forum
tags :
query excel
SSRS 2008 r2 http log files
You can read the activity of Reporting Services. You will probably want to automate some rolling over process for the ExecutionLogStorage table in the ReportServer database. Just create another table with similar schema and pull on a nightly process all r
Author:
briankmcdonald
Date: 9/29/2011 Section:
Forum
tags :
Brian K. McDonald
tsql update (help me)
i have 3 tables tbl_indicator grp_nbr sect_nbr indicat 1 100 p 2 101 s tbl_group grp_id grp_nbr sect_nbr indicat 333 1 100 a 555 1 100 p 444 2 101 s 222 2 101 y here (in tbl_group) grp_id is P.K tbl_order order_id grp_id 5000 333 5001 555 5002 555 5003 55
Author:
mtkr
Date: 1/31/2012 Section:
Forum
tags :
SQLBIGeek
Page 1 of 4 (88 items)
<< Prev
1
2
3
4
Next >>
Go to page:
[Go]