Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahfoozelahi
Starting Member
5 Posts |
 Posted - 2005-06-30 : 14:46:48
|
| My ADE starts flickering when I try to change the value of parameters after it runs for the first time with default values of the parameters! Besides I got the following error when I tried doing the preview on the report:Processing ErrorsAn unexpected error occurred in report processing.Exception of type Microsoft.ReportingServices.ReportProcessing.aw was thrown.Here's the query with four parameters:DECLARE @sql nvarchar(4000)SET @sql = 'Select content_id, content_title, folder_name, user_firstname + '' '' + user_lastname [USER], date_modified [Date Pub.], history_comment, users.first_name + '' '' + users.last_name [Approver] from Content_history, content_folder_tbl, users 'SET @sql = @sql + 'where content_history.folder_id = content_folder_tbl.folder_id AND content_history.approved_ids = users.user_id AND content_status = ''A'' AND date_modified BETWEEN ''' + @StartDate + ''' and ''' + @EndDate + '''' IF @name <> 'ALL' BEGIN SET @sql = @sql + ' AND user_firstname + '' '' + user_lastname = ''' + @name + '''' END BEGINSET @sql = @sql + ' Order by ' + @field1 ENDexec(@sql)Anybody with any idea?Thanks.Mahfooz |
|
|
WesleyB
Starting Member
2 Posts |
Posted - 2005-07-29 : 07:08:00
|
| Hi,I can't help you with the flickering but the export maybe has something to do with the following conditions:1) You are using a table2) One or more of the detail fields use HideDuplicates3) There is a subreport in the reportIf so, this is clearly a problem in RS but I haven't found a solution yet :(Kind regards,Wesley Backelanthttp://dis4ea.blogspot.com |
 |
|
|
|
|
|
Flickering of ADE