Search results for query: *

Using VB6, Crystal 8.5 and the RDC. I am setting the datasource of the main report and two subreports (linked on the same field) to an ADO recordsource. The data on the main report comes through fine; however, the subreports do not bring up any records, even though there are records there. If...

Thanks very much for all your help. I've changed several of the properties of the viewer control in VB and it does look much better. Setting to "" does bring up an empty tip, as you thought, so I'll just have to live with it for now! Elky Langer

Judith, >> myReport.AddGroup 0, myReport.FormulaFields(1), crGCAnyValue, crAscendingOrder<< Thanks, that's what I was looking for. This isn't documented in the help file--it only mentions database fields. I'll also shut off the group tree, since I think it looks confusing. Do you know if...

That worked perfectly. Thanks very much!

I'm looking for help with the following layout, using Crystal 8.5: There should be two columns on the report detail section. If field1=x, print in the right column ... otherwise print on the left column. BUT I don't want blank lines on either side, so I can't just put conditional suppressing in...

I'll look into it. Thanks very much for all your help! Elky Langer

Your approach worked very well, thanks. I ended up suppressing just the group header, and not the group footer. I moved the total there, instead of using the report footer--that way I got subtotals for the group when needed, and a grand total when I reset the group to a constant. One last...

OK, I take it back. :-) After researching a bit, I discovered that you do get warned if you use one of the royalty-required functions. (Still seems like a strange approach to me, though.) So I guess I can safely assume that if AddGroup went through without a warning, it is not a part of the...

Okay, so the second approach is the way to go. Thanks for the tip. As an aside, I had absolutely no idea that manipulating the report via RDC may require royalties. I didn't look into it extensively, but my original impression was that allowing the user to manipulate reports required royalties...

Crystal 8.5, VB 6 I'm trying to add a group to a report in VB using the RDC. This works perfectly ... myReport.AddGroup 0, myReport.Database.Tables(1).Fields(10), crGCAnyValue, crAscendingOrder myReport.Sections.Item(&quot;GF&quot;).NewPageAfter = True...

Did you make a change to the group after inserting the subtotal? I got the same error after I changed the group slightly. I needed to redo the subtotal to fix it. HTH Elky Langer

Thanks, that worked fine. I didn't realize it was that simple! Do you know if there's a way to check if a value has already been added to a parameter? The values I'm adding are in a database table and there may be duplicates. I don't mine leaving out the duplicates, but there's no easy way to...

Using Crystal 8.5, VB6, and the RDC: I have no problem passing regular parameters to the report via VB, but I'm not sure how to pass values to a multiple value parameter. I need to pass an array of values to a parameter. The parameter is set up in my .rpt. Now what syntax do I use in VB to...

Changed to the Active Data driver--works perfectly now. Thanks!

Using Crystal reports 8.5, the PDBDAO.DLL data access driver to connect to a Microsoft Access database: I have a report and a single subreport linked on a single parameter. The report works fine *except* I cannot find a way to left-join the report and the table used by the subreport. In the...

Actually Showintaskbar is read-only at run time; it can only be set at design time (though there is a Win API function that will allow it to be set at runtime, FYI). However, in this case, that isn't the issue. Showintaskbar is set to false. The problem is that when: 1. Showintaskbar=false; 2...

I see you left this message nearly a year ago, with no response. I too have been struggling with this problem for a long time. The msgbox issue is documented in a Microsoft KBase article; I suspect both problems are related. Making all forms modal seems to solve the problem but that's a...