Search results for query: *

gmmastros, Thats what I need. Thanks a lot!!

gmmastros, I am sorry. I should have explained properly. Here is how the code looks right now: If(parameter=1) Begin Select Count(*) from ... Return (1) End When the procedure is executed, it comes back with the right number of records. But when I do, Declare @NumRecs INT exec...

genomon, I am using Crystal Reports 10. I am sure an output parameter won't wreck the SP, but a lot of processes seem to depend on this SP and we 'd rather not touch it and cause unanticipated problems elsewhere. gmmastros, I tried this, the variable displays 1 - just that the procedure was...

I have a stored procedure that returns the total number of records(INT) obtained for a particular parameter value(customer type). I need to create a report that runs this stored procedure for several different parameter values and displays the total for each type. The original SP does not have...

Thank you for your replies. Eventually turned out that a join was taking too long and perhaps caused Crystal to timeout or something. When I removed the join from Crystal, and did it in the stored procedure instead, the report started to work fine. So now it works! Thanks again

I have a report that takes a USERID value(int) as a parameter(user supplied). This report works for all parameter values except one(so I know this has nothing to do with stored procedure permissions). If I run the associated stored procedure independently for this parameter value, it returns...

I am calculating percentage total in a formula. I want to be able to select those records where percentage total is above 1%. However, the select expert doesn't list this field and I don't know how to filter the report for those records with percentage total above 1%. Any help would be...

I need to build a report in Crystal, but with all the data coming thru a stored procedure in SQL server. The report has the following fields: physician id, physician's name - from physician table count of number of patients represented by each physician, in each category - labtest 1, 2, 3 or...

Thank you for your reply. I think that might be it. I am about to try it right now, and will let you know if it works.

There are students of different departments and classes that take different exams repeatedly based on certain requisites/rules. I need to pull the latest grades based on examdate for students of classid and departmentid that are passed to the stored procedure during execution. Here is my...

I am using the cursor to insert records into a new table whenever NonSmoker value is found to be a 1. I just realised that the while loop, for some reason, is reading only the first 100 records, for which, coincidentially, the NonSmoker values are NULL! So it makes sense that there are no...

I am trying to print the value of variable @NonSmoker by reading this float value from a table using a cursor. The print statement isn't returning anything. It seems the cursor isn’t reading or storing any values for @NonSmoker. What could the problem be?? Here is my script; create...

I have 2 tables of which some records in the second one are missing. I haev to complete those, how do I locate those and display them on my report? I use a left join or not exists clause in a query to get the results on the database, but I don't know how to write a formula that does the same...