Crystal Report

[libra78]

I need help in crystal report.
1) i have report grouping with two fields so when I view the report it gives me more than one table, the last table in the same page gives me only the header with one line of record and displays all the records in the next page, is there any chance to move this table to the next page and display it with its all records and so on for all pages?

2) i have string comming from database as example "20020902" its a date but its define in the table as string so how can i display it in the report as "02/09/2002"?

so please help me in this problem
and thanx

[Bonker Gudd]

1) Have you tried right clicking in the Group Header and choosing Change Group and then checking Keep Group Together?

2) Create a formula with:
Date(Left(string, 4), Mid(string, 5, 2), Right(string, 2))

[damica]

You could try the DTSTODATE("STRING") this is a function built into Crystal report.

[libra78]

thank you so much but can you help me in other problem
1- when i designed the report in crystal report and define the data base from data Explorer + database Files + find data base
when i ever i call the report from the visual base code the report always connect to the data base that i refred in designing not the the database that call in the code :

frmSelect.CrystalReport1.Connect = database_path
rmSelect.CrystalReport1.ReportFileName = reportPath

2 - and how can i make new page for each group in crystal report in the runtime in VB6

so how can i fix these problems , please help me and thank you