Search results for query: *

Yes, that is correct.

Perhaps attribute would descirbe better than level. Driven from the member table there are 10 attribute boolean fields (t/f). With each attribute having its own subreport. I don't want a seperate page for each subreport so this may be be the best way to set it up.

Yes, each membership level is currently in a seperate subreport. To better understand; smith - Pool gym tennis Jones - Pool tennis golf beach Then each, such as pool...

ok, Member A has 3 out of 10 possible memberships. The report needs to show the 3 levels member A has. Then member B, C and so forth with each corresponding membership. Each membership needs 4-6 inches of space on the report. Is this better?

Hello, I am trying to create report where each ID can have 1 to 10 designators. Each designator has a small report required. I tried a single report with all 10 and it is 4 pages long. If an ID has only 3 designators can a report be created to print only the 3 needed on one page? Sort of a...

Another way to do this for year format -> nts = Format(nts, "mm/dd/yyyy hh:mm:ss")

My current project is giving me headaches too. I am doing something similar. I am importing a text file, through VB6, into an Access 2000 table. At this point I am stuck. I need to blank out the table. I thought of placing a copy of the table with just the structure in the mdb and doing a...

Hi All, Using VB6, RDC 8.5 Triing to figure out how to get a subreport pointing to a second ADO record set. This report pulls form 8 tables. Recordset are created useing VB to create the ADO recordsets from Access 2000.

Ken, What do you mean by a filtered recordset? Can the sub report have a seperate RS? I have a report using a select and building an ADO recordset in VB6. Can I build and pass a second and seperate ADO recordset to a sub report?

Hello all, I am creating reports in VB using RDC. I can connect via jet 4.0 to the Access 2000 database and run a select statement to populate a report. Now I am looking to use the functions in the Access database which can do all the lookups I need. ie. A field label is determined by...

Thanks. I need to buy a big fat book on VB6.

Hello All, I am not much of a VB user but I am learning. I am attempting to write some code that will launch a report using a dynamic path to the MDB file. As the user might install it anywhere I will not know the location untill it is installed in the directory with the MDB. Is there a way...

First create and ODBC connection. Then in Crystal start a new report using the expert. Select Databases ADO make new connection , Uses ODBC connect for ADO Click ADD and select Query Name OK Close NEXT, Select Fields

Check out the Runtime.hlp file which is installed with Crystal. It lists all the files needed to run all aspects of CR.

Thanks Ken. That method works well I put in TableName="Master" FieldName="PPR" Thanks again.

When I create the report using ODBC all link options are available. Table B is used for many other tables too. Code 11 which matches PPR exists in 10 records. I am triing to match the fields tablename, fieldname and code2 in order to select the correct description. Using ODBC the formula...

I don't actually see a =>. The grayed out radio button is equal (=). The link show an equal join. When a suppress all duplicates it looks ok. Of course when I click on a field I see all the suppressed duplicates. When I did the experiment mentioned above I get 10 records. The first one is...

The link expert does allow me to set a link. PPR to Code2. It does not let me change it. And thank you for your patience. I am still a newbie with crystal

After I select the tables the link expert does not allow me to designate the type of link. Under options the radio buttons are grayed out. Is this because I am going straight into Access instead of using an ODBC connection?

Yes. As a test when I place the field from the second table on the header the record count jump up to 10. PPR and CODE2 each contain the same values.