Search results for query: *

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...

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...

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 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...