I had to reinstall the module a few times, but always version 4.3, downloaded from your site.

The path I followed was:

- Installed DNN Reports module (unrelated I presume) on 5.4.1, did not get this to work   properly
- Installed MM Reporting Services
    - got KeyNotFoundException exception during installation
    - Upgraded site to DNN 5.4.2
    - finally fixed this via instructions in this thread.
    - Did a few re-installs of the module in this process.
- Got Object not found (or null reference) error->fixed my config
- Got the Date conversion error.
- Hit the forums and here we are.

Hi, we had the same errormessage in locale nl-NL. 

We fixed it this way:
1) Uninstall the module
2) Go to host -> sql, check run as script box and paste this code in there and run it.

delete from {databaseOwner}{objectQualifier}ModuleSettings
where moduleid in (select moduleid from {databaseOwner}{objectQualifier}ModuleSettings
where settingname = 'ModuleDefaultDate');

3) Reinstall the module
4) Use a portal with language setting "en-US"   <- important
5) Drop the module on this page
6) Reactivate. 

After activation it will work in all languages.

The given instructions appear to work, but now when I request the report, the reportviewer is not functioning properly:

 
The same thing happend when I tried the DNN reports module so I assume there is something wrong with the ReportViewer.dll?

We've seen that one before too...

Are you using IIS7? Check your web.config file ! The reference to the viewercontrol needs to be in the system.webServer section too, with the "Integrated" mode enabled.


    
        ..
    
    
        preCondition="integratedMode,runtimeVersionv2.0" />
    ...
    

hmm that looked crazy... replace [] with appropriate tags

[section.webServer]
    [module]
        ...
    [/module]
    [handler]
        [add name="ReportViewerHandler" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" preCondition="integratedMode,runtimeVersionv2.0"/]
    ...
    [/handler]
[/section.webServer]

You are fantastic, thanks for the quick reply!

It's working now, I found a workaround at ReportXP's site but that meant changing the whole application model.

This is much better. I did not even have the handler you specify. I had a verb present but I understand IIS7 will look at the handlers section over the httpHandlers section.

Thank for all the support quick and proficient support!

Uhm.. I just activated the software and got the datetime bug. Redownloaded from the link in the mail message (RS2005_040300.zip dd. 17 june 2010?), uninstalled en reinstalled, but the bug is still happening.

I will try the workaround but I thought this shouldn't be necessary anymore?

The original error:

ModuleId: 685
ModuleDefId: 149
FriendlyName: Bezettingsprognose
ModuleControlSource: DesktopModules/RS2005/ViewRS2005.ascx
AssemblyVersion: 5.4.2
PortalID: 0
PortalName: AMZ Extranet
UserID: 1
UserName: host
ActiveTabID: 227
ActiveTabName: Bezettingsprognose
RawURL: /Default.aspx?tabid=227&language=nl-NL
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://extranet/Default.aspx?tabid=227&language=nl-NL
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.5; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 1d70317f-8df7-4980-8947-ba13c2ddd378
InnerException: De tekenreeks is niet als geldige DateTime herkend.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.DateTimeParse.ParseExact
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: De tekenreeks is niet als geldige DateTime herkend. ---> System.FormatException: De tekenreeks is niet als geldige DateTime herkend. bij System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style) bij BeckerSolutions.Modules.RS2005.ViewRS2005.CheckStatus() bij BeckerSolutions.Modules.RS2005.ViewRS2005.Page_Load(Object sender, EventArgs e) --- Einde van intern uitzonderingsstackpad ---

During the final reinstall, after the SQL fix and switching to EN-us:

...

Info:: Start uitvoer Sql: 01.02.00.SqlDataProvider bestand
Info:: SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Domain' in table 'dbo.RS2005Servers' is specified more than once. bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bij System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bij DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bij DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Create Table **/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RS2005Servers') and OBJECTPROPERTY(id, N'IsTable') = 1) ALTER TABLE dbo.RS2005Servers ADD [Domain] varchar(100)
Info:: Einde Sql uitvoer: 01.02.00.SqlDataProvider gereed
Info:: Backup van vorige versie wordt gemaakt - 01.04.00.SqlDataProvider
Info:: Aangemaakt - 01.04.00.SqlDataProvider
Info:: Uitvoeren01.04.00.SqlDataProvider
Info:: Start uitvoer Sql: 01.04.00.SqlDataProvider bestand
Info:: SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PortalId' in table 'dbo.RS2005Servers' is specified more than once. bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bij System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bij DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) bij DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Alter Table **/ /** Change Log --added portalid **/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RS2005Servers') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN ALTER TABLE dbo.[RS2005Servers] ADD [PortalId] INT NULL END
Info:: Einde Sql uitvoer: 01.04.00.SqlDataProvider gereed

This doesn't seem to have given any problems though, the activated module now works correct.

The bug first showed when I tried to activate (NL-nl) and then after reinstalling the latest version. Only after performing the SQL fix and switching languages did the install and activitation succeed.