Search results for query: *

Hello there, I'm developing a stored procedure for a Crystal report and starting out with some code that has already been developed. I'm fairly new to this and this is just over my head. Can you help? I have 8 types of fields that need to be sorted, according to the values contained in each...

Hello, I wrote some code that is supposed to select a random sample of clients from three views. I needed to allow the user to ask for a certain number of records to be returned. What I did was run the parameters of the selection and union the results of the return into a temp table, while...

Hello, I'm trying to set up a where clause with (among other things) a selection of a variable if it has a value other than "all" or a wildcard if it is "all." I'm pulling the data from a temp table. I'm not sure how to code this and have botched it in several different ways. Can you help me...

Hello, I hope you can help me as I'm new to using SQL. I'm trying to create a procedure, but when I test it in Query Analyzer, it doesn't recognize the variables that will be passed in as having been declared. Is there something wrong with my syntax? I've looked at several things and have added...

Hello, I'm using version 8.5 and trying to link a Crystal Report main report to another report that uses the same stored procedure on a network. I want them to remain separate, as I want the parameters of the second report to fire only when the hyperlink on the first report has been clicked--not...

Hi, I've set up a form that accesses the reports container and lists out specified reports. The User selects one of these reports and can either view it by clicking one button, or print it by clicking another. Since these reports might be run in multiples, I wanted the ability to print the...