asked on

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

Mike McCracken

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

Ernesto

ASKER

this is the query

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

Ernesto

ASKER

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 McCracken

What does it show if you click DETAILS?

mlmcc

Mike McCracken

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

mlmcc

Ernesto

ASKER

only if i put the user as db_owner executes the report

Ernesto

ASKER

what role must aply in order to grant access without db_owner
tsm

Fernando Soto

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.

Ernesto

ASKER

i give it all, but still do not display the report until i give them db_owner
i think is cos alter view thing

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ernesto

ASKER

I use alter view to conform a report that come from a view

Mike McCracken

Try using

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

mlmcc

Ernesto

ASKER

dont made not distinguish at the time to conform the report

Mike McCracken

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

Ernesto

ASKER

yes,
how to do so?

Mike McCracken

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

Ernesto

ASKER

i dont want use parameters, i want direct from the query to the view
is VB.Net
windows forms
tsm you expert

Mike McCracken

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