We are planning to switch from CR 8.5 to BO XI R2.
While working and testing for new BO XI R2 environment,I am facing problems with creating a managed URL for BO XI R2.
I used to have following environment and setup:
Crystal Enterprise server, 8.5,
Database is SQL 2k and Win2k operating system
Users are viewing the report over the web using the Active X viewer.WebspherDomino 5.0.10.
I have a JSP Report UI.
We have 300 reports are all are based on Stored procedures.
User login to JSP report UI, enter values for all parameters and JSP UI create and passes a unmanaged URL possessing all report related parameters, login User ID (for security/rights/authentications), Reportid, Sql database userid and password and passes to Enterprise server 8.5, which calls report from report repository saved on same machine with domino server which later retrieves data from Stored procedure and display on Active X viewer.
Everything worked fine till we plan to switch to BO XI R2.
Now we have JSP report UI on one machine.
BO XI R2 on another machine and all reports are stored in Dev folder on XI R2.
We still have same ReportUI, once user enter all parameters and hit enter to view report,
I am unable to create a complete managed URL to pass it to XI R2.
At this point I don't know the syntax to add parameters in in my URL. If I execute above URL, it takes me to parameter selection page. once enter all parameters promts me to SQL login and password info and display the report.
Lets suppose If I have three parameter as:
@discipline = New
@Location = Chicago
@Start_Date = 02/01/2007
Do you think, it gonna be:
lsSparamDiscipline=New&lsSparamLocation=Chicago&lsSparamStart_Date=Date(2007,1,2)
Do I need to include @ sign.
Does date firmat need to be changed.
I created one report without any parameter and published it on server.
Once i passed the above URL, it prompted me to a page for Enterprise userid and password even it was included in the URL and then after enter it, it prompts me for SQL login and password for ODBC DSN used in the report.
Can you also inform, how to pass SQL login and password info in URL too.
Please advice.
While working and testing for new BO XI R2 environment,I am facing problems with creating a managed URL for BO XI R2.
I used to have following environment and setup:
Crystal Enterprise server, 8.5,
Database is SQL 2k and Win2k operating system
Users are viewing the report over the web using the Active X viewer.WebspherDomino 5.0.10.
I have a JSP Report UI.
We have 300 reports are all are based on Stored procedures.
User login to JSP report UI, enter values for all parameters and JSP UI create and passes a unmanaged URL possessing all report related parameters, login User ID (for security/rights/authentications), Reportid, Sql database userid and password and passes to Enterprise server 8.5, which calls report from report repository saved on same machine with domino server which later retrieves data from Stored procedure and display on Active X viewer.
Everything worked fine till we plan to switch to BO XI R2.
Now we have JSP report UI on one machine.
BO XI R2 on another machine and all reports are stored in Dev folder on XI R2.
We still have same ReportUI, once user enter all parameters and hit enter to view report,
I am unable to create a complete managed URL to pass it to XI R2.
At this point I don't know the syntax to add parameters in in my URL. If I execute above URL, it takes me to parameter selection page. once enter all parameters promts me to SQL login and password info and display the report.
Lets suppose If I have three parameter as:
@discipline = New
@Location = Chicago
@Start_Date = 02/01/2007
Do you think, it gonna be:
lsSparamDiscipline=New&lsSparamLocation=Chicago&lsSparamStart_Date=Date(2007,1,2)
Do I need to include @ sign.
Does date firmat need to be changed.
I created one report without any parameter and published it on server.
Once i passed the above URL, it prompted me to a page for Enterprise userid and password even it was included in the URL and then after enter it, it prompts me for SQL login and password for ODBC DSN used in the report.
Can you also inform, how to pass SQL login and password info in URL too.
Please advice.