Search results for query: *

I join two table on tb.ID: tb1 has few columns - tb1.id tb1.category tb1.... tb1.... tb2 has two columns - tb2.id tb2.zip For each ID in tb1 I have several records in tb2 with different value in...

I got the error msg "Failed to open rowset" when I run the report from iMIS10. Stored procedure is used in Crystal report. Also, when I run the same report from the Crystal itself, I do not get this error. Please help? Ira.

My report is using the Stored Procedure as a Data Source. Database is iMIS10. When I run the report I get this error message "Failed to open a rowset". Please help?

Simple report: I have only 3 lines (records) of data on my details section and rest of the space is empty. My totals on the Page Footer so I have to scroll down to see totals. How do I eliminate that empty space so my totals will be exactly under the data? Thank you.

I have a report- Main report is create for students: Creates exam questions sheet. Select question#, question, multiple_answers, from tbl1 based on domain(4 domains)(parameter fields) example: selecting domain 1 - 5 questions domain 2 - 10 questions...

I created the formula "@units": local numbervar units := Sum ({Activity.UNITS}, {Activity.CATEGORY}); if Sum ({Activity.UNITS}, {Activity.CATEGORY}) > 15 then 15 else units And, I want use this formula to summarize on; summary location - on group# 1 When I try to insert the summary, I cannot...

I have a Table with columns (amounts): amt1 amt2 amt3 amt4 I need to select and print the line (for same record)where: amt1 >= 5 and amt2 >=5 and amt3 >= 5 and amt4 >= 5 and sum of (amt1, amt2, amt3, amt4) >=30 Is it possible to do this in Crystal? If it is, please help me. Ira.

I have this query and I got error: ("The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.") SELECT Student_id, deadline from register where item = 'mm' and description like '%int%' and deadline between (convert(varchar(2),month(getdate())+ 3)...

I need to pass the parameter fields from main rpt. ro subreport. Is there anyway to do this. Please help.

I need to create a rpt., to display a Map. (I have a map) For each state, I need to count and display on the map a number of students enrolled into the program(any pgm) in that state. Please help.

I need to create a rpt., to display a Map. (I have a map) For each state, I need to count and display on the map a number of students enrolled into the program(any pgm) in that state. Please help.

I am testing my stored procedure and I need to display a specific column value between the lines of my code. What command do I have to use? Thanks