Skip to Content
author's profile photo Former Member
Former Member

Token's limitation with Dynamic parameter

Hi,

I have a crystal report stand-alone that I would like to import to SAP 8.81.

The selection criteria for this parameter is based on multiple UDF's fields defined in OITM. Almost all parameters are defined as dynamic parameters and allow multiple and discrete values.

I tried to change these parameters using the following syntax in the token (one parameter as example), but with no success.

Season@Select Distinct U_Season from OITM (dynamic and allow multiple values -Yes)

At this point I consider the distinct clause might not be allowed so I create a view using the same query.

I linked the view to my report and I tried again using the syntax below.

Season@select U_Season from SEASON (dynamic and allow multiple values -Yes)

At this time I get a field like only discrete values are allowed and with no dynamic values.

Could you please let me know where I'm wrong and which are my options with my report?

Thank you,

Alex

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 13, 2011 at 05:04 AM

    hi Alexandru,

    Welcome to SDN Forum.

    use Static Parameter instead of Dynamic.

    and use the ff syntax Season@select U_Season from @SEASON (i assume Season is UDT so you need the Prefix @ for UDT)

    regards,

    Fidel

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello everyone,

      In order to overcome the limitations mentioned above I had to do the following.

      1. Create a UDT for each of my dynamic parameter @Season @Gender @Category etc... with no fields, only the default (Code and Name)

      2. Insert a command into my reports one for each UDT.

      TRUNCATE TABLE "dbo"."Season"

      INSERT INTO "dbo"."Season"

      SELECT DISTINCT U_Season as 'Code', U_Season as 'Name' from OITM

      ....

      the same for the other UDT's except the category where I have another issue, as the category had more than 8 char I had to use

      TRUNCATE TABLE "dbo"."Category"

      INSERT INTO "dbo"."Category"

      SELECT DISTINCT (Substring(U_Category,1,7)+Right(U_category,1)) as 'Code', U_Season as 'Name' from OITM

      Now I have unique values in my UDT's and I inner join these udt's with my table.

      3. I defined the parameters into my crystal report

      Season@select T1.Code, T1.Name from OADM T0 CROSS JOIN @SEASON T1

      Gender@select T1.Code, T1.Name from OADM T0 CROSS JOIN @GENDER T1

      Category@select T1.Name from OADM T0 CROSS JOIN @CATEGORY T1

      The the category parameter is coming with no values... only with blank lines as many as the values in the UDT.

      My question is, when a parameter is used in the report which field value from the token will use in the selection, always is the code, or it can be a different field ... T1.Name as example or I should define another UDF into these tables?

      Thank you,

      Alex

  • Posted on Jun 07, 2012 at 06:03 AM

    Hi Alexandru,

    I am labouring on a Crystal Reports problem similar to the one you were working on last year.

    Quite a long time has passed. I hope you have been able to solve your problem, and maybe give me some help.

    I experienced the same problems, and tried the same workarounds as you:

    • Wasted much time on dynamic parameters only to find that it did not work in SAP B1

    • I turned to tokens as a substitute.

    • I needed long stings of SQL to put in the token name (so as to get exactly the Selection Criteria picklist I need)

    • Unfortunately, the permissible length of a token is limited.

    • I tried other tricks to bypass this limitation.

    • For ex. putting a view in the token - it does not work.

    • I understand you have tried putting temporary tables, and also a SAP B1 table joined with a UDT.

    • Could you tell me what solution finally worked for you?

    Best Regards,

    Leon Lai

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.