Forum Replies Created

Viewing 15 posts - 31 through 45 (of 46 total)

  • RE: Query Result in Mail

    The problem with presenting data is that inevitably the presentation of the data comes into play 🙂

  • RE: Query Result in Mail

    True.

    I tend to err on the side of more customizable presentation.

  • RE: Query Result in Mail

    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...

  • RE: Query Result in Mail

    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.

  • RE: Query Result in Mail

    Do you have an SSRS instance available to you?

    Could always set up a subscription.

  • RE: conditional font size

    Excellent!

    Glad you got it up and running.

  • RE: conditional font size

    =iif(len(value) > x, "8pt","10pt")

    Or am I misunderstanding your needs?

  • RE: Table level backup

    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...

  • RE: Migration Issue SSRS 2005 to SSRS 2008

    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...

  • RE: Nested CASE statements

    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...

  • RE: SSRS - Linked Server SQL 2008 and MySQL

    Good times 🙂

    Glad you were able to get it working.

  • RE: SSRS - Linked Server SQL 2008 and MySQL

    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?

  • RE: SSRS - Too many columns for one row of report

    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...

  • RE: Limit in date picker control in SSRS

    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...

  • RE: Include qeury with results set?

    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

Viewing 15 posts - 31 through 45 (of 46 total)