469,926 Members | 1,980 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

invalid column in report service

I have a problem with report service.
i have a stored procedure and when i am running it in the sql 2005, it will exexute successful and no proplem. but when i a mputting it in my report service as my dataset it is giving me error 207, invalid column.
i checked it hundred times and all the names are right and it is existing but why it is giving me this error?
thanks alot for any help
Jul 17 '07 #1
3 1064
problem solved,
Jul 17 '07 #2
1,977 1GB
problem solved,
it will happen, when specify the field name is not correct or unknown field name
from a table in reports or qrey.

(just post how it solved if it solved)

Jul 17 '07 #3
Thanks for your consideration.

in my Stored procedures i was inserting into other table in another database. I mean i was getting value from one database and and wante dto i nsert in another database, the problem was that the name of the columns that i was trying to insert to was not same.
i mean in my first database all the names when they are naming is like first_name but in the second one it was first name. and i was not checking the format of the second data base.
those columns that it was giving me a message that it is invalid, i had it along my stored procedures a lot and i was thinking there is a problem in reaniming my columns or something else.

i hope i could explain it properly.
Jul 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Sam Evans | last post: by
reply views Thread by IMRAN SAROIA | last post: by
reply views Thread by Marvin Massih | last post: by
1 post views Thread by MikeD | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.