invalid column in report service

[voroojak]

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

[voroojak]

problem solved,
thanks

[hariharanmca]

problem solved,
thanks

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)

thankyou

[voroojak]

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.