Error: Forward dependencies are not valid

I want to set a Report Parameter on a field. The Report Parameter is called 'filter'. In the statement I put the Report Parameter in the WHERE-part:
WHERE ([DatabaseName$TableName].[FieldName] = @.filter). After this I set the 'Available values' on the Report Parameter in the lay-out to Non-queried.
When the report is running, no problems.

But.....

Now I want to set 'Available values' on 'From Query' and refer to the data set, so the user can choose on which value he want to filter. But now, after running the preview the following error displays:
Error1[rsInvalidReportParameterDependency]The report parameter ‘filter’ has a DefaultValue or a ValidValue that depends on the report parameter “filter”. Forward dependencies are not valid.

Why can't I set the Report Parameter to 'From Query'? Anyone any suggestions?

(you can see the rest of my statement here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1098540&SiteID=1)

Thx a lot of helping me out with this topic.....

Hi,

If I get it right, you have a dataset that you want to filter by a parameter 'FILTER' and the possible values for the filter also from the same dataset?

This is not possible since if you are requesting the possible values for the filter he will execute the query in the dataset. Since this dataset requires a parameter filter to be able to execute, you are having a loop.

What you should do is to make the 'From Query' property refer to a different dataset.

NOTE: Reporting Services first performs the queries in the same order as the Parameters have been set. Therefor, if the dataset of a given parameter needs the value of a second parameter, you need to make sure that this second parameter is standing above the first parameter in the parameter list.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Geert,

thx for your support. I've found a solution for my specific situation. I will drop it here for others with the same problem:

1. Report Parameter, Available non-queried.
- At Label I've filled in the options that I want to see in the pulldown menu.
- At Value I've filled in the values form my table (in this case only 4 or 5)
2. At the table properties, tab filtering I've made a filterlist called
- expression: =Fields!FieldName.Value
- operator: '='
- value : =Parameters!ParameterName.Value

This solution is only usefull if you don't have too much options to choose (because you have to fill in all the options manually..... )

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:\DOCUME~1\

Hello,

I am having a crystal report using datastored in a dataset. When I select one of items in a dropdownlist, it gives me this error message. Note that I used that code before in another web page using a different crystal report and a different dataSet and it worked successfully, but this time it doesn't work...anyone can tell me what causes this error and how to solve it?

NOTE: I am using a vb code behind in my .aspx page

Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt:Error in formula <Record_Selection>. '{StProd2.ItemDescription}'The result of selection formula must be a boolean.]  . F(String  , EngineExceptionErrorID  )  . A(Int16   , Int32   )  . @.(Int16  ) CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) CrystalDecisions.Web.ReportAgent.u(Boolean  N) CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Page.ProcessRequestMain()

Dear Frnd',

It will nice if you provied more info, like in drop you are selecting which report to get or some value on which parameter it get the dataset.

or what are the datatype in database & on report.

Some more detail need to get it root.

Error: connection is busy with results for another hstmt

Good Afternoon. I have a Crystal report that accesses a sql 2000 server. W
hen I run the report twice with the same parrameters. I get the following e
rror:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and something
to the effect that my report is not consuming everything and therefore leavi
ng a cursor.
And while I understand that for the most part, I can't even begin to think h
ow to troubleshoot the report and find the problem. It's a HUGE report with
excess of 30 subreports. It is designed to only return 1 record, with nume
rous fields from throughout
the database placed on the report. Like I said it has numerous subreports,
and all are linked to the same URN. Anyway, is there anything I can do shor
t of upgrading the server to 2005?
From http://www.developmentnow.com/g/111...server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comafter nearly 30 hours of searching, I finally posted my question here.
What's funny is that 2 hours later I found my answer:
http://support.microsoft.com/kb/173410
From http://www.developmentnow.com/group...
=995268
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Error: connection is busy with results for another hstmt

Good Afternoon. I have a Crystal report that accesses a sql 2000 server. When I run the report twice with the same parrameters. I get the following error:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and something to the effect that my report is not consuming everything and therefore leaving a cursor.
And while I understand that for the most part, I can't even begin to think how to troubleshoot the report and find the problem. It's a HUGE report with excess of 30 subreports. It is designed to only return 1 record, with numerous fields from throughout the database placed on the report. Like I said it has numerous subreports, and all are linked to the same URN. Anyway, is there anything I can do short of upgrading the server to 2005?
From http://www.developmentnow.com/g/111_2007_7_0_0_0/sql-server-odbc.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
after nearly 30 hours of searching, I finally posted my question here.
What's funny is that 2 hours later I found my answer:
http://support.microsoft.com/kb/173410
From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=111&threadid=995268
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Error: Cannot impersonate user for data source

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)

