Showing posts with label dataset. Show all posts
Showing posts with label dataset. Show all posts

Thursday, March 29, 2012

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.

Sunday, March 11, 2012

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: "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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Sunday, February 26, 2012

Error with databound datagrid

Help,

I have a simple app that only has on datagrid that is bound by the typical sqlconnection,sqldataadapter and dataset. But I keep getting this error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

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:System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:

Line 55: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.LoadLine 56: 'Put user code to initialize the page hereLine 57: SqlDataAdapter1.Fill(DataSet11)Line 58: DataGrid1.DataBind()Line 59:

WHY :)

xactly what the message says..can you post the connection string ?

|||
Indeed, fix your connectionstring. Get that working before messing withdatagrids. The error indicates that you're telling ADO.NET to use atrusted connection (i.e. windows authentication) but the ASPNET useraccount probably doesn't have access to your database. I typically useSQL authentication so I can limit the damage each application can do.One account per database.

Error with conn string

Just installed AJAX for VS2005 and started to build a AJAX enabled web site. I got the following message after creating a database (SQL) and Dataset "FOLLOWING ERROR OCCURED WHLE GETTING CONNECTION STRING INFORMATION FROM CONFIGURATION:'CANNOT GET WEB APPLICATION SERVICE'.

I didn't have this problem before,can it be related to AJAX?

Thank you in advance,

close your VS 2005 and open it again The SQLConnection error might go away.

error while working with dynamic query in report

Hi all,
I am trying to add report parameter to my report.I am getting "cannot
set the command text for dataset ''dataset_name " this kind of error. I am
working with sql server 2005.I found this tutorial in Books Online->sql
server tutorials - >Reporting Services Tutorials - >Using a dynamic query in
a report.
Can u plz tell me why i am getting this kind of error.
Thnx.YOu should repost this in the Reporting Services Group. But also include the
actual Query you are using...
ie
=" Select * From titles"
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"supriya" wrote:

> Hi all,
> I am trying to add report parameter to my report.I am getting "cann
ot
> set the command text for dataset ''dataset_name " this kind of error. I am
> working with sql server 2005.I found this tutorial in Books Online->sql
> server tutorials - >Reporting Services Tutorials - >Using a dynamic query
in
> a report.
> Can u plz tell me why i am getting this kind of error.
> Thnx.
>
>