Recent content by knzy

In the Crystal SQL Designer (V8.5), the 'Save data with query' option is automatically set to on whenever you retrieve any data. With this option on, the report always uses this set of data without refreshing when press the 'refresh' button in Crystal Report. This is confusing. Is there any...

Hi There, I have a report using .qry file as datasource. It needs to run on a PC that doesn't have Crystal SQL Designer (but have Crystal Report 8.0 installed). Will this be a problem? I turned the 'save data with query' off. When I run the report, there are an extra set of parameters...

It dones't work. What I am doing is like this: 1. insert a text box 2. insert the Word format database field into th text box 3. make sure the can grow is on. I also tried to insert the memo field into an OLE object, but seems the OLE object doesn't receive it at all.

sorry I didn't explain the situation clearly. The word files are stored in database as 'text' fields. I need to show them in Crystal Report. If I just drop the fields into the crystal report, it is not shown with the correct word format. I guess I should use OLE object field, but I couldn't...

Hi! All, I want to display a memo field which is in word format. Because the word format, the memo field can not display properly. Can I change the field back to clean text? Or is there any methods to show the word format field? Regars, knzy

Hi! Hillary, Thanks for your prompt reply. Yes, I want to suppress all the sections except for the report footer. According to your instructions, I have suppress all the sections in the subreport. But the deail sections still occupy some very tiny space. And the space used by all the detail...

Hi! There, I have a subreport returning shared variables in the detail section, so I can't suppress the section. But since there are so many records, the minimized detail sections still occupy a lot of space. Only the report foot needs to be displayed actually. What can I do? I tried the...

dateserial(year({@StartDate}),month({@StartDate})+1,day({@StartDate})-1)

I only need GH1s and GF1s in this report. GH1 has a subreport returning a shared variable, and GF1 shows some data. I use the shared variable from GH1 to decide if suppress GF1. Problem is that there are a lot of continuous GF1 need to be suppressed, so the GH1s will accumulate to a huge blank...

My .qry file runs well in SQL Designer, but I can't add it to any reports, even brand new standard reports. I am using subordinary sentence in the .qry file, do you think this will cause the problem? Thanks, Knzy

The subreport needs to do 2 things: 1. to return a shared variable to main report for deciding if the group need to be suppressed; 2. if the group will not be suppressed, to show some records in the group footer. I found I have to run the subreport twice - one in group header to decide if...

Hi! There, I would like to use solution 2 - do T3 in a subreport in a group footer. The problem is that I need to suppress the whole group if the subreport gets nothing qualified. Then I have to run the subreport twice: one in the group header to decide if the group need to be suppressed; one...

Hi! All, I need to link 3 tables, let's say T1, T2 & T3. T1 is the primary table, and it is one-to-more relationship between T1&T2 and T1&T3. If for each record of T1,I have 2 records in T2, 2 inT3, I will get totally 4 records in CR. This will cause performance problem becuase all 2 tables...

Hi! All, After all, I created and called the UDF sucessfully. Thank you all for your help. The problem I encountered is caused by an error in the VB source code I copied from another website. Thanks again, Ro. Regards, Knzy

Hi! All, According to the FAQ mentioned above and articles in kbase, I created UDF successfully. Everything looks fine until I run the report. The formula contains the UDF show nothing on the report. Any idea? Regards, Knzy