Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 2,010 total)

  • RE: Reporting Services Matrix Report

    I agree that it's easier to do the sorting in the SSRS report.

    click on the group that you want to change the order of.

    right click and choose edit group.

    Click on...

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

  • RE: Rather critical perfomance issue

    If there's even 1 query that's being repeated often enough which sucks up all the resources available to it, It will take all it can thus affecting your other databases...

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

  • RE: Rather critical perfomance issue

    Is it truly SQL Server that's pegging the CPU's or some other process?

    Have you identified certain queries that may be taking a long time with a trace or profiler?

    How does...

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

  • RE: Alternate row shading with drill-down

    Is this with a table or matrix?

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

  • RE: Report Viewer Error: The request failed with HTTP status 401: Unauthorized.

    I'm not sure if it's stored within the framework or anywhere else (I'm a data guy not an app dev, I just play one on TV), but if you're hesitant...

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

  • RE: How do you call the report server and tell it to give you the report in PDF format?

    Also here's the info from BOL on using URL params...

    http://msdn.microsoft.com/it-it/library/ms153586(SQL.90).aspx

    -Luke.

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

  • RE: How do you call the report server and tell it to give you the report in PDF format?

    You might need some sort of custom rendering extension. You can read more about it in BOL... http://msdn.microsoft.com/en-us/library/ms156281(SQL.90).aspx

    Perhaps one that runs the report and delivers it to a...

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

  • RE: Default Parameters - Report Runs

    I've not found a way to do this other than forcing the users to select a parameter.

    Many of my reports require a start and end date, so I default the...

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

  • RE: Report Viewer Error: The request failed with HTTP status 401: Unauthorized.

    Also, in the IE security settings for your intranet zone (I'm guessing that's where your SSRS server is)

    IE Options, security Tab, Intranet Zone, settings, how is the User Authentication setting...

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

  • RE: Report Viewer Error: The request failed with HTTP status 401: Unauthorized.

    Just outta curiosity, since a 401 error is security related, have you seen any messages in the Client Event viewers and/or the Server security logs stating how the authentication failed?...

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

  • RE: Select bottom N of each Group By

    I think you could look at 2 things that would help you greatly...

    First, I'd have a talk with the dev team for the front end. Perhaps this whole process...

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

  • RE: SQL or Oracle

    Heh.. I still do the wood/axe/fire thing for heat. The price is right and the exercise is good too. Nothing like smacking a piece of wood with a...

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

  • RE: Subject and descriptions for posts

    OK, the title bar thing will work for me for now, but it might not be the worst idea to restrict the subject line to a certain number of characters...

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

  • RE: Subject and descriptions for posts

    I know, and I actually make it a point not to because you can only see so little of it.

    It's not just the description I'm talking about though. The...

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

  • RE: SSRS reports

    before you worry with visibility and such I'd suggest you get your grouping straight...

    It seems like you would have 2 group levels...

    Table Group on PO.

    Detail Group on PO/Item

    If you need...

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

Viewing 15 posts - 1,141 through 1,155 (of 2,010 total)