error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

error in report builder

I am trying to create a filter in the report builder on reporting services. When I try to filter I get a yellow triangle with an exclamation point and cannot get a list. When i put my cursor over the yellow triangle, I get the error "the requested list could not be retrived because the query is not valid or a connection could not be made to the data source. Any idea how this can be fixed so I can get a list of values?

This usually means you have something wrong with the data source connection behind the report model. Check that your model has a data source specified, and that the data source has a valid connection string and appropriate credentials.

Hope that helps!

|||I am not sure if you found a solution to this problem, but I also ran into the same problem recently.

Currently, I am using a folder structure like:
Home>Dept>App>(Model, Datasource, Reports)

I found that by granting "View folders" at the home level to the group/user resolved the issue. I created a custom Item-Level role with just this task to restrict access, but either the Browser or Report Builder roles would work as well as they have the "View folders" task associted with them.

However, if at all possible I would like to avoid giving users access to the Home folder so if someone could explain where and why this dependency exists it would be much appericated.

Error in INSERT INTO

Hi,
I'm sure that this is quite a simple program. I am generating an INSERT INTO statement in the Query builder (!) of Visual Basic .NET, and I consistantly get the following error: "Missing semi-colon at the end of the end of the SQL statement." The SQL stat
ement in question is:
INSERT INTO tblBlocks
(ActualTotalHoles, Block_Name, BlockComment, ChargedHoles, PlannedTotalHoles, Site_Name)
VALUES (?, ?, ?, ?, ?, ?)
SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
FROM tblBlocks
WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
Would much appreciate some help - Thanks.
It's being interpreted as two SQL statements, not one. The missing
semi-colon should come after VALUES(?, ?, ?, ?, ?, ?);
"Lite" <anonymous@.discussions.microsoft.com> wrote in message
news:C052EA2E-9424-4E0C-9D30-8FAFC93F064B@.microsoft.com...
> Hi,
> I'm sure that this is quite a simple program. I am generating an INSERT
INTO statement in the Query builder (!) of Visual Basic .NET, and I
consistantly get the following error: "Missing semi-colon at the end of the
end of the SQL statement." The SQL statement in question is:
> INSERT INTO tblBlocks
> (ActualTotalHoles, Block_Name, BlockComment,
ChargedHoles, PlannedTotalHoles, Site_Name)
> VALUES (?, ?, ?, ?, ?, ?)
> SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
> FROM tblBlocks
> WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
> Would much appreciate some help - Thanks.

Error in INSERT INTO

Hi,
I'm sure that this is quite a simple program. I am generating an INSERT INTO
statement in the Query builder (!) of Visual Basic .NET, and I consistantly
get the following error: "Missing semi-colon at the end of the end of the S
QL statement." The SQL stat
ement in question is:
INSERT INTO tblBlocks
(ActualTotalHoles, Block_Name, BlockComment, ChargedHoles, PlannedTotalHoles
, Site_Name)
VALUES (?, ?, ?, ?, ?, ?)
SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
FROM tblBlocks
WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
Would much appreciate some help - Thanks.It's being interpreted as two SQL statements, not one. The missing
semi-colon should come after VALUES(?, ?, ?, ?, ?, ?);
"Lite" <anonymous@.discussions.microsoft.com> wrote in message
news:C052EA2E-9424-4E0C-9D30-8FAFC93F064B@.microsoft.com...
> Hi,
> I'm sure that this is quite a simple program. I am generating an INSERT
INTO statement in the Query builder (!) of Visual Basic .NET, and I
consistantly get the following error: "Missing semi-colon at the end of the
end of the SQL statement." The SQL statement in question is:
> INSERT INTO tblBlocks
> (ActualTotalHoles, Block_Name, BlockComment,
ChargedHoles, PlannedTotalHoles, Site_Name)
> VALUES (?, ?, ?, ?, ?, ?)
> SELECT tblBlocks.Block_Name, tblBlocks.Site_Name
> FROM tblBlocks
> WHERE (tblBlocks.Block_Name =?),( tblBlocks.Site_Name = ?);
> Would much appreciate some help - Thanks.

Error in building SQL query within "LIKE" statement for TableAdapter in Design Section

ASP.net 2.0 (VB), SQL Server 2005:

While creating a new TableAdapter in design section, I'm using the query builder and trying to write a query within "LIKE" statement as below -

Example1: SELECT * FROM table WHERE field LIKE @.'%TextBoxData%'
Example2: SELECT * FROM table WHERE field LIKE'%@.TextBoxData%'

but these query doesn't work...error in building query...any clue to make it work? If I remove "@." sure the query will work with normal but '%TextBoxData%' will become a hardcoding value...this is not I want...I want make the TextBoxData become a flexible value depend on the data what I enter in my text box like 'abc,123' not like 'TextBoxData'...

I know normally it supposed to be like:

"SELECT * FROM table WHERE field LIKE'%" & TextBoxData.Text & "%'"

It can work when inCode Section, but not at this time...because now i'm trying to made it with "Query Builder" for TableAdapter " inDesign Section...hmm did you get what I mean? Sorry for my bad english

Thanks in advance

Hi, you can use such query which should beinterpreted correctly as T-SQL command:

SELECT * FROM table WHERE field LIKE '%'+TextBoxData+'%'

|||

Nice work, how thanksIori_Jay, you are the man

|||It Should be'%'+@.TextBoxData+'%'