Showing posts with label version. Show all posts
Showing posts with label version. Show all posts

Friday, March 30, 2012

ReportViewer does not refresh when rdlc file changes

Hi,

I am trying to change rdlc file at run time but it does not resfresh.

I know there is an option to use Reset method but my version of ReportViewer

does not have this method. Does someone know how to change rdlc files

dynamically without using Reset ?

Thanks

Hi,

From your description, it seems that you want to change the report at runtime, right?

I think what you can do is to write a method in your code behind file which assigns the reportpath,datasources property and calls the refreshReport method, and invoke that method in the any event you want. See the following code snippet:

ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = "rdlc file path";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ReportDataSet_XX", ReportDataSet.Tables[int i]));
ReportViewer1.DocumentMapCollapsed = true;
ReportViewer1.RefreshReport();

For more information, you can refer the following threads:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2421083&SiteID=1

Thanks.

|||

Thanks for the reply.

This is exactly what I have in the code except this line.

ReportViewer1.DocumentMapCollapsed = true;

I have added this line and the result as following:

When I set first time reportviewer to rdlc, it works as expected.

When in another event, I am resetting.ReportPath and.DataSources to something different,

I get "

  • Some parameters or credentials have not been specified".|||

    Hi,

    The error "some parameters or credentials have not been specified" indicates that you have not set your parameters well, which is needed for your report.

    And based on the code you provided,

    List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

    You have created a ReportParameterList, but you haven't add any report parameter to the parameter list.

    Thanks.

    |||

    Thanks,

    That is the part of the problem, first rdlc has 2 parameteres

    but second one has no parameters and when I reset to second one it goves me this message.

    |||

    List<ReportParameter> paramList =newList<ReportParameter>();this.ReportViewer1.LocalReport.SetParameters(paramList);

    As the second report has no parameters, remove the above line, you are adding an empty parameter list.

  • Wednesday, March 28, 2012

    ReportViewer control doesn't accept Parameters

    Hello,
    I have developed a web application that uses ReportViewer Web control
    supplied with VS 2005 RTM version. The ReportViewer control uses
    Network credentials to connect to a remote SQL 2005 server to get the
    reports. It works fine for reports that doesn't use any parameters.
    But, for the reports that accepts parameters, the reportviewer control
    doesn't seem to read the Parameters selected from the drop-down box.
    When I click on the "ViewReport" button the report just reloads with
    the initial/default parameter. Can someone please advise if I'm missing
    anything here?
    PS: All the other options of the control works fine (ie., export,
    refresh, page navigation, subreports, document map, etc).I have the same problem so we must both be missing something.
    Chris
    "Raghu" wrote:
    > Hello,
    > I have developed a web application that uses ReportViewer Web control
    > supplied with VS 2005 RTM version. The ReportViewer control uses
    > Network credentials to connect to a remote SQL 2005 server to get the
    > reports. It works fine for reports that doesn't use any parameters.
    > But, for the reports that accepts parameters, the reportviewer control
    > doesn't seem to read the Parameters selected from the drop-down box.
    > When I click on the "ViewReport" button the report just reloads with
    > the initial/default parameter. Can someone please advise if I'm missing
    > anything here?
    > PS: All the other options of the control works fine (ie., export,
    > refresh, page navigation, subreports, document map, etc).
    >|||Hey Ragu, I think I've figured it out.
    I was setting the network credentials on each page load instead of the first
    time the page was loaded.
    I had a look at the ReportViewer code through .NET Reflector and found some
    code that indicated that parameter values where not read when the credentials
    changed.
    Chris
    "Raghu" wrote:
    > Hello,
    > I have developed a web application that uses ReportViewer Web control
    > supplied with VS 2005 RTM version. The ReportViewer control uses
    > Network credentials to connect to a remote SQL 2005 server to get the
    > reports. It works fine for reports that doesn't use any parameters.
    > But, for the reports that accepts parameters, the reportviewer control
    > doesn't seem to read the Parameters selected from the drop-down box.
    > When I click on the "ViewReport" button the report just reloads with
    > the initial/default parameter. Can someone please advise if I'm missing
    > anything here?
    > PS: All the other options of the control works fine (ie., export,
    > refresh, page navigation, subreports, document map, etc).
    >

    Wednesday, March 21, 2012

    reportserver and reportservertempdb database abstration classes

    We are wanting to utilize the tables in ReportServer and ReportServerTempDB,
    but do not want write any code that is dependent on the current version (i.e.
    RS 2005) of the tables in SRS. Does anyone know if MS has provided us with
    some data abstraction classes over the tables beyond the stored procedures
    and methods available in the reportServive and reportExecutioon web service
    classes?
    ===================== Thanks!
    Keith
    p.s. Get off the couch and exercise!The SOAP API is the supported interface; the underlying metadata structure
    in the database will change between major releases (and maybe even service
    packs).
    Note: everything you can do in Management Studio and Report Manager is
    accomplished through the SOAP API only. A RS 2005 report server supports
    both the old RS 2000 SOAP end point as well as the new RS 2005 SOAP end
    point.
    -- Robert
    This posting is provided "AS IS" with no warranties, and confers no rights.
    "Keith" <Keith@.discussions.microsoft.com> wrote in message
    news:F0703F74-3892-4D93-886D-3B9CECE05FF3@.microsoft.com...
    > We are wanting to utilize the tables in ReportServer and
    > ReportServerTempDB,
    > but do not want write any code that is dependent on the current version
    > (i.e.
    > RS 2005) of the tables in SRS. Does anyone know if MS has provided us
    > with
    > some data abstraction classes over the tables beyond the stored procedures
    > and methods available in the reportServive and reportExecutioon web
    > service
    > classes?
    > =====================> Thanks!
    > Keith
    > p.s. Get off the couch and exercise!|||Many thanks...I have found that the executionInfo class and ListJobs method
    will pretty much get us where we need to go.
    =====================Thanks!
    Keith
    p.s. Get off the couch and exercise!
    "Robert Bruckner [MSFT]" wrote:
    > The SOAP API is the supported interface; the underlying metadata structure
    > in the database will change between major releases (and maybe even service
    > packs).
    > Note: everything you can do in Management Studio and Report Manager is
    > accomplished through the SOAP API only. A RS 2005 report server supports
    > both the old RS 2000 SOAP end point as well as the new RS 2005 SOAP end
    > point.
    > -- Robert
    > This posting is provided "AS IS" with no warranties, and confers no rights.
    >
    > "Keith" <Keith@.discussions.microsoft.com> wrote in message
    > news:F0703F74-3892-4D93-886D-3B9CECE05FF3@.microsoft.com...
    > > We are wanting to utilize the tables in ReportServer and
    > > ReportServerTempDB,
    > > but do not want write any code that is dependent on the current version
    > > (i.e.
    > > RS 2005) of the tables in SRS. Does anyone know if MS has provided us
    > > with
    > > some data abstraction classes over the tables beyond the stored procedures
    > > and methods available in the reportServive and reportExecutioon web
    > > service
    > > classes?
    > >
    > > =====================> > Thanks!
    > > Keith
    > > p.s. Get off the couch and exercise!
    >
    >

    Reports Won't Deploy

    I'm stuck, any ideas? Is this a version or sp issue or a connection problem?
    SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
    All my service and accounts are set up fine, I can manually upload a report
    and data source to the report server, but VS 2005 will not deploy when the
    web server is set in the TargetServerURL property.
    The error I get is
    TITLE: Microsoft Report Designer
    A connection could not be made to the report server http://phxdb02/Reports.
    ADDITIONAL INFORMATION:
    The attempt to connect to the report server failed. Check your connection
    information and that the report server is a compatible version.
    (Microsoft.ReportingServices.Designer)
    The request failed with HTTP status 404: Not Found.
    (Microsoft.ReportingServices.Designer)You need to specify the ReportServer web service endpoint not the Report
    Manager url e.g. in your Project Properties for the TargetServerURL specify
    http://phxdb02/ReportServer
    --
    HTH,
    Jasper Smith (SQL Server MVP)
    http://www.sqldbatips.com
    "Scott" <Scott@.discussions.microsoft.com> wrote in message
    news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
    > I'm stuck, any ideas? Is this a version or sp issue or a connection
    > problem?
    > SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
    > All my service and accounts are set up fine, I can manually upload a
    > report
    > and data source to the report server, but VS 2005 will not deploy when the
    > web server is set in the TargetServerURL property.
    > The error I get is
    > TITLE: Microsoft Report Designer
    > A connection could not be made to the report server
    > http://phxdb02/Reports.
    > ADDITIONAL INFORMATION:
    > The attempt to connect to the report server failed. Check your connection
    > information and that the report server is a compatible version.
    > (Microsoft.ReportingServices.Designer)
    > The request failed with HTTP status 404: Not Found.
    > (Microsoft.ReportingServices.Designer)
    >|||Perfect! Thank you, that was it!!!
    "Jasper Smith" wrote:
    > You need to specify the ReportServer web service endpoint not the Report
    > Manager url e.g. in your Project Properties for the TargetServerURL specify
    > http://phxdb02/ReportServer
    > --
    > HTH,
    > Jasper Smith (SQL Server MVP)
    > http://www.sqldbatips.com
    >
    > "Scott" <Scott@.discussions.microsoft.com> wrote in message
    > news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
    > > I'm stuck, any ideas? Is this a version or sp issue or a connection
    > > problem?
    > >
    > > SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
    > > All my service and accounts are set up fine, I can manually upload a
    > > report
    > > and data source to the report server, but VS 2005 will not deploy when the
    > > web server is set in the TargetServerURL property.
    > >
    > > The error I get is
    > >
    > > TITLE: Microsoft Report Designer
    > >
    > > A connection could not be made to the report server
    > > http://phxdb02/Reports.
    > >
    > > ADDITIONAL INFORMATION:
    > >
    > > The attempt to connect to the report server failed. Check your connection
    > > information and that the report server is a compatible version.
    > > (Microsoft.ReportingServices.Designer)
    > >
    > > The request failed with HTTP status 404: Not Found.
    > > (Microsoft.ReportingServices.Designer)
    > >
    >
    >

    Monday, March 12, 2012

    Reports exported as Excel cannot be read by Mac version of Excel

    I searched the list but did not see anything related.

    I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

    I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

    Is there a work around for this?

    Thanks.

    --seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

    I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

    I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

    I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

    Thanks.

    |||

    Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

    Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

    |||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

    Thanks.

    --sean

    Reports exported as Excel cannot be read by Mac version of Excel

    I searched the list but did not see anything related.

    I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

    I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

    Is there a work around for this?

    Thanks.

    --sean
    i have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.
    |||

    I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

    I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

    I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

    Thanks.

    |||

    Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

    Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

    |||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

    Thanks.

    --sean

    Reports exported as Excel cannot be read by Mac version of Excel

    I searched the list but did not see anything related.

    I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

    I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

    Is there a work around for this?

    Thanks.

    --seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

    I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

    I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

    I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

    Thanks.

    |||

    Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

    Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

    |||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

    Thanks.

    --sean