Forum Replies Created

Viewing 15 posts - 196 through 210 (of 219 total)

  • RE: Have you applied RS SP2?

    I have applied this hot fix as we were having the issue with the first row of data dropping out during exports.  We've experienced no negative effects with it.

    However, even...

  • RE: Error during install - login failed for user null

    Does your local PC have SQL Server installed?  It's required if that's what you're installing to. 

  • RE: Reset Page count or use distinctcount() for page number

    MSRS does not currently support this unfortunately.  To get around this, I've set a cursor in the SP that determines what page I'm on and then passses this to the...

  • RE: System.OutofmemoryException

    I was having the same issue.  Users were running large reports and the server was tyhrowing out of memory excpetions.  Only way to resolve was to replace the server.

  • RE: Report sorts

    Based on the value in the sort field, you could dynamically hide columns if that helps. 

    A more complicated approach is to use a stored procedure and then through if statements, run...

  • RE: Page Header

    Place what you'd like to appear on the first page in the report body rather than the header.  If you need to page break after your new header, place the...

  • RE: Report Expiry & Subscriptions

    If you're trying to create multiple snapshots of the same report using different parameter sets, you'll need to create a linked report.  A report can use only the default parameters...

  • RE: Drill down help needed

    Do you have the toggle item property set on these columns?

  • RE: Snapshot not being generated

    When you schedule the report to run, can you see it in the Jobs of SQL Server Agent?  Or have you tiered checking the event logs for any errors during...

  • RE: Unable to access report manager

    I was able to correct the issue by adding the domain users to the Users group on the local machine.  I've never had this not set up correctly so not...

  • RE: Unable to access report manager

    Yes, it did install to the default and that is the URL I'm using.  The issue is you must be part of the Local Admin group on the box in...

  • RE: Printing Drill Down Reports

    In order to get around this, we create a Yes/No parameter for Expand All.  Then for the visible property of the row, an IIF statement checks the value of the...

  • RE: Using Subscript With dynamic parameters

    If you're using a stored procedure for this, one solution is to check in the procedure if the report is passing through a parameter.  If blank, then manually set the...

  • RE: Limit data retrieved to a Matrix

    Note sure you could do this with a matrix, but you could play games with a table and then use the RunningValues to populate each of the individual months based...

  • RE: Index was outside the bounds of the array.

    I've seen the same behavior.  Has anyone figured out what causes this to occur?

    Dave

Viewing 15 posts - 196 through 210 (of 219 total)