Logon failed. (rsLogonFailed)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any help would be greatly appreciated. Thank you.

Can you enable remote errors so we can see the detailed error message:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230635&SiteID=1

sql

Error: Application for .reportproj not installed

Getting error when try to open report project:
The application for D:\Documents and Settings\Administrator\My
Documents\Visual Studio Projects\WinfundsReports.rptproj is not installed.
Make surethe application for the project type (.rptproj) is installed.
Everything had been working fine for a year!
Note: Busuness Intelligence Projects no longer appears in the list of
available project types when setting up new project.
Is this controlled by something in the config files, or will I have to
reinstall Rptg Services?
Thanks.
AlanFollowup Question:
Is there a file that will re-register reporting services withou a complete
re-install?
Thanks.
Alan

Error: 18456, Severity: 14, State: 16.

I'm getting login errors when trying to run reports both locally on the
report server and remotely on a client machine.
This is the error I get:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'RequestDataSource'.
(rsErrorOpeningConnection)
Cannot open database "<database name>" requested by the login. The login
failed. Login failed for user "<domain\username>".
Here's what I see in my SQL log:
2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
[CLIENT: <local machine>]
The user is a domain admin and has full rights to all the databases on the
database server.
Any insight would be apprecaited. Thanks!On Feb 26, 1:57 pm, Henry <H...@.discussions.microsoft.com> wrote:
> I'm getting login errors when trying to run reports both locally on the
> report server and remotely on a client machine.
> This is the error I get:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'RequestDataSource'.
> (rsErrorOpeningConnection)
> Cannot open database "<database name>" requested by the login. The login
> failed. Login failed for user "<domain\username>".
> Here's what I see in my SQL log:
> 2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
> 2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
> [CLIENT: <local machine>]
> The user is a domain admin and has full rights to all the databases on the
> database server.
> Any insight would be apprecaited. Thanks!
Sometimes this occurs when the datasource has not yet been set up -or-
has not been set up correctly.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Error: [rsMissingDataSetName] The data set name is missing in the data region ?DataSetName

This error occured under the following circumstances:
1. Had an existing report that was working with 1 DataSet.
2. Added 1 new Dataset with the same data source as the existing Dataset.
Query was very simple: Select * from TableA.
3. Tested Query. Returned correct results.
4. Selected Preview and get the following message:
[rsMissingDataSetName] The data set name is missing in the data region ?DataSetName?
THis happens no matter what dataset is added.
I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
Any idea how to fix it?
Thanks
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou need to set the dataset name in the properties, of the table or chart
you are using. Just select the whole table or chart, right click, click
properties and fill in the dataset.
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||You have some region or table or something on the report that pointed to a
dataset that no longer exists. Or, and reading closer this might be what is
happening, you have a data region without a dataset. Go to layout and you
can click on your different regions and then in the properties set it to you
existing dataset.
One other thing that has happened to me before, I ended up with some data
region defined in the xml source (the report definition is XML) that was not
visible from the development environment. Save your report somewhere before
doing this (click on report in the report list, ctl-C, ctrl-V). Now you can
view code of the report and search for DataSetName and see where you find
it. The XML is pretty seld explanatory in most cases.
Lastly, just create a new report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||Thanks all.The table in the Report must have automatically defaulted to
the 1 dataset I had. When I added the second one it didn't know which
one to use.
I set it to the correct one and all is working.
Thanks much!
Kevin|||Hey Kevin,
In reporting services layout, Select your table (or what ever object you're
building the report with), right click it, go to properties and select the
other data set
from the drop down box.
This should work .
Good Luck..
Scott
"Kevin" wrote:
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region â'DataSetNameâ'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Error: [rsInvalidReportParameterDependency]

How should I resolve the following error?
ERROR:
[rsInvalidReportParameterDependency] The report parameter â'Companyâ' has a
DefaultValue or a ValidValue that depends on the report parameter â'Companyâ'.
Forward dependencies are not valid.It would seem that you need to fetch company in a separate query and use its
results to pass values to the second query.
"Terry" wrote:
> How should I resolve the following error?
>
> ERROR:
> [rsInvalidReportParameterDependency] The report parameter â'Companyâ' has a
> DefaultValue or a ValidValue that depends on the report parameter â'Companyâ'.
> Forward dependencies are not valid.
>|||Could you please provide me with an example?
"William" wrote:
> It would seem that you need to fetch company in a separate query and use its
> results to pass values to the second query.
> "Terry" wrote:
> > How should I resolve the following error?
> >
> >
> > ERROR:
> >
> > [rsInvalidReportParameterDependency] The report parameter â'Companyâ' has a
> > DefaultValue or a ValidValue that depends on the report parameter â'Companyâ'.
> > Forward dependencies are not valid.
> >
> >

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

