Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 3,366 total)

  • RE: Reporting Services Migration from Delopment to Production Server

    When you develop reports your reports RDL is stored in the catalog table in the ReportServerDB but the Master of the new server have no record of the ReportServerDB and...

    Kind regards,
    Gift Peddie

  • RE: Does anyone know anything about the company SetFocus?

    Microsoft provide decent samples for experienced developers for free you just pay for the developer edition because it comes with all the components of the enterprise edition.  Go to the...

    Kind regards,
    Gift Peddie

  • RE: How Hard is Search?

    Google search uses very complex calculus and the business structure depends on it so math is king.  If you think in Boolean until the rest of the pack stop using...

    Kind regards,
    Gift Peddie

  • RE: Temp Tables

    The reason to use stored proc is to force SSRS to use the code because stored proc is controlled by the relational engine SSRS just have to run it.

     

    Kind regards,
    Gift Peddie

  • RE: Temp Tables

    I did not say that but you are doing OUTER JOIN to a temp table in SSRS which gets confused with minor changes in a stored proc.

     

    Kind regards,
    Gift Peddie

  • RE: Temp Tables

    Convert it to a stored procedure and it will run assuming you are using 2005 I have seen worse code that run.

     

    Kind regards,
    Gift Peddie

  • RE: Temp Tables

    I think this is related to the scope of Local # temp table because if you change it to global ## temp table it works.  SQL Server will run the code as...

    Kind regards,
    Gift Peddie

  • RE: Should we backup the Reporting Services databases?

    If you are running reports you need to backup both databases or all your reports cannot be recovered because all the RDL are in the catalog table of the ReportServerDB. ...

    Kind regards,
    Gift Peddie

  • RE: won''''t display web page-only directory listing

    So you have developed a report and build it in reporting services?  I think if you want .aspx pages you need to use reportviewer control because standard reports just comes...

    Kind regards,
    Gift Peddie

  • RE: Reporting Services Corrupted PDF files

    I don't think that is possible when a customer ask for something you cannot do you have to show why you cannot do it and sometimes they will accept the...

    Kind regards,
    Gift Peddie

  • RE: won''''t display web page-only directory listing

    When you develop reports your reports RDL is stored in the catalog table in the ReportServerDB so you may have deployed your ReportServerDB and ReportServerTempDB but the Master of the...

    Kind regards,
    Gift Peddie

  • RE: Reporting Services Corrupted PDF files

    Microsoft does not own PDF so maybe your command line code is not working and I don't think you need any code because all you need is PDF reader and...

    Kind regards,
    Gift Peddie

  • RE: Using report viewer to show reports in web page

    There are sample codes in the link below.  Hope this helps.

    http://www.gotreportviewer.com/

    Kind regards,
    Gift Peddie

  • RE: Scheduled DTS packages fail, agent domain account unable to login

    Microsoft have changed a few things the package owner and the Agent Proxy must be both Admin level accounts.  Try the link below for details.

    http://support.microsoft.com/kb/918760

     

    Kind regards,
    Gift Peddie

  • RE: Die Access, Die

    Actually it is a sub set of web developers who wants Access to continue because they think SQL Server is not needed, these people accuse some of us as the...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 2,641 through 2,655 (of 3,366 total)