Help with report please?

Hi,I have a report with 2 input parameters, one is a string input the other is a user input..WHen I enter only the user input, the report works correctly and displays only record for that input.when i enter only the string input, no records are returned, I know there are record in the DB with the strin input value, and I have been able to make this work in another scenario..Why can I not enter in just the string input and have values returned?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh via eLinkWhat database is being used with Livelink, and what is the SQL you are using in your report?- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Sunday, February 08, 2004 6:30 PMTo: eLink RecipientSubject: Help with report please?Help with report please?Posted by DeloitteAdmin on 02/08/2004 06:26 PMHi,I have a report with 2 input parameters, one is a string input the other is a user input..WHen I enter only the user input, the report works correctly and displays only record for that input.when i enter only the string input, no records are returned, I know there are record in the DB with the strin input value, and Ihave been able to make this work in another scenario..Why can I not enter in just the string input and have values returned?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

DeloitteAdmin_(Delete)_2707331

Hello Bhupinder,The DB I am using is MS SQL ServerThe SQL query is as follows:select Versionnum,DataID,Delivery_Area "Delivery Area",CASE kuaf.type WHEN 0 THEN kuaf.lastname + ', ' + kuaf.firstname WHEN 1 THEN kuaf.name END "Project Manager Name",Project_Name "Project Name",Work_Product_Name "Work Product Name",Doc_Version "Work Product Version",Review_Type "Review Type",Work_Request_Type "Work Request Type",Work_Reference_No "Work Reference No",SDLC_Phase "Detection Phase",left(Plan_Date,11) "Plan Review Date",left(Actual_Review_Date,11) "Actual Review Date",Review_Outcome "Inspection Outcome",Inspection_Status "Inspection Status", Approved_By_Name "Approved By",Approval_Date "Approved Date" from kuaf,testPeerReviews A WHERE A.DataID + A.VersionNum=(SELECT MAX(b.DataID + B.VersionNum) FROM testPeerReviews B WHERE B.dataID=A.dataID) AND kuaf.id = Project_Manager_Name AND Inspection_Status LIKE 'In Progress' AND ((Delivery_Area = %1) OR (Project_Manager_Name = %2) OR (Delivery_Area = %1 AND Project_Manager_Name = %2)) ORDER BY Delivery_Area,Project_Manager_Name,Plan_Date

Bhupinder_Singh

Message from Bhupinder Singh via eLinkTry the following simplified report with the test cases outlined below:select Versionnum, DataID, Delivery_Area "Delivery Area",from kuaf, testPeerReviews A WHERE Delivery_Area = %11. Ensure that %1 is set to String input, and Param %1 is "User Input 1"2. When running the report, type text for the delivery area input in the same case (upper/lower case letters) as recorded for theentries in the table3. Try using the word "like" instead of the "equals" operator in the WHERE clause above.4. Try using a function like "Upper" to convert both sides of the "equals" operator to capitals when comparing them. For example:WHERE upper(Delivery_Area = upper(%1)- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Monday, February 09, 2004 5:50 PMTo: eLink RecipientSubject: SQL .SQL .Posted by DeloitteAdmin on 02/09/2004 05:45 PMHello Bhupinder,The DB I am using is MS SQL ServerThe SQL query is as follows:select Versionnum,DataID,Delivery_Area "Delivery Area",CASE kuaf.type WHEN 0 THEN kuaf.lastname + ', ' + kuaf.firstname WHEN 1 THENkuaf.name END "Project Manager Name",Project_Name "Project Name",Work_Product_Name "Work Product Name",Doc_Version "Work ProductVersion",Review_Type "Review Type",Work_Request_Type "Work Request Type",Work_Reference_No "Work Reference No",SDLC_Phase "DetectionPhase",left(Plan_Date,11) "Plan Review Date",left(Actual_Review_Date,11) "Actual Review Date",Review_Outcome "InspectionOutcome",Inspection_Status "Inspection Status", Approved_By_Name "Approved By",Approval_Date "Approved Date" fromkuaf,testPeerReviews A WHERE A.DataID + A.VersionNum=(SELECT MAX(b.DataID + B.VersionNum) FROM testPeerReviews B WHEREB.dataID=A.dataID) AND kuaf.id = Project_Manager_Name AND Inspection_Status LIKE 'In Progress' AND ((Delivery_Area = %1) OR (Project_Manager_Name = %2) OR (Delivery_Area = %1 AND Project_Manager_Name = %2)) ORDER BYDelivery_Area,Project_Manager_Name,Plan_Date[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Help with report please?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3329506&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe