Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 5,109 total)

  • RE: Report Parameters in ReportServer

    Why not use textboxes with them in? You can reference the value of a parameter using expressions. So, for example, if you had a parameter called branch, you could reference...

    Thom~

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

  • RE: Report Parameters in ReportServer

    Hi Stuart,

    As I asked above, how are you trying to store this? Are you trying to read the Report Server DB, Save in a table in SQL, just display them...

    Thom~

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

  • RE: Report Parameters in ReportServer

    How are you wanting to store this data. Are you simply wanting it to be displayed as part of the report, or when the report is run?

    Thom~

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

  • RE: Problem to copy a column (tablix, subgroup?)...

    To expand a row in a table, you can only link it to one item. Be it a cell, a text box, image, etc. Having a duplicate of the column...

    Thom~

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

  • RE: Create Parameter based on available report dataset values

    I hate to ask, but why can't use use a second dataset? It's extremely easy,to have effectively the same query in a second dataset that just returns DISTINCT [Field name],...

    Thom~

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

  • RE: How do you stop data driven subscription in progress

    Surprised this wasn't mentioned, but if you log into RS in SSMS (windows Authentication only), you can stop the job there. Expand the Jobs folder and it will show all...

    Thom~

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

  • RE: Drill Down

    You've not actually provided any errors, or details of your table set up/groups, etc. We'll need more information before anyone can give you any insight into where you've gone wrong...

    Thom~

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

  • RE: How can I migrate SSRS subscriptions to a new server

    Simply restoring the databases (make sure you restore both the Reporting Service and Reporting Server TempDB) on a different server will create the subscriptions on the new server, and you...

    Thom~

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

  • RE: row visibility not working as expected

    acallaway (7/29/2016)


    The field I need to reference/check for the row visibility is in another dataset. Your final comment suggests that this cant be done?

    =iif(First(Fields!INVOICE.Value, "E10")<>"",True,False)

    Correct. You can't reference another...

    Thom~

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

  • RE: row visibility not working as expected

    You'll need to reference to column value itself, not the cell. If your column is a calculated column, you can simply do this by doing:

    =iif(Fields!CalcColumn.Value = 0, TRUE, FALSE)

    If your...

    Thom~

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

  • RE: Missing Parameter

    You don't need outputs on these if they are inputs, but your start date should be defined as being optional. In your sp at the moment you have it as...

    Thom~

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

  • RE: SSIS and Datasets

    Personally, this sounds like to me that you'll be using a Data Flow, with Merge Joins. Like Bantrim says though, without really knowing what your data looks like, I could...

    Thom~

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

  • RE: Granting user access/ and SOAP API in Reporting Service

    Hi Newbi,

    At this stage i would recommend doing some self research, there's plenty of resources available, rather than having someone from the community guide you through the majority of steps....

    Thom~

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

  • RE: Urgent SSIS Help

    Does your Excel Source ignore conversion errors on any of these fields which aren't coming through? If so, try turning it off and seeing if it errors. It might be...

    Thom~

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

  • RE: Configuration web url for SQL reporting service

    Newbi (7/21/2016)


    I want to change it to http://locathost/ReportServers instead of http://MYNAME/ReportServer(which appears as it in web browser currently)

    In Report Manager URL Tab, it appears clickable link as http://MYNAME:80/Reports_2012

    I...

    Thom~

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

Viewing 15 posts - 4,951 through 4,965 (of 5,109 total)