Thursday, March 8, 2012

An error has occurred during report processing

Hi,
I've been working through Teo Lachev's 'Custom DataSet Data Extension for
Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
I've built and deployed the DataSet Extension as specifed in the
documentation. I've also adjusted the security config files to insert the new
code group.
I've successfully created the Data Source and the DataSet.
However, I'm getting the following problems from within the report designer.
1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
@.DataSource parameter *nothing* is added to the fields toolbar.
2) When I click the preview tab I get the following error dialog:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
Any ideas or pointer would be much appreciated. Thanks>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
After checking some previous posts I can confirm that I'm running the latest
SP1 on my box.
I've tried connecting to a couple of different .xsd files but am still
getting the same error:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
Does anyone have further pointers I could check?
Thanks
Hans|||Hans Gruber" <Hans Gruber@.discussions.microsoft.com> wrote in message
news:20D93706-74F5-4BF1-9680-7FC6077EFEBD@.microsoft.com...
> Hi,
>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the
new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report
designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed
for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
I've been getting the exact same error.
Is there anyone from Microsoft who can help with this?

No comments:

Post a Comment