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

Web Elements - WESelect LOV built from Database Column

<p>Hi,</p><p>We are running XIR2 (Unix). I am trying to create a sample report that uses WESelect and the select list is populated from a column in the database.</p><p>I&#39;ve based my report on the sample report WebElementsdcp.rpt. I am able to get the list of customers in the select list, but it also loads the Report header and each detail line. The information from the crystal report is below. I was unable to copy the screen prints and didn&#39;t find a place to attach the word doc in the submit form so not sure if the formula&#39;s listed below are helpful</p><p>----

</p><p>Copy from word doc</p><p>Problem: The List of Values for the Select Value retrieves the database column contents correctly, but it also appends the contents of the report. I&#39;ve tried to model my report using the sample report WebElementsDCP.rpt.</p><p><strong>Problem Description</strong></p><p>My Prompt / Select List should contain a list of customers. The result when running is Complete list of Customers and All Order Lines from the report</p><p><strong>Crystal Report </strong></p><p>I&#39;ve tried different scenarios, but all return the same result as above. I need to get the report detail removed from the prompt.</p><p><strong><u>Main Report:</u></strong></p><p><u>Formula for SelectCustomer</u></p><p>shared stringvar P1L1; </p><p>WESelect("Query1_Prompt2",P1L1,P1L1,{?Query1_Prompt2},"")</p><p>&nbsp;</p><p><strong>S</strong><strong>ub Report: Get Prompt Values</strong></p><p><u>Formula for GetPromptValues</u></p><p>stringvar field1:= {Query1.Customer Party Name} ;</p><p>shared stringvar P1L1; </p><p>if instr(P1L1, field1 + "|") = 0 then P1L1 := P1L1 + field1 + "|";</p><p>&#160;</p><p><u>Formula for GetPromptValuesFinal</u></p><p>shared stringvar P1L1:= P1L1[1 to length(P1L1)-1];</p><p>&#160;</p>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 28, 2007 at 05:50 AM

    <p>hello, thanks for the well laid out information!</p><p>from what it looks like, the subreport is running off of a query or stored proc. and i&#39;m guessing that it&#39;s a stored proc that brings back formatting data as well as columnar information...just a guess though. as the subreport uses a simple string running total, it will add to the shared variable only what is coming from {Query1.Customer Party Name} ensuring that there are no duplicates in the list.</p><p>steps to correct:</p><p>a) open the subreport up that is used to create the list</p><p>b) remove the query as the datasource location and add only the table that contains your customer party name field...i.e. ditch the query for a direct table connection.</p><p>c) use the {table name.customer party name} field in the select customer formula name</p><p>d) ensure that distinct records are brought back in the Database menu and ensure that the Record Sort Order matches ascending for the database field.</p>

    Add a comment
    10|10000 characters needed characters exceeded

    • hello...glad that you've things up and running.

      as far as consultants i know that we have internal consultants at business objects who have implimented webelements solutions for clients. you can contact global services at

      i" target="_blank">">

      i also know through this forum section that there are several consultancy companies using the function library now...hopefully they'll read this post and reply to it :)


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.