How to writing the parameters into sql-database from Crystal Reports?
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:
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.