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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.