Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 5,109 total)

  • RE: Error in Creating Report Subscription Report Manager Native

    When entering the credentials, are you using a Windows Login? If so, you'll need to ensure that you tick the box that states you're using that (See screen below from...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS export to CSV French and Spanish Characters

    Duplicate, Responded on other topic: http://www.sqlservercentral.com/Forums/Topic1787217-150-1.aspx

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS export to CSV French and Spanish Characters

    This is because SSRS, by default, doesn't export CSV's in unicode, but in ASCII.

    You'll need to locate Report Services Configuration file, and then amend/add the render type. For example, on...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS accessing from different domain ??

    You can do this, yes, but the two domains will need to have trust between each other, so that you can authenticate still.

    Access the SSRS portal, and hover over the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Expressions

    I correct my previous post, but repasted:

    =IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today()) < 2,"Green", IIf(Fields!LastDiffBackupDate.Value is Nothing,"Transparent","Red"))

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Expressions

    tmmutsetse (5/12/2016)


    i dont know what is happening,the code you send me is having an uncommon symbol after Today()),but when i am replying it shows < symbol.

    The less <2 is from...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Expressions

    =IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today())<2,"Green","Red") OR IIf(IS Nothing(Fields!LastDiffBackupDate.Value),"Transparent").

    You're almost there, but not quite. You have nest the iif's, so it would become:

    =IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today()) < 2,"Green", IIf(Fields!LastDiffBackupDate.Value is Nothing,"Transparent","Red"))

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Migrationg to Excel Worksheets where header is on column 2

    Phil Parkin (5/11/2016)


    Thom A (5/11/2016)


    Will the columns always be the same amount, for example Columns A through to J? If so, you can set the sheet name to;

    [Sheet1$A2:J] This will...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Migrationg to Excel Worksheets where header is on column 2

    Will the columns always be the same amount, for example Columns A through to J? If so, you can set the sheet name to;

    [Sheet1$A2:J] This will make SSIS select all...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Average on two columns

    sindhupavani123 50704 (5/10/2016)


    Hi Thom,

    Thanks for your reply!

    But my question is not averaging on a single column, if I understand it correct,

    The data in report is something like this

    IDSeller ...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Average on two columns

    Add a total's row to you table. You can do this by right clicking one of the cells with your data in and clicking Add Total. SSRS will automatically add...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Formating INT value to custom HH:MM:SS using expression for data labels

    wwwnlc111 (5/10/2016)


    Hello,

    I am attaching two screen shot one normal and other after applying =Format(Parameters!intTime.Value, "#0:00:00")

    Are the number actually integers or do they have some decimal places? If might be worth...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: SSRS Color Code Cells based on SQL Table Values

    You can have a dynamic value on a textbox's text/fill colour using expressions.

    Right click the appropriate cell and select text box properties. Navigate the the Fill Pane (I've assumed your...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Formating INT value to custom HH:MM:SS using expression for data labels

    Edit :Wrong Topic >_<

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Formating INT value to custom HH:MM:SS using expression for data labels

    wwwnlc111 (5/9/2016)


    Well, please allow me to come in simple talk, let's suppose I have value in SSRs report designer like 103743 or 33059.

    How I can using expression show like below...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 5,041 through 5,055 (of 5,109 total)