Report Distribution based on SQL Query in RDL

I need to create multiple reports with each report being sent to the specified user. For example, 3 Managers should each get their own report. A Stored Procedure receives a ManagerID parameter, so I need 3 instances of the report. I also need each report to be sent to its associated Manager:

Mgr ID Manager Name 1 John Q Manager 2 Jane Q Manager 3 Jack O Lantern

I set up a rss file to run the report and can run it multiple times, passing in a different ID value each time, but it will not be data driven because I must hard-code the parameters in the ReportParmaters object of the report for each execution.

Is there a way, either by designing the report in VS2005 or on the Reporting Services server, to accomplish what I'm intending to do?

Did you already have a look on the datadriven subscription option in Reporting Services ? That would exactly fit your needs.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Report Delivery problem with Data Driven Subscription

I created a data driven subscription for a report that will email a copy of the report based on a parameter passed from a table. The report runs successfully as indicated in Report Manager but the email is not delivered. I checked the ReportServerService log file and a message states that the report was sent to the proper email address. There is another log, ReportServerWebApp, that shows the message "The extension Report Server Email does not have a LocalizedNameAttribute" .

I created a regular subscription and it emails the report successfully so it can't be the SMTP server.

Any ideas how I can fix this problem with the Data Driven Subscription? Thank you.

David

I did some further checking. If I send off a second job, it delivers the emailed reports. However, the problem persists with the second job.That is, Reporting Services indicates that the job ran successfully and delivered the reports, but some of the reports are getting stuck in a queue somewhere between the reporting server, the remote SMTP server and Microsoft Exchange.

Is there anyone else having problems with Reporting Services reports not getting fully delivered by a remote SMTP server? Would using a local SMTP server fix the problem?

David

|||Sorry for the delay with replying this. From the SSRS prospective your data driven subscription has been delivered to SMTP server successfully. Then SMTP server failed to deliver e-mal. Any chance that e-mail TO address is build off a data-driven subscription query results and is incorrect? Per every successfully sent e-mail SSRS will write into the service logfile ReportServerService__<Date>.log a line: Email successfully sent to {0}. Can you double check that TO addresses are correct for the cases that you thin are failing?|||

All of the reports are being sent to the same email address. Some get there successfully, others don't make it out of the queue.

David

|||

Then it really looks like a problem with SMTP server. It’s likely not related to SSRS.

-Igor

Report Delivery problem with Data Driven Subscription

I created a data driven subscription for a report that will email a copy of the report based on a parameter passed from a table. The report runs successfully as indicated in Report Manager but the email is not delivered. I checked the ReportServerService log file and a message states that the report was sent to the proper email address. There is another log, ReportServerWebApp, that shows the message "The extension Report Server Email does not have a LocalizedNameAttribute" .

I created a regular subscription and it emails the report successfully so it can't be the SMTP server.

Any ideas how I can fix this problem with the Data Driven Subscription? Thank you.

David

I did some further checking. If I send off a second job, it delivers the emailed reports. However, the problem persists with the second job.That is, Reporting Services indicates that the job ran successfully and delivered the reports, but some of the reports are getting stuck in a queue somewhere between the reporting server, the remote SMTP server and Microsoft Exchange.

Is there anyone else having problems with Reporting Services reports not getting fully delivered by a remote SMTP server? Would using a local SMTP server fix the problem?

David

|||Sorry for the delay with replying this. From the SSRS prospective your data driven subscription has been delivered to SMTP server successfully. Then SMTP server failed to deliver e-mal. Any chance that e-mail TO address is build off a data-driven subscription query results and is incorrect? Per every successfully sent e-mail SSRS will write into the service logfile ReportServerService__<Date>.log a line: Email successfully sent to {0}. Can you double check that TO addresses are correct for the cases that you thin are failing?|||

All of the reports are being sent to the same email address. Some get there successfully, others don't make it out of the queue.

David

|||

Then it really looks like a problem with SMTP server. It’s likely not related to SSRS.

