When running a report for active subscriptions I get this error (1.3.1 & DNN 4.5.5)

Error: View Reports is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: ALTER TABLE DROP COLUMN failed because 'RowText' is the only data column in table '#Rows'. A table must have at least one data column. ---> System.Data.SqlClient.SqlException: ALTER TABLE DROP COLUMN failed because 'RowText' is the only data column in table '#Rows'. A table must have at least one data column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DnnForge.SubscriptionTools.SqlDataProvider.ListReport(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Entities.ReportController.List(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Reports.cmdDisplay_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

Jack, I was having your same problem with report type "Subscriptions Expiring".

In my opinion, there is a small bug in the stored procedure DnnForge_SubscriptionTools_GetReport1

I've changed

     SET @SQL = ' SELECT ''Total Memberships       '' as Role, '

in

     SET @SQL = ' SELECT ''Total Memberships                                 '' as Role, '

and now the module works fine.

To avoid problems the string must be 50 characters long, just because [Name] is varchar(50) in the table DnnForge_SubscriptionTools_Receipt

I can confirm that this fixed the problem.  Scott, can you please update the source?