Sir I want to create crystal report using vb to display two different tables of MySQL. One table returns only one record (parameters during shift takeover) but other table should display multiple records ( events in a shift duty) It works perfectly when I create individual reports, but when I combine using sub report, only sub report is displayed, main report disappears immediately after just displaying.
Pretty good, but what if blank field had two spaces? Probably better to use Length(Trim([Field])) = 0 to check for blanks.
Sir
I want to create crystal report using vb to display two different tables of MySQL. One table returns only one record (parameters during shift takeover) but other table should display multiple records ( events in a shift duty)
It works perfectly when I create individual reports, but when I combine using sub report, only sub report is displayed, main report disappears immediately after just displaying.
Hi John - happy to help. We charge an hourly rate for services. Please email me at gene@marksgroup.net and we can offer assistance. thanks.
Ron Paul!!!