locked
parameter checking RRS feed

  • Question

  • User899307980 posted

    We are using crystal reports in visual studio 2008 and oracle as the database. the database has a table of categories. The first is "All categories" value= 0, then "primary", value = 1 etc. Now there is no data in "All Categories". What I want to do is when parameter cat = 0 then results from "primary", "secondary", "Primary and secondary" etc should be displayed. We have 3 such parameters like this one. All are numeric. How is this possible in Crystal reports?

    Wednesday, December 8, 2010 5:21 AM

Answers

  • User899307980 posted

    Problem solved. 

    if{?Tcat} = 0
    then true
    else

    but now it has created another. it is showing duplicate records which usually can be suppress in SQL where clause but crystal reports not displaying anything, if there is a sql command with where clause



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 10, 2010 1:56 AM

All replies

  • User-1209090555 posted

    Can you be more specific about your question ?? simply, you dont know how to pass parameters to crystal reports ??????

    Wednesday, December 8, 2010 8:27 AM
  • User899307980 posted

    The parameters are passed from databound dropdownlists  to crystal reports. Now 3 parameters are of type numeric. When value = 0 say there are no records in the table therefore no resultset. What I want to do is to display the report for all i.e. value=1,2,3,4 when the user selects value = 0. Its the same for the other 2 paramters.

    Thursday, December 9, 2010 12:21 AM
  • User899307980 posted

    Problem solved. 

    if{?Tcat} = 0
    then true
    else

    but now it has created another. it is showing duplicate records which usually can be suppress in SQL where clause but crystal reports not displaying anything, if there is a sql command with where clause



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 10, 2010 1:56 AM