problem launching a report from users machine

hi all
i have a error launcing a report from users machine, is a report that conform from a view
i dont know what happend all my users grant access to the application
im attaching the image in order the experts help me out here
tsm
error-launching-a-report.JPG
ErnestoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Probably need to get the real error.

Is this  a new report for the application?

Is it just one user with just this report?

mlmcc
ErnestoAuthor Commented:
this is the query

Dim nusa As String = "alter view disporepo as select * from disposiciones where disposicion= '" & Disposicion.Text & "' and tipo like '%" & Tipo.Text & "%' "
ErnestoAuthor Commented:
is a new report that came from the query

alter view disporepo as select * from disposiciones where disposicion= '" & Disposicion.Text & "' and tipo like '%" & Tipo.Text & "%' "
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

mlmccCommented:
What does it show if you click DETAILS?

mlmcc
mlmccCommented:
Did you give the user permissions to the report file?
Did you give the user permissions to view?

mlmcc
ErnestoAuthor Commented:
only if i put the user as db_owner executes the report
ErnestoAuthor Commented:
what role must aply in order to grant access without db_owner
tsm
Fernando SotoRetiredCommented:
The error message seems to state, "The user does not have permission to perform in Vista disporepo", hope my translation was correct. It sounds like you need to give the user permissions.
ErnestoAuthor Commented:
i give it all, but still do not display the report until i give them db_owner
i think is cos  alter view thing
mlmccCommented:
ALTER VIEW is asking to actually change the view in the database.  The usr doesn't need dbo but will need permissions to modify the view.

Why are you using ALTER VIEW?

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ErnestoAuthor Commented:
I use alter view to conform a report that come from a view
mlmccCommented:
Try using

Dim nusa As String = "select * from disposiciones where disposicion= '" & Disposicion.Text & "' and tipo like '%" & Tipo.Text & "%' " 

mlmcc
ErnestoAuthor Commented:
dont made not distinguish at the time to conform the report
mlmccCommented:
I am not sure what you mean by that.

Arer you trying to build a report based on a view and then change the filtering?

mlmcc
ErnestoAuthor Commented:
yes,
how to do so?
mlmccCommented:
Generally it is done using parameters in the report then passing values to them.  Not sure how it is done with a web service as the data source since you should filter it before passing to the report.

Can you edit the code that is generated for the web sevice?

mlmcc
ErnestoAuthor Commented:
i dont want use parameters, i want direct from the query to the view
is VB.Net
windows forms
tsm you expert
mlmccCommented:
Take a look at this method of feeding a report from an application

http://emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.