Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Actuate editing report help needed

Status
Not open for further replies.

what69

IS-IT--Management
Apr 7, 2011
2
IN
Hi all,

I'm using SQL server. So I created the ODBC connection using the windows authenciation (testing was successful).

The situation here is I'm trying to edit the report which was already created by someone. When the rod file was given to me, it has already has the ODBC connection configured with the report. So i removed it and changed to the ODBC link what I created. So while adding , the user name and password are left empty as ODBC has been configured with windows authentication.

So when I try to run the rod file, it throws an error

Basic Error: 1002 Module: C:\Program Files\Actuate8\eRDPro\afc\report.bas Line: 1552 User error.

When I tried the report.bas, the lined 1551,1552 and 1553 are as follows

Sub StartDataStream( stream As AcDataAdapter )
Verify( stream.Start( ), ClassProtocolError )
End Sub

I got the sql authentication credentials, so Created the ODBC and tried to run the report in the ereport designer using this ODBC connection, but I got the same problem.

Just I need to clarify am I doing the connections correctly. Please verify the steps I followed are correct

1.Created the ODBC with SQL authentication, tested to find the success report
2.Opened the existing report by using rod file, added the NikuUtilities.bas,Extras.bas,nps_masters.bas,NikuR eportControls.rol
3.Removed the earlier ODBC connection, added my new ODBC link with sql authentication under Content-Nikusequential in the Report structure.
4.Then ran the report after filling the parameter, found with the same error.

Is there any problem with the steps I followed.
I believe the ODBC connection is working fine, as I could open the Stored Procedure from the Data link

So any idea why I get this error till now?

Thanks
Sreeram
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top