Viewing 15 posts - 31 through 45 (of 46 total)
The problem with presenting data is that inevitably the presentation of the data comes into play 🙂
December 30, 2011 at 11:06 am
True.
I tend to err on the side of more customizable presentation.
December 29, 2011 at 2:08 pm
First step would be to build the report and deploy it.
Verify that you can run it manually on the report server.
After that, you'll be ready to go in and create...
December 29, 2011 at 2:03 pm
I would toss that query into a simple SSRS report and then set up a subscription with email delivery and excel render type.
Should get you what you are wanting.
December 29, 2011 at 1:34 pm
Do you have an SSRS instance available to you?
Could always set up a subscription.
December 29, 2011 at 1:18 pm
=iif(len(value) > x, "8pt","10pt")
Or am I misunderstanding your needs?
December 22, 2011 at 3:24 pm
I've most often seen this technique used prior to doing manual data manipulation on the source table so you have an easily accessible copy of the original data.
Also, using it...
April 17, 2011 at 1:36 pm
I'm not certain how that worked to begin with but I know 2008 changed how it handles certain nodes.
Also, I assume your RDL is redacted as it is missing some...
November 3, 2010 at 1:16 pm
DECLARE @Y4 AS INT
SET @Y4 = 3
SELECT
CASE
WHEN @Y4 = 1 THEN '6.0'
WHEN @Y4 = 2 THEN '5.4'
WHEN @Y4 = 3 THEN '4.2'
WHEN @Y4 = 4 THEN '3.1'
WHEN @Y4...
November 3, 2010 at 8:36 am
Good times 🙂
Glad you were able to get it working.
October 27, 2010 at 9:06 pm
Hey Michael.
Is it possible SSRS is intalled on x64 and MySQL is on x86?
If so, have you tried creating the DSN in using ODBC admin tool in System32 -and- SysWoW64?
October 27, 2010 at 8:12 pm
I assume you are referring to the look of the report as your column limit?
You can have up to 256 columns in Excel 2000/2003 and 16384 in 2007.
Can you provide...
August 6, 2010 at 9:29 am
As far as I know, you can only do this if you are willing to use a drop down list of available dates, as opposed to the calendar control.
You could...
July 14, 2010 at 10:24 am
Might try something like:
DECLARE @query1 AS NVARCHAR(1000)
SET @query1= 'SELECT * FROM table1'
DECLARE @query2 AS NVARCHAR(1000)
SET @query2= 'SELECT * FROM table2'
SELECT @query1
EXEC sp_executesql @query1
SELECT @query2
EXEC sp_executesql @query2
March 15, 2010 at 4:21 pm
Viewing 15 posts - 31 through 45 (of 46 total)