Forum Replies Created

Viewing 15 posts - 496 through 510 (of 2,010 total)

  • RE: Hide columns or Rows in a report based on Globals parameter UserID

    First, there is no Gglobals.USerid. The parameter I believe you are lookign for is User!UserID="John Doe"

    Secondly, I'd hide this information using the column's visibility property. You can use...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 11:19 am

    #1138430

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/23/2010)

    The Simpsons debuted on December 17, 1989.

    It ran as a sketch starting in 1987 on the Tracy Ullman show.

    And yet, Bart doesn't age.

    At least Bart and Lisa can walk/talk...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 11:05 am

    #1138411

  • RE: Multiple condition expression

    You seem to be missing a closing parenthesis or rather have an extra opening paren prior to your nested IIF.

    Try this.

    =IIF(Fields!OEE.Value > 85, "Black", IIF(Fields!OEE.Value > 75, "Yellow", "Red"))

    Also, if...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 11:03 am

    #1138409

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/23/2010)

    Luke L (3/23/2010)

    Jack Corbett (3/23/2010)

    Gianluca Sartori (3/23/2010)

    CirquedeSQLeil (3/22/2010)

    Visions of Itchy and Scratchy just ran through my head.

    ROTFL! :hehe::hehe::hehe:

    Jason, I don't want to be unrespectful, but, looking at the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 10:48 am

    #1138394

  • RE: Foreign key build

    Michael Valentine Jones (3/23/2010)

    You can create a FK that references a column that has a unique constraint that is not the primary key.

    Yes, this is true and is...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 10:39 am

    #1138383

  • RE: Are the posted questions getting worse?

    GabyYYZ (3/23/2010)

    On a CV/Resume, would it be better to list your experiences first and then, at the end, list the cert(s), or flip the order and have the certs first,...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 9:29 am

    #1138315

  • RE: Foreign key build

    First, I'd like to point out that you might want to revisit you idea to have all of your tables PK's as GUIDs. PArticularly if they are Clustered primary...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 9:23 am

    #1138302

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/23/2010)

    Gianluca Sartori (3/23/2010)

    CirquedeSQLeil (3/22/2010)

    Visions of Itchy and Scratchy just ran through my head.

    ROTFL! :hehe::hehe::hehe:

    Jason, I don't want to be unrespectful, but, looking at the quite high number of...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 8:52 am

    #1138270

  • RE: Attachment name in Email Subscription

    So just outta curiosity, another workaround that might be a bit more complex, but would allow you to not have to rename the report every day...

    What about creating a subscription...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 23, 2010 at 6:53 am

    #1138171

  • RE: Attachment name in Email Subscription

    Imagine that... here's an article from today's newsletter that details how to do this, better late than never.

    http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69546/

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 22, 2010 at 2:13 pm

    #1137831

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (3/22/2010)

    tstaker (3/22/2010)

    Anyone have anything funny, interesting or weird to talk about today? I'm bored.

    A consulting company here installed a SQL clustered Server with two nodes and they...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 22, 2010 at 12:05 pm

    #1137738

  • RE: SSRS - Display parameters on pull down list base on condition or user roles

    Do you already have other reports broken out by subject, Group Membership etc? IE. Is there a Sales folder that reports pertaining to sales exist in and an HR...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 22, 2010 at 9:50 am

    #1137658

  • RE: what to call the daily reporting server?

    I'd suggest you use whatever your current server naming convention is and stick with it. If that's R2D2PDQ_10 then that's what it is...

    Getting too cute with names can lead...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 22, 2010 at 6:41 am

    #1137539

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/19/2010)

    To be honest, there is no comparing winter down south to winter up north. Especially this year. We get at most a few...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 19, 2010 at 8:34 am

    #1136768

  • RE: Newbie alert, how to build a bill report

    Ninja's_RGR'us (3/17/2010)

    Vishal Mehta (3/17/2010)

    when I did a simmillar thing I encased all these datasets that build the "body" of the bill into a List Tool and this allowed repeating fields...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

    March 17, 2010 at 9:01 am

    #1135315

Viewing 15 posts - 496 through 510 (of 2,010 total)