Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 5,109 total)

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

    wwwnlc111 (5/7/2016)


    Hi,

    I have INT value like 103743 or 33059, which going to aggregate in my chart for/by different dates.

    I want to use expression for show data labels, and want to...

    Thom~

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

  • RE: SSRS Color Code Cells

    Right click the appropriate cell and select text box properties. Navigate the the Fill Pane (I've assumed your doing the Fill colour, if you're doing text colour, then go to...

    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

    If you're looking to do it in an SSRS expression, this will work (I assume you are not looking to convert it to a datetime value):

    =left(right("0" + Parameters!TestParam.Value,6),2) + ":"...

    Thom~

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

  • RE: Schedule SSIS Package that place file to outside of Network Domain

    Seeing as it's pointing to the filename value, what is it's value? Feel free to amend it slightly if required to hide anything you might not want to be public....

    Thom~

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

  • RE: Multilanguage Report

    Can we achieve with this custom assemblies or =user!language global variable?

    There's a guide to Custom Assemblies for multi languages here[/url]. It's not a quick process, but might achieve what...

    Thom~

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

  • RE: Multilanguage Report

    SSRS doesn't do multi-language reports, as such, out of the box.

    If it's data you're looking to translate, then you will need to ensure that the data the user is being...

    Thom~

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

  • RE: Parameter help

    Loner (4/29/2016)


    I don't quite understand about the following steps.

    Create a third report parameter which does not allow blank or null values.

    Set its available values to be sourced from a dataset...

    Thom~

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

  • RE: creating a view in SSRS?

    Steven.Grzybowski (5/3/2016)


    So now I am wondering if anyone could post me in the direction of some good information on usig dynamically generated queries in SSRS. The data can have...

    Thom~

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

  • RE: Expression Help

    I use a split udf to do this. When you use SSRS to pass a multivalue parameter, it'll pass them all in a comma delimited string.

    I do the split with...

    Thom~

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

  • RE: Subreport

    What are the log files saying? Generally these do give an indication to why they are failing, or at least give a little more information that'll help troubleshoot.

    Thom~

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

  • RE: Expression Help

    Are you actually saying that you have a multi value parameter, and you want to return results if the field you are querying is any of those the user has...

    Thom~

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

  • RE: Grant option and schema

    MY_USER1 also requires CONTROL on schema to be able to define a users permissions.

    GRANT ALTER, CREATE SEQUENCE, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, CONTROL, TAKE OWNERSHIP, UPDATE, VIEW CHANGE TRACKING,...

    Thom~

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

  • RE: Please help with CURSOR - My 1st attempt and learning.

    I'm not sure why you want to achieve this with a Cursor to be honest, you could do this simply in a dataset update.

    With some made up data, would this...

    Thom~

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

  • RE: Failure sending mail

    Not something I've seen before, but found a topic via Google that had a couple of ideas:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2fc89959-9893-4107-9c0a-906e50b1236d/failure-sending-mail-exception-0xc0000005-was-generated-at-address-0x000007fee3d4122b-mail-will-not?forum=sqlreportingservices

    One person suggests that it could be because you have have a second instance...

    Thom~

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

  • RE: 1 DataSet, 1 Summary & 1 detailed report as an attachment in SSRS

    So, correct me if I'm wrong, the email you want you would like to contain 7 charts in it only. Then the attachment (xlsx?) will contain the detail to go...

    Thom~

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

Viewing 15 posts - 5,056 through 5,070 (of 5,109 total)