Error: "no report servers were found on the specified machine"

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

Are you using the config tool to manage a remote RS server?|||I'm getting this too but it's on the local box.|||

NoEgo wrote:

Error: "no report servers were found on the specified machine"

I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past.

|||

Hello there, is got solved for me by running SQL Setup and selecting a new component (Reporting Services). See my post at http://blogs.msdn.com/dszabo/archive/2007/04/10/quot-no-report-servers-were-found-on-the-specified-machine-quot.aspx for more details.

David

Error: "EXECUTE permission denied on object..."

I get this error when I try to preview a report that uses a stored procedure. The stored procedure does not exist in the database, but in the directory I run the report from. The stored procedure declares which database to use, and to create the temp table I want. Do I require special permissions on the sql db I am using to be able to create temp tables? Any help would be great, thanks!

Michael

How are you connecting to the stored procedure in a directory?

SQL Profiler may let you troubleshoot what user account and object this error message relates to.

|||

I had a developer do this awhile ago too; you require elevated permissions to create tables. Try just clearing the table rather than deleting and recreating the table every time the report is run it requires less security.

Error: "expression can only refer to field w/ data scope"

I get the following error when i try to add a new field being returned in a
dataset:
"Report item expressions can only refer to fields within the current data
set scope or, if inside an aggregate, the specified data set scope".
I have no idea what this means, and i can reference just fine every other
field i'm returning in the dataset.
I found an earlier person who had this problem, and the response was "you
can only bind one dataset to a report item". This can't be my problem,
though, as i've only GOT one dataset.
TIA,
--
BrianSide note (may not be the solution to your problem):
You can bind more than one dataset to a report! I've done this
successfully, and it's actually pretty easy.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I get the following error when i try to add a new field being returned in
a
> dataset:
> "Report item expressions can only refer to fields within the current data
> set scope or, if inside an aggregate, the specified data set scope".
> I have no idea what this means, and i can reference just fine every other
> field i'm returning in the dataset.
> I found an earlier person who had this problem, and the response was "you
> can only bind one dataset to a report item". This can't be my problem,
> though, as i've only GOT one dataset.
> TIA,
> --
> Brian
>|||Both comments below are true: You can have several datasets in a **report**
but only bind one dataset to a **report item**.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQL" <nospam@.adfadfadf.com> wrote in message
news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> Side note (may not be the solution to your problem):
> You can bind more than one dataset to a report! I've done this
> successfully, and it's actually pretty easy.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I get the following error when i try to add a new field being returned
in
> a
> > dataset:
> >
> > "Report item expressions can only refer to fields within the current
data
> > set scope or, if inside an aggregate, the specified data set scope".
> >
> > I have no idea what this means, and i can reference just fine every
other
> > field i'm returning in the dataset.
> >
> > I found an earlier person who had this problem, and the response was
"you
> > can only bind one dataset to a report item". This can't be my problem,
> > though, as i've only GOT one dataset.
> >
> > TIA,
> >
> > --
> > Brian
> >
> >
>|||That's all well and good, but none of these apply to my situation! I have
only one dataset, period, yet i'm getting this error.
Is there another problem that could cause this sort of error?
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> Both comments below are true: You can have several datasets in a
**report**
> but only bind one dataset to a **report item**.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "SQL" <nospam@.adfadfadf.com> wrote in message
> news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > Side note (may not be the solution to your problem):
> >
> > You can bind more than one dataset to a report! I've done this
> > successfully, and it's actually pretty easy.
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I get the following error when i try to add a new field being returned
> in
> > a
> > > dataset:
> > >
> > > "Report item expressions can only refer to fields within the current
> data
> > > set scope or, if inside an aggregate, the specified data set scope".
> > >
> > > I have no idea what this means, and i can reference just fine every
> other
> > > field i'm returning in the dataset.
> > >
> > > I found an earlier person who had this problem, and the response was
> "you
> > > can only bind one dataset to a report item". This can't be my problem,
> > > though, as i've only GOT one dataset.
> > >
> > > TIA,
> > >
> > > --
> > > Brian
> > >
> > >
> >
> >
>|||Found it!!!!
Dunno if this is a bug or expected behavior or what but....
I was using the custom query designer because i had a rather dynamic query
to write. When i added a new field in the return set, that field was NOT
automatically added to the field list in the dataset returned fields window.
I had to manually add that field. Solved the problem.
Brian
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:OIUd%23Y6fEHA.236@.tk2msftngp13.phx.gbl...
> That's all well and good, but none of these apply to my situation! I have
> only one dataset, period, yet i'm getting this error.
> Is there another problem that could cause this sort of error?
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> > Both comments below are true: You can have several datasets in a
> **report**
> > but only bind one dataset to a **report item**.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "SQL" <nospam@.adfadfadf.com> wrote in message
> > news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > > Side note (may not be the solution to your problem):
> > >
> > > You can bind more than one dataset to a report! I've done this
> > > successfully, and it's actually pretty easy.
> > >
> > >
> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > > I get the following error when i try to add a new field being
returned
> > in
> > > a
> > > > dataset:
> > > >
> > > > "Report item expressions can only refer to fields within the current
> > data
> > > > set scope or, if inside an aggregate, the specified data set scope".
> > > >
> > > > I have no idea what this means, and i can reference just fine every
> > other
> > > > field i'm returning in the dataset.
> > > >
> > > > I found an earlier person who had this problem, and the response was
> > "you
> > > > can only bind one dataset to a report item". This can't be my
problem,
> > > > though, as i've only GOT one dataset.
> > > >
> > > > TIA,
> > > >
> > > > --
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>|||Either that or you can use the static version of the query first, which will
populate the fields list for you, and then replace it with the the
corresponding query expression.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:up0IDI7fEHA.2020@.TK2MSFTNGP10.phx.gbl...
> Found it!!!!
> Dunno if this is a bug or expected behavior or what but....
> I was using the custom query designer because i had a rather dynamic query
> to write. When i added a new field in the return set, that field was NOT
> automatically added to the field list in the dataset returned fields
window.
> I had to manually add that field. Solved the problem.
> Brian
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:OIUd%23Y6fEHA.236@.tk2msftngp13.phx.gbl...
> > That's all well and good, but none of these apply to my situation! I
have
> > only one dataset, period, yet i'm getting this error.
> >
> > Is there another problem that could cause this sort of error?
> >
> >
> > "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in
message
> > news:Ot5fX7xfEHA.1048@.tk2msftngp13.phx.gbl...
> > > Both comments below are true: You can have several datasets in a
> > **report**
> > > but only bind one dataset to a **report item**.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > "SQL" <nospam@.adfadfadf.com> wrote in message
> > > news:ufCl4HxfEHA.2812@.tk2msftngp13.phx.gbl...
> > > > Side note (may not be the solution to your problem):
> > > >
> > > > You can bind more than one dataset to a report! I've done this
> > > > successfully, and it's actually pretty easy.
> > > >
> > > >
> > > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > > news:#jeQ0rwfEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > > > I get the following error when i try to add a new field being
> returned
> > > in
> > > > a
> > > > > dataset:
> > > > >
> > > > > "Report item expressions can only refer to fields within the
current
> > > data
> > > > > set scope or, if inside an aggregate, the specified data set
scope".
> > > > >
> > > > > I have no idea what this means, and i can reference just fine
every
> > > other
> > > > > field i'm returning in the dataset.
> > > > >
> > > > > I found an earlier person who had this problem, and the response
was
> > > "you
> > > > > can only bind one dataset to a report item". This can't be my
> problem,
> > > > > though, as i've only GOT one dataset.
> > > > >
> > > > > TIA,
> > > > >
> > > > > --
> > > > > Brian
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Error/Failure Audit in Event Logs (SQL 2005 Express) [Advanced Services]

