Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BobHuk

    Parameter not showing in selection expert

    What you need to do is create two parameters, call them Start Date and End Date. Make each of them Date parameters, not DateTime, as this can cause confusion over what records are included due to time considerations. Once you have created the paramters go to Report->Edit Selection...
  2. BobHuk

    Problem selecting all users on a parameter

    You can add an extra item in your Users list such as "All" and in your record selection formula write something like this; if {?Users} <> "All" then {yourusernamefield} = {?Users} You don't need to add an else to this if statement, as it will only be evaluated if "All" is not selected. If it...
  3. BobHuk

    space fields evenly within a column

    You could also go to File->Options->Layout, and then untick the Snap to Grid box under Grid Options, and tick the Guidelines box under Design View. Now you will find that if you left click your mouse in the vertical ruler on the left of the working area, a horizontal dotted line will appear...
  4. BobHuk

    Determining table and field of parameter

    FlashOverX, Thank you for your answer. Unfortunately the whole idea is that the ASP code will interrogate a report when it is called, and find out what parameters are in its parameter fields collection. When using static parameters, lists of default values are stored within each parameter field...
  5. BobHuk

    Determining table and field of parameter

    Sorry about the lack of information I posted last time. I am using vbscript to interrogate the parameter fields collection in ASP code for Crystal Reports v11. However, the only information I can get about the collection is from the developer help file with CRv11, and this doesn't show any...
  6. BobHuk

    Determining table and field of parameter

    How do I find out the table and field name of the source of values in a parameter list? I need to determine the source of the values in the parameter list for each parameter in a parameter fields collection. Looking through the developer help file I can't find any properties that expose this, so...
  7. BobHuk

    Stored Procedure Issue

    In your stored procedure build a temporary table instead of a static one. Somewhere near the top of the SP put the line "drop table (yourtablenamehere)" Then build your temporary table within the SP and populate it. From Crystal call the SP by setting it as the datasource. Each time the...
  8. BobHuk

    Group section suppression problem

    I think that what you will need to do is right click in the grey area to the left of the group header you wish to suppress. When the context menu appears, select 'Format Section'. This will open the 'Section Expert' form and the section you selected will be highlighted in the list box. On the...

Part and Inventory Search

Back
Top