Search results for query: *

Thank you very, very much. It seems like this problem is solved.

Hello LB, Answer on your 1st question: tb1.ID is a company ID and each company has several names(member name) on tb3. Also, each tb1.ID (company) has several zips on tb2. All these three tables (tb1, tb2, tb3) have ID column as a key. I need to display all tb3.name and tb2.zip in rows for...

Hi LB, I thought, I am done with this report, but I am not. I need to list name colum from the third table tb3; tb3.id tb3.name I join tb1.id = tb3.id I also have several records from tb3 for tb1.id I was trying to do same what you suggested (created varibales) previously for the tb3.name...

Thank you very much. You are a lifesaver!!!!!!!!!!!!!!!!!! Problem is solved.

This is real column name - TCIA_ZIP_Search.ZIPCODE {@accum} - placed in the detail section whileprintingrecords;stringvar zip := {TCIA_ZIP_Search.ZIPCODE} + ", "; {@reset} - placed in the group header section whileprintingrecords;stringvar zip;if not inrepeatedgroupheader then zip := ""...

HI LB, I did what you suggested. but, it is only diplayed (@display result) zip value from the last record from tb2. In detail section I can see that all records were selected. Do you have any idea why it is happened? Thank you.

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.

Do no need help anymore. I fixed it.

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?

When I placed the fields in the Report Footer, I only got the last record from my 3 records. Do you mean to place the detail fields or totals?

to: DJWheezyWeez, GJParker Yes, the option to "Print at Bottom of Page" checked in my Report Footer section and I do not have any options to unchecked. What is "teh report footer"? to: CoSpringsGuy I have only 3 records in my table to select. What is "isnull formula in suppression formula"...

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.

Thank you... but it did not work. Is there any other idea?

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

lbass, It works! Thank you very very much!

Do I place {@reset} for the group #1 header in "Section Expert"?? Also...what is "inrpeatedgroupheader"? It gives me error when I check for errors. Do I create {@accum} and place directly on activity.category group section (group #2)?? Then, when I place whileprintingrecords; numbervar x...

How do I do that? Could you help me with that. Thanks.

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.