Q1: Any way to control which db loads when, and perhaps stop this error from happening? Again- when all is said and done, the report server functions, and I am able to access just fine.

Q2: What kind of recovery is being referred to? Given the message type- I assume it's nothing of concern- probably more to do with a system that doesn't run all the time.

Okay- so I get these two event messages each time I boot.

Below are two error message I see daily with each system boot- the services mentioned do "actually" function, and are running- as not 10 seconds after these messages are logged, the successfully loaded messages appear. It's almost as if report services tries to connect before the databases are up and running.

Basically the sequence (today) was:

1. 05:49:01 Failure Audit (MSSQL$SQLEXPRESS)

2. 05:49:01 Error (Report Server Windows Service (SQLEXPRESS)

3. 05:49:02 Recovery is complete. (EventID 3408 MSSQL$SQLEXPRESS)

4. 05:49:06 Starting up database 'ReportServer'

5. 05:49:09 Server Resumed execution (MSSQL$SQLEXPRESS)

I'm assuming based on the events that Report Server Service attempts to connect to the ReportServer database before it's actually started. Doesn't really explain the failure audit-

1. Failure Audit:

Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 8/9/2007
Time: 05:49:01
User: <MACHINENAME>\<LOCALUSER>
Computer: <MACHINENAME>
Description:
Login failed for user '<MACHINENAME>\<LOCALUSER>'.

[CLIENT: <local machine>]

This is almost immediately followed by this (which I consider a no-brainer, considering the above):

2. Error:

Event Type: Error
Event Source: Report Server Windows Service (SQLEXPRESS)
Event Category: Management
Event ID: 107
Date: 8/9/2007
Time: 05:49:01
User: N/A
Computer: <MACHINENAME>
Description:
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.

The master database is started first, you cannot control the order in which the database are started up. if the users tries to connect to the database he will be authenticated by SQL Server and directly tries to change the default database or if explicitly mentioned in the connection string connect to the database. if the database is not yet started he will get a login failed (although authenticated but he was not able to change the database context). if you have these problems, try to set the dependency of Report Server to the SQL Service to make sure that Reporting Server will only be started if the SQL Server Service has been. This might help you getting some additional time for the server to make a regular recovery (which is normal if the database / server was not shutdown properly)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Error! Must declare the varaible

Hi
Can someone help me with the following problem? I have a report that needs
two parameters at runtime. If I execute this report on the same server as RS
with a data source that is connected to a database on the same server as the
RS server. Then the report execute without any problems.
The setup is as follow:
SQL 2000 running on Windows 2003 Server, with XP Professional
workstations connecting to the RS.There is also three other SQL 2000 servers
running on Windows 2003 Server.
The problem occurs when the Data Source points to a database on a separate
server than the RS server. In this scenario the report executes with an
Error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'SRCC'. (rsErrorExecutingCommand) Get
Online Help
Must declare the variable '@.PCode'.
If the report contains no parameters, it executes without any error. Only if
it contains parameters does it execute with an error. If someone can tell me
why this is happening I will really appreciate it.
Thanx
MVAHi,
Have you done anything like this in thr Data tab.
set @.ecode = 1002
select * from employee where empno = @.ecode
Then you will get the error. If you can share the full query with dummy
values that's well and good. If you get "must declare @.pcode" then it must be
something to do with the query and I hope you didnt give anywhere in the
report "@.pcode". In that case you may get this error.
Amarnath.
"MVA" wrote:
> Hi
> Can someone help me with the following problem? I have a report that needs
> two parameters at runtime. If I execute this report on the same server as RS
> with a data source that is connected to a database on the same server as the
> RS server. Then the report execute without any problems.
> The setup is as follow:
> SQL 2000 running on Windows 2003 Server, with XP Professional
> workstations connecting to the RS.There is also three other SQL 2000 servers
> running on Windows 2003 Server.
> The problem occurs when the Data Source points to a database on a separate
> server than the RS server. In this scenario the report executes with an
> Error.
>
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'SRCC'. (rsErrorExecutingCommand) Get
> Online Help
> Must declare the variable '@.PCode'.
>
> If the report contains no parameters, it executes without any error. Only if
> it contains parameters does it execute with an error. If someone can tell me
> why this is happening I will really appreciate it.
>
> Thanx
> MVA
>
>

Error with Subscription

Hai, this is Srinivas Reddy. i have a problem in reporting services.

i have a parameter in one of my report, that parameter contains morethan 1300 rows. it is working fine with execution. but when i try to create a subscription, even the subscription page is not getting opened, instead i am getting an error "Error in XML document(1,10272)". I came to know that when this parameter contains less than 1213 rows (values), i am not getting this error and working fine with subscriptions.

I tried with another report which contains a parameter with 10 lakh rows queried against the same database , working fine with the subscription. so i came to know there is no limit for parameter values when it comes to subscriptions.

But, what might be the problem in my case?

If anybody knows this please help me.

Thanks in advance.

Can you post the corresponding error from the Report server logs - Reporting Services\Log Files\ReportingServices*.log

It could be caused by unprintable characters in the parameter's data.

Tudor Trufinescu