We help IT Professionals succeed at work.

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
Comment
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Author

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 & "%' "

Author

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 & "%' "
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What does it show if you click DETAILS?

mlmcc
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

mlmcc

Author

Commented:
only if i put the user as db_owner executes the report

Author

Commented:
what role must aply in order to grant access without db_owner
tsm
Fernando SotoRetired
Distinguished Expert 2017

Commented:
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.

Author

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
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
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

Author

Commented:
I use alter view to conform a report that come from a view
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Try using

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

mlmcc

Author

Commented:
dont made not distinguish at the time to conform the report
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Author

Commented:
yes,
how to do so?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

Author

Commented:
i dont want use parameters, i want direct from the query to the view
is VB.Net
windows forms
tsm you expert
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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