Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 12, 2015 at 02:32 PM

    You need to use a cascading prompt.  This should get you started...

    Crystal Reports 2011: Create a cascading prompt to select records

    Noel

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 03:48 PM

    With the cascading prompts, you'll include both the ID and Name in the prompt as the "Value" and "Description".  You can set the prompt to display just the Description, but use the Value in the filter.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 10:39 AM

    Unfortunately I wrote the wrong task in the topic.

    I don't  have report with subreports.

    I have a few reports and they are uploaded to the server SAP BO.

    Parameters are passed through OpenDocument URL.

    I know about the problem with limit of the 2083 characters in the link, when the report is opening in a browser.

    So, I have:

    a. Report of territories

    b. report of Country

    c. report of City

    d. report of sales

    1. When I load the first report (a), I get all territories and if I chose "Europe" I get the openDocument URL for loading the next report:  http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Amg8...ndbfM&sIDType=CUID&lsSTerritory=Europe.

    2. When I click on the URL, I load the next report (b), which contains all countries  and if I chose "France" I get the openDocument URL for loading the next report : http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Adfk...kjghM&sIDType=CUID&lsSCountry=France&lsSTerritory=Europe.

    3. When I click on the URL, I load report (c) and get the report with all Cities of this country. And if I chose "Paris" I get URL: http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Aa4k...dfgtM&sIDType=CUID&lsSCity=Paris&lsSCountry=France&lsSTerritory=Europe.

    4. And if I load this URL I can see report (d) of sales in this city.

    But, I want to reduce opendocument url if it possible. I want to change and save it to the temporary DB the next values:

    1. In the first url "lsSTerritory=Europe" as "&lsSID=1" and be able to get the Terrytory on this link: http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Amg8...ndbfM&sIDType=CUID&lsSID=1

    2. In the second url "&lsSCountry=France" as "&lsSID=2" (where it will be contain next values  "&lsSID=1+&lsSCountry=France") and and be able to get the Country on this url http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Amg8...ndbfM&sIDType=CUID&lsSID=2

    3. In the third url "&lsSCity=Paris" as "&lsSID=3" (where it will be contain next values  "&lsSID=2+&lsSCity=Paris") and be able to get the City on this url http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=Amg8...ndbfM&sIDType=CUID&lsSID=3

    Can I save this parameters ("&lsSID=1", "&lsSID=2", "&lsSID=3") in the temporary DB and load it when BO will be generate links?

    My apologies for the confusion

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      what i understood is: you'll have different reports for territories, countries, etc.

      my question is are those really different reports or are those just summaries of the 'more detailed' levels?

      If you really have different reports for different levels, you might think of different subreports, which are suppressed if a value for another level is given by the user and you only show the report for the given level.

      regards alex