Reports Designed in SQL 2005

  • Hi. I have installed SQL 2012 into a dev environment to allow me to test ERP System reports. Using Visual Studio 2010 I have attempted to execute a standard sales report. This returns a rendering error "Index was out of range. Must be non negative and less than the size of the collection. Parameter name index".

    The report in question was developed for SQL 2005 and has hidden fields which were added in order to display header information on multiple pages. I understand this fudge is no longer required since SQL 2008.

    So my question. Where to start! I was hoping I would be able to push a magic button and update the format of older reports so they execute.

    Any tips advice welcome, I have hundreds of reports. Some execute but I am sure many will not.

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply