Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to writing the parameters into sql-database from Crystal Reports?

Hi, community

I have some parameters, such as: territory, country, city and many other.

The  Territory contains few values, for example: Europe, USA, Pacific.

The  Country contains few values, for example: Germany, France, Canada, Australia.

The  City contains few values, for example: Berlin, Paris, Ottawa, Sidney.

When I want to see a sales report, I have to make driildown into the report which contains this values, but in the SAP BusinessObjects BI I get a long URL:

http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Aa8kNIetewlPlKpEOuKQfFM&sIDType=CUID&lsSCity=Paris&lsSCountry=France&lsSTerritory=Europe.

Can  I reduce this URL, for example as http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Aa8kNIetewlPlKpEOuKQfFM&sIDType=CUID&lsSID=3 ?

I have some ideas, but a don't know how can it be done.

When I select Europe, I want to write this value into the database such as &lsSTerritory="Europe" and be able to select this value as &ID=1 and load the subreport with the countries.

When I select France,  I want to create a new param such as &ID=1&lsSCountry="France" and write it in the database as &ID=2 and load the next subreport with cities.

When I select Paris, I want to create a new param such as &ID=2&lsSCity="Paris", write it as &ID=3 and load the next subreport with sales.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question