-Igor

Report Builder: how to create a static report?

hi,
I have created a report based on a report builder model using Visual Studio.
This report will replace the default drill report.
so after I have published my report in report server, I'll modify my model
(model properties) to setup the drill through report of my customer entity.
When I save the new config I receive this error:
rsInvalidModelDrillthroughReport
/Models/DrillReports/Report1 is not a valid drill report.
so the question is, how to create a valid drill report'
there is some particular parameters to setup?
the help don't describe this.
any sample anywhere?
thanks.
Jerome.ok
I have missed some properties.
Now all works fine!!!!
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:ezZS2LuFGHA.140@.TK2MSFTNGP12.phx.gbl...
> hi,
> I have created a report based on a report builder model using Visual
> Studio.
> This report will replace the default drill report.
> so after I have published my report in report server, I'll modify my model
> (model properties) to setup the drill through report of my customer
> entity.
> When I save the new config I receive this error:
> rsInvalidModelDrillthroughReport
> /Models/DrillReports/Report1 is not a valid drill report.
> so the question is, how to create a valid drill report'
> there is some particular parameters to setup?
> the help don't describe this.
> any sample anywhere?
> thanks.
> Jerome.
>

report builder... click-through to a standard report (not a report builder based report)?

Hi,
In the administration page of RS2005, I see that its possible to specify a
target report for a click-through action.
but, does this report can be a standard reporting services report? (not a
report builder based report)
if yes, how this report must be configured to allow this type of
interaction?
thanks.
Jerome.ok, not sure i've understood your question as your english isn't that great
so i'll try and answer it.
i think you want to use the drill through function. So right click on the
item/text box/graph or whatever you want to drill through from and select
properties > Advanced > navigation > jump to report > pick a report to jump
to > parameters and assign the parameters.
right hope that answers your question, although this is a solution based on
rs2000 but can't imagine it is much differnt for rs2005.
Greg
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
> Hi,
> In the administration page of RS2005, I see that its possible to specify a
> target report for a click-through action.
> but, does this report can be a standard reporting services report? (not a
> report builder based report)
> if yes, how this report must be configured to allow this type of
> interaction?
> thanks.
> Jerome.
>|||no and yes ;-)
yes my english is bad...
no, I really mean CLICK through NOT drill through.
The Click through feature is a report builder capability ("infinite click
through") which allow a user to navigate in the data without having to
create a new report by himself.
When the user click (for example) on the # Sales, the system automatically
display the list of these sales with the customer name for example. then the
user click on the customer name and a new report is automatically created to
display the complete detail information of this particular customer. then
the user can click and click etc... number of created report only 1! the
first, all the other reports are created automatically.
but... the administrator can play a little around this by adding information
in the model to open a specific report instead-of the automatically
generated, but this feature appear to works only with a report created with
report builder.
so my question is: can I setup a report builder model to open a standard
reporting services report instead-of the report builder auto-generated one?
and this is a 2005 feature, not a 2000 one.
if you have never tested this, try it now!!!! its really a excellent
feature.
"Greg" <Greg.conn@.nospam.nospam> wrote in message
news:uPbXLfVBGHA.2356@.tk2msftngp13.phx.gbl...
> ok, not sure i've understood your question as your english isn't that
> great so i'll try and answer it.
> i think you want to use the drill through function. So right click on the
> item/text box/graph or whatever you want to drill through from and select
> properties > Advanced > navigation > jump to report > pick a report to
> jump to > parameters and assign the parameters.
> right hope that answers your question, although this is a solution based
> on rs2000 but can't imagine it is much differnt for rs2005.
> Greg
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> In the administration page of RS2005, I see that its possible to specify
>> a target report for a click-through action.
>> but, does this report can be a standard reporting services report? (not a
>> report builder based report)
>> if yes, how this report must be configured to allow this type of
>> interaction?
>> thanks.
>> Jerome.
>>
>|||sounds like a cool feature. might have a go at it and let you know how i
get on.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OHpClAcBGHA.3984@.TK2MSFTNGP14.phx.gbl...
> no and yes ;-)
> yes my english is bad...
> no, I really mean CLICK through NOT drill through.
> The Click through feature is a report builder capability ("infinite click
> through") which allow a user to navigate in the data without having to
> create a new report by himself.
> When the user click (for example) on the # Sales, the system automatically
> display the list of these sales with the customer name for example. then
> the user click on the customer name and a new report is automatically
> created to display the complete detail information of this particular
> customer. then the user can click and click etc... number of created
> report only 1! the first, all the other reports are created automatically.
> but... the administrator can play a little around this by adding
> information in the model to open a specific report instead-of the
> automatically generated, but this feature appear to works only with a
> report created with report builder.
> so my question is: can I setup a report builder model to open a standard
> reporting services report instead-of the report builder auto-generated
> one?
> and this is a 2005 feature, not a 2000 one.
> if you have never tested this, try it now!!!! its really a excellent
> feature.
>
> "Greg" <Greg.conn@.nospam.nospam> wrote in message
> news:uPbXLfVBGHA.2356@.tk2msftngp13.phx.gbl...
>> ok, not sure i've understood your question as your english isn't that
>> great so i'll try and answer it.
>> i think you want to use the drill through function. So right click on
>> the item/text box/graph or whatever you want to drill through from and
>> select properties > Advanced > navigation > jump to report > pick a
>> report to jump to > parameters and assign the parameters.
>> right hope that answers your question, although this is a solution based
>> on rs2000 but can't imagine it is much differnt for rs2005.
>> Greg
>>
>> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> news:e$MbEhlAGHA.912@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> In the administration page of RS2005, I see that its possible to specify
>> a target report for a click-through action.
>> but, does this report can be a standard reporting services report? (not
>> a report builder based report)
>> if yes, how this report must be configured to allow this type of
>> interaction?
>> thanks.
>> Jerome.
>>
>>
>

Report Builder, limiting the Dimensions

Hi,

I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.

It does work with Measure but not with Dimensions.

Appreciate if some one can drop a line here and help me out.

Thank you

Imran

You need to make manual changes to the model for this to happen.

1. Create a new Report Builder project.

2. Save the auto-generated SMDL file from Report Manager.

3. Add it to the Report Builder project.

4. Open the model in the Model Designer and select the root Model node.

5. On the right pane, right-click on the perspective desired and choose Edit.

6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.

7. When you are done, go back to the Report Manager and update the model (click the Update button).

HTH

|||

The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.

Imran

|||

I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.

|||

Ok...

I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.

Any help?

Thank You

Imran

|||

Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?

|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.

Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx

Even if try to modify the report builder model using other way, we canot get the achieved results.

--Imran

|||

I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.

Report Builder, limiting the Dimensions

Hi,

I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.

It does work with Measure but not with Dimensions.

Appreciate if some one can drop a line here and help me out.

Thank you

Imran

You need to make manual changes to the model for this to happen.

1. Create a new Report Builder project.

2. Save the auto-generated SMDL file from Report Manager.

3. Add it to the Report Builder project.

4. Open the model in the Model Designer and select the root Model node.

5. On the right pane, right-click on the perspective desired and choose Edit.

6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.

7. When you are done, go back to the Report Manager and update the model (click the Update button).

HTH

|||

The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.

Imran

|||

I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.

|||

Ok...

I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.

Any help?

Thank You

Imran

|||

Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?

|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.

Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx

Even if try to modify the report builder model using other way, we canot get the achieved results.

--Imran

|||

I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.

Report Builder, limiting the Dimensions

Hi,

I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.

It does work with Measure but not with Dimensions.

Appreciate if some one can drop a line here and help me out.

Thank you

Imran

You need to make manual changes to the model for this to happen.

1. Create a new Report Builder project.

2. Save the auto-generated SMDL file from Report Manager.

3. Add it to the Report Builder project.

4. Open the model in the Model Designer and select the root Model node.

5. On the right pane, right-click on the perspective desired and choose Edit.

6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.

7. When you are done, go back to the Report Manager and update the model (click the Update button).

HTH

|||

The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.

Imran

|||

I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.

|||

Ok...

I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.

Any help?

Thank You

Imran

|||

Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?

|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.

Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx

Even if try to modify the report builder model using other way, we canot get the achieved results.

--Imran

|||

I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.

sql

Report Builder, limiting the Dimensions

Hi,

I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.

It does work with Measure but not with Dimensions.

Appreciate if some one can drop a line here and help me out.

Thank you

Imran

You need to make manual changes to the model for this to happen.

1. Create a new Report Builder project.

2. Save the auto-generated SMDL file from Report Manager.

3. Add it to the Report Builder project.

4. Open the model in the Model Designer and select the root Model node.

5. On the right pane, right-click on the perspective desired and choose Edit.

6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.

7. When you are done, go back to the Report Manager and update the model (click the Update button).

HTH

|||

The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.

Imran

|||

I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.

|||

Ok...

I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.

Any help?

Thank You

Imran

|||

Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?

|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.

Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx

Even if try to modify the report builder model using other way, we canot get the achieved results.

--Imran

|||

I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.

Report Builder Error - Novice please suggest !!

I created report model based of three relational tables(SQL Db). When I try to run it gives me error 'cannot run this report - A filter must be specified'. When I supply filter it will go head and run.

Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.

A(id1) -> B(id1)

A(id2) -> C(id2)

1.Why is it asking me the enter filter?

2.Also, when I created a report based on fields from A,B and C I tried to do the click through.

I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.

3.Can I create a report model based on tables from different databases rather than from single database.?

I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.

Thanks in advance.

Prakash

1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.

2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.

3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.

Hope that helps!

|||

Thanks for your response.

Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.

Thanks !!

Report Builder Error - Novice please suggest !!

I created report model based of three relational tables(SQL Db). When I try to run it gives me error 'cannot run this report - A filter must be specified'. When I supply filter it will go head and run.

Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.

A(id1) -> B(id1)

A(id2) -> C(id2)

1.Why is it asking me the enter filter?

2.Also, when I created a report based on fields from A,B and C I tried to do the click through.

I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.

3.Can I create a report model based on tables from different databases rather than from single database.?

I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.

Thanks in advance.

Prakash

1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.

2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.

3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.

Hope that helps!

|||

Thanks for your response.

Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.

Thanks !!

Report Builder - Editing existing report

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

System.Web.Services.Protocols.SoapException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report.
at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)
at Microsoft.ReportingServices.Library.CreateReportAction.ConvertToIntermediate(Byte[] definition, Boolean usePermanentSnapshot, ItemProperties properties, CatalogItemContext reportContext, DateTime currentDate, Boolean checkAccessForSharedDatasources, ReportSnapshot& intermediateSnapshot, ParameterInfoCollection& parameters, Warning[]& warnings, DataSourceInfoCollection& dataSources, PageProperties& pageProperties)
at Microsoft.ReportingServices.Library.SetReportDefinitionAction._SetReportDefinition(String report, Byte[] definition)
at Microsoft.ReportingServices.Library.ReportCreator.UpdateExistingItem(String itemPath)
at Microsoft.ReportingServices.Library.CatalogItemCreator.CreateItem()
at Microsoft.ReportingServices.Library.CreateReportAction._CreateReport(String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Library.CreateReportAction.CreateReport(Guid batchId, String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

Nilesh Trivedi wrote:

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

I'm having this same problem. How can we be expected to create reports & modify if the client isn't smart enough to name textboxes uniquely. I get the error listed below in a messagebox (with a similar exception in the log files). All I do is open the report and try to save it. Can anyone from Microsoft (or anyone who has encountered and resolved) provide direction on this?

Regards,

Dan

More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report. > More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report.

|||

We have not heard of anyone else running into this. Will you use http://connect.microsoft.com to file a bug? Please attach the report (.rdl), model (.smdl), and data source view (.dsv).

|||

Thanks for the response. It doesn't occur every time, just with 1 or 2 specific reports.

I'm trying to see what I can do to reproduce it now. I was planning on submitting a bug when I can figure out what exactly causes it.

Report Builder - Editing existing report

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

System.Web.Services.Protocols.SoapException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report.
at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)
at Microsoft.ReportingServices.Library.CreateReportAction.ConvertToIntermediate(Byte[] definition, Boolean usePermanentSnapshot, ItemProperties properties, CatalogItemContext reportContext, DateTime currentDate, Boolean checkAccessForSharedDatasources, ReportSnapshot& intermediateSnapshot, ParameterInfoCollection& parameters, Warning[]& warnings, DataSourceInfoCollection& dataSources, PageProperties& pageProperties)
at Microsoft.ReportingServices.Library.SetReportDefinitionAction._SetReportDefinition(String report, Byte[] definition)
at Microsoft.ReportingServices.Library.ReportCreator.UpdateExistingItem(String itemPath)
at Microsoft.ReportingServices.Library.CatalogItemCreator.CreateItem()
at Microsoft.ReportingServices.Library.CreateReportAction._CreateReport(String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Library.CreateReportAction.CreateReport(Guid batchId, String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

Nilesh Trivedi wrote:

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

I'm having this same problem. How can we be expected to create reports & modify if the client isn't smart enough to name textboxes uniquely. I get the error listed below in a messagebox (with a similar exception in the log files). All I do is open the report and try to save it. Can anyone from Microsoft (or anyone who has encountered and resolved) provide direction on this?

Regards,

Dan

More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report. > More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report.

|||

We have not heard of anyone else running into this. Will you use http://connect.microsoft.com to file a bug? Please attach the report (.rdl), model (.smdl), and data source view (.dsv).

|||

Thanks for the response. It doesn't occur every time, just with 1 or 2 specific reports.

I'm trying to see what I can do to reproduce it now. I was planning on submitting a bug when I can figure out what exactly causes it.

Report based on XML

Hi,
How can I create a report with the actual data comming fom a self
created xml in memory (created in code, vb.net).
ThxYou have two choices. Use the new control that ships with VS.net 2005 (which
means you need to be using RS 2005) and use it in local mode. In local mode
no server is in the mix, you give it the data and the report and then the
control renders it. Or you need to create a data processing extension
(non-trivial).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"HDI" <hdinf@.hotmail.com> wrote in message
news:1167904120.780247.56220@.6g2000cwy.googlegroups.com...
> Hi,
> How can I create a report with the actual data comming fom a self
> created xml in memory (created in code, vb.net).
> Thx
>

Report based on temporary table

Hi
I need to create a report based on temporary table in oracle, table does not exist until stored procedure is executed. i am outputing a ref cursor but it shows no fields when i am creating the report.
help needed.
Regards
S RaheemEnter the correct values for which stored procedure will take|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor

I got it working now thanks all, but i got a new error in oracle temp tables..

Report based on Stored Procedure

Hi,
I have a report based on a stored procedure.
The stored procedure does some calculations and finally returns a query
based on a temporary table:
Select * from #Tmp
The problem is Reporting Services doesn't see the results based on a
#temporary table (no error, no rows!). If I change the stored procedure to
return an actual table in database, reporting services can see the results.
Ho can I have a report based on a stored procedure that returns a query
based on a temporary table?
Any help would be appreciated,
AlanAre you using the report designer and the data tab? Does the stored
procedure execute and return data from the data tab? If so, sometimes
executing the stored procedure does not fill the field list. Try
clicking on
the refresh fields button (look to the right of the ... , it looks like
the
fresh button for IE)|||You know, I have a similar problem. We have a stored procedure which returns
what is essentially a "data dictionary" with extended properties in a
temporary table. If I click the ! in the data tab, I see the full results of
the stored procedure. If I go to the preview tab, RS only sees the first
table and the first column of that table. I am jumping through hoops here
trying to get RS to see everything from this stored procedure.
I did see a note in a RS book somewhere that says RS can't see anything
beyond one record in a multi-record returned set. If that is so, though, why
can I see everything on the data tab? My next attempts have centered around
trying to create cascading parameters, but though the first stored procedure
returns me a drop down table list, the next stored procedure which requires a
tablename for input and outputs a column list for that table keeps saying
there are no fields for me to choose from to place on the report. Not to
mention that I can't figure out how to get the table name from the first
dataset to the second dataset for input.
ARGH! Can anyone give me some ideas or point me in a better direction than
these lousy RS Online help files? They're practically worthless! They don't
even have a searchable Index tab like BOL has.
Thanks in advance,
Catadmin
"A.M" wrote:
> Hi,
>
> I have a report based on a stored procedure.
> The stored procedure does some calculations and finally returns a query
> based on a temporary table:
>
> Select * from #Tmp
>
> The problem is Reporting Services doesn't see the results based on a
> #temporary table (no error, no rows!). If I change the stored procedure to
> return an actual table in database, reporting services can see the results.
>
> Ho can I have a report based on a stored procedure that returns a query
> based on a temporary table?
>
> Any help would be appreciated,
> Alan
>
>|||RS can handle one resultset. When you click on the !, the resultset you see
is what you have to work with. On the left should be a field list, if the
fields are not showing there that is the first thing you need to do (try the
refresh fields button, to the right of the ...). The dataset needs to be
associated with something. Drag a table onto the form and then drag fields
over to the table columns.
I think you need to back up and just try some simple queries and make sure
you know how to create a report. SP complicate things and you are try to
simultaneously learn too many things at once.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Catadmin" <Catadmin@.discussions.microsoft.com> wrote in message
news:5058D8C3-F2B9-4964-9D64-96849FEFC3DE@.microsoft.com...
> You know, I have a similar problem. We have a stored procedure which
returns
> what is essentially a "data dictionary" with extended properties in a
> temporary table. If I click the ! in the data tab, I see the full results
of
> the stored procedure. If I go to the preview tab, RS only sees the first
> table and the first column of that table. I am jumping through hoops here
> trying to get RS to see everything from this stored procedure.
> I did see a note in a RS book somewhere that says RS can't see anything
> beyond one record in a multi-record returned set. If that is so, though,
why
> can I see everything on the data tab? My next attempts have centered
around
> trying to create cascading parameters, but though the first stored
procedure
> returns me a drop down table list, the next stored procedure which
requires a
> tablename for input and outputs a column list for that table keeps saying
> there are no fields for me to choose from to place on the report. Not to
> mention that I can't figure out how to get the table name from the first
> dataset to the second dataset for input.
> ARGH! Can anyone give me some ideas or point me in a better direction
than
> these lousy RS Online help files? They're practically worthless! They
don't
> even have a searchable Index tab like BOL has.
> Thanks in advance,
> Catadmin
> "A.M" wrote:
> > Hi,
> >
> >
> >
> > I have a report based on a stored procedure.
> >
> > The stored procedure does some calculations and finally returns a query
> > based on a temporary table:
> >
> >
> >
> > Select * from #Tmp
> >
> >
> >
> > The problem is Reporting Services doesn't see the results based on a
> > #temporary table (no error, no rows!). If I change the stored procedure
to
> > return an actual table in database, reporting services can see the
results.
> >
> >
> >
> > Ho can I have a report based on a stored procedure that returns a query
> > based on a temporary table?
> >
> >
> >
> > Any help would be appreciated,
> >
> > Alan
> >
> >
> >|||Bruce,
Thank you for your response. You are correct, I am trying to learn the
whole thing at once. My problem is that I went from one job that used
Crystal to another job that doesn't, they only use RS, and I'm expected to
finish this project that the previous DBA left unfinished. Given the time
limit I'm on, I'm not sure they're going to let me take my time and learn it.
Also, I can do simple queries. I just did two of them today. I think my
problem is in the grouping, if that makes sense. In Crystal, you could
create groups to do for a report what a cursor does for SQL, loop back and
catch the rest of the data. I've seen how to do so using the Report Wizard,
but, as I posted in another post just a little while ago, I can't figure out
how to do groups from a blank report screen. On top of that, I'm learning
how to use the fn_listextendedproperty function to pull the table and column
descrips, and my day has been a serious exercise in frustration. I think I'll
go try to drown myself in the gigantic fountain out front of the office. @.=P
If I can just figure out how to pull the fn_listextendedproperty function
into the report with the other fields without having to use the stored
procedures, AND/OR how to group on a blank report, I might have a work around
that should keep the boss happy for a while so I can go and learn things the
proper way.
Ah, well. Such is the life... @.=) Thanks, again.
Catadmin
"Bruce L-C [MVP]" wrote:
> RS can handle one resultset. When you click on the !, the resultset you see
> is what you have to work with. On the left should be a field list, if the
> fields are not showing there that is the first thing you need to do (try the
> refresh fields button, to the right of the ...). The dataset needs to be
> associated with something. Drag a table onto the form and then drag fields
> over to the table columns.
> I think you need to back up and just try some simple queries and make sure
> you know how to create a report. SP complicate things and you are try to
> simultaneously learn too many things at once.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Catadmin" <Catadmin@.discussions.microsoft.com> wrote in message
> news:5058D8C3-F2B9-4964-9D64-96849FEFC3DE@.microsoft.com...
> > You know, I have a similar problem. We have a stored procedure which
> returns
> > what is essentially a "data dictionary" with extended properties in a
> > temporary table. If I click the ! in the data tab, I see the full results
> of
> > the stored procedure. If I go to the preview tab, RS only sees the first
> > table and the first column of that table. I am jumping through hoops here
> > trying to get RS to see everything from this stored procedure.
> >
> > I did see a note in a RS book somewhere that says RS can't see anything
> > beyond one record in a multi-record returned set. If that is so, though,
> why
> > can I see everything on the data tab? My next attempts have centered
> around
> > trying to create cascading parameters, but though the first stored
> procedure
> > returns me a drop down table list, the next stored procedure which
> requires a
> > tablename for input and outputs a column list for that table keeps saying
> > there are no fields for me to choose from to place on the report. Not to
> > mention that I can't figure out how to get the table name from the first
> > dataset to the second dataset for input.
> >
> > ARGH! Can anyone give me some ideas or point me in a better direction
> than
> > these lousy RS Online help files? They're practically worthless! They
> don't
> > even have a searchable Index tab like BOL has.
> >
> > Thanks in advance,
> >
> > Catadmin
> >
> > "A.M" wrote:
> >
> > > Hi,
> > >
> > >
> > >
> > > I have a report based on a stored procedure.
> > >
> > > The stored procedure does some calculations and finally returns a query
> > > based on a temporary table:
> > >
> > >
> > >
> > > Select * from #Tmp
> > >
> > >
> > >
> > > The problem is Reporting Services doesn't see the results based on a
> > > #temporary table (no error, no rows!). If I change the stored procedure
> to
> > > return an actual table in database, reporting services can see the
> results.
> > >
> > >
> > >
> > > Ho can I have a report based on a stored procedure that returns a query
> > > based on a temporary table?
> > >
> > >
> > >
> > > Any help would be appreciated,
> > >
> > > Alan
> > >
> > >
> > >
>
>|||I have some udf's but I have only used them from within my sp. I'll try
using one from RS query window and let you know how it goes.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:EE98488F-5D23-4BA6-9239-AB950052B508@.microsoft.com...
> Bruce,
> Thank you for your response. You are correct, I am trying to learn the
> whole thing at once. My problem is that I went from one job that used
> Crystal to another job that doesn't, they only use RS, and I'm expected to
> finish this project that the previous DBA left unfinished. Given the time
> limit I'm on, I'm not sure they're going to let me take my time and learn
> it.
> Also, I can do simple queries. I just did two of them today. I think my
> problem is in the grouping, if that makes sense. In Crystal, you could
> create groups to do for a report what a cursor does for SQL, loop back and
> catch the rest of the data. I've seen how to do so using the Report
> Wizard,
> but, as I posted in another post just a little while ago, I can't figure
> out
> how to do groups from a blank report screen. On top of that, I'm learning
> how to use the fn_listextendedproperty function to pull the table and
> column
> descrips, and my day has been a serious exercise in frustration. I think
> I'll
> go try to drown myself in the gigantic fountain out front of the office.
> @.=P
> If I can just figure out how to pull the fn_listextendedproperty function
> into the report with the other fields without having to use the stored
> procedures, AND/OR how to group on a blank report, I might have a work
> around
> that should keep the boss happy for a while so I can go and learn things
> the
> proper way.
> Ah, well. Such is the life... @.=) Thanks, again.
> Catadmin
> "Bruce L-C [MVP]" wrote:
>> RS can handle one resultset. When you click on the !, the resultset you
>> see
>> is what you have to work with. On the left should be a field list, if the
>> fields are not showing there that is the first thing you need to do (try
>> the
>> refresh fields button, to the right of the ...). The dataset needs to be
>> associated with something. Drag a table onto the form and then drag
>> fields
>> over to the table columns.
>> I think you need to back up and just try some simple queries and make
>> sure
>> you know how to create a report. SP complicate things and you are try to
>> simultaneously learn too many things at once.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Catadmin" <Catadmin@.discussions.microsoft.com> wrote in message
>> news:5058D8C3-F2B9-4964-9D64-96849FEFC3DE@.microsoft.com...
>> > You know, I have a similar problem. We have a stored procedure which
>> returns
>> > what is essentially a "data dictionary" with extended properties in a
>> > temporary table. If I click the ! in the data tab, I see the full
>> > results
>> of
>> > the stored procedure. If I go to the preview tab, RS only sees the
>> > first
>> > table and the first column of that table. I am jumping through hoops
>> > here
>> > trying to get RS to see everything from this stored procedure.
>> >
>> > I did see a note in a RS book somewhere that says RS can't see anything
>> > beyond one record in a multi-record returned set. If that is so,
>> > though,
>> why
>> > can I see everything on the data tab? My next attempts have centered
>> around
>> > trying to create cascading parameters, but though the first stored
>> procedure
>> > returns me a drop down table list, the next stored procedure which
>> requires a
>> > tablename for input and outputs a column list for that table keeps
>> > saying
>> > there are no fields for me to choose from to place on the report. Not
>> > to
>> > mention that I can't figure out how to get the table name from the
>> > first
>> > dataset to the second dataset for input.
>> >
>> > ARGH! Can anyone give me some ideas or point me in a better direction
>> than
>> > these lousy RS Online help files? They're practically worthless! They
>> don't
>> > even have a searchable Index tab like BOL has.
>> >
>> > Thanks in advance,
>> >
>> > Catadmin
>> >
>> > "A.M" wrote:
>> >
>> > > Hi,
>> > >
>> > >
>> > >
>> > > I have a report based on a stored procedure.
>> > >
>> > > The stored procedure does some calculations and finally returns a
>> > > query
>> > > based on a temporary table:
>> > >
>> > >
>> > >
>> > > Select * from #Tmp
>> > >
>> > >
>> > >
>> > > The problem is Reporting Services doesn't see the results based on a
>> > > #temporary table (no error, no rows!). If I change the stored
>> > > procedure
>> to
>> > > return an actual table in database, reporting services can see the
>> results.
>> > >
>> > >
>> > >
>> > > Ho can I have a report based on a stored procedure that returns a
>> > > query
>> > > based on a temporary table?
>> > >
>> > >
>> > >
>> > > Any help would be appreciated,
>> > >
>> > > Alan
>> > >
>> > >
>> > >
>>