Search results for query: *

Hi, I'm implementing a process in DB2. This process is made of an origin table, a SQL step, and a destination table. The destination table has 5 colums, on of these is a code and i generated as always. The problem is that the sql step has to map the 4 columns of the origin table in the 4 columns...

Hi, I'm using CR 8.5, VB 6 and Access 97. I created the reports on a computer with italian language, and on my machine and other with italian when I try to open the report exported in .rtf with Word all works fine. When I try to open the reports on a machine with English language, Word give me...

Hi, The problem is that i've to specified two fields before the IN. This is the code in VB: "SELECT trajectory_id, traj_type, att_time FROM TRAJ_SCENARIO WHERE scenario_id = '"& _ scenarioName & "~bak' AND ((trajectory_id, att_time) NOT IN (SELECT trajectory_id, att_time from" & _...

Hi, The problem is that i've to specified two fields before the IN. This is the code in VB: "SELECT trajectory_id, traj_type, att_time FROM TRAJ_SCENARIO WHERE scenario_id = '"& _ scenarioName & "~bak' AND ((trajectory_id, att_time) NOT IN (SELECT trajectory_id, att_time from" & _...

Hi, I'm using CR 8.5, VB6, MS Access 97 via Database Files. I've in the details section of a subreport the data that i want to view. They are 4 field of the db: table.tizio table.caio table.semprionio table.time More over I want to visualize other field that are the result of a query of the...

Hi, I'm using CR 8.5, VB6, MS Access 97 via Database Files. I've in the details section of a subreport the data that i want to view. They are 4 field of the db: table.tizio table.caio table.semprionio table.time More over I want to visualize other field that are the result of a query of the...

Hi, Is it possible to insert four groups based on different fields in the same report??? I don't want a hierarchical grouping but four independent groups. I thought the solution could be the subreport, but the problem is that I'm already in a subreport and I know that I can't make a subreport in...

Hi, Is it possible to insert four groups based on different fields in the same report??? I don't want a hierarchical grouping but four independent groups. I thought the solution could be the subreport, but the problem is that I'm already in a subreport and I know that I can't make a subreport in...

Hi, Months ago I made a report with CR 8.5. Now I have to modify the db and also the report. I have to delete one of the three tables of the main report and another has lost a field. Before there was a subreport referring to the table that I deleted, now I deleted also the subreport. I selected...

Hi, I'm developing an application with VB 6, CR 8.5 and MS Access 97. I made over than 30 reports, but one of these return me the error code 500 (Not enough memory)!! The problem is also that the report is called in two parts of the code. One's work fine, the other no. This is the code that...

Hi, I have some "amusing" problems when i resize a form. i expalin: i've a form with a frame and a picture box into it. In this picturebox is printed a report preview with the api functions of crystal report 8.5 if i resize starting from the corner down in the right, and holding pushed...

Hi, I want to suppress my subreport if a field is blank. I have a main report with two subreports in the section Report Footer b and c. These subreports are never completely blank: in the report header there is a text box; They are divided into groups: in the group header there are 3 text box...

Hi, I'm trying to make a form in VB that visualize the preview of the report. I'm using the ocx control and CR 8.5 and Access 97 with DAO. I introduced in my project the file global32.bas with the API of CR. The problem is: I want to change the db name of the subreport inserted in the main...

Hi, I'm trying to make a form in VB that visualize the preview of the report. I'm using the ocx control and CR 8.5 and Access 97 with DAO. I introduced in my project the file global32.bas with the API of CR. The problem is: I want to change the db name of the subreport inserted in the main...

Hi, I'm trying to make a from in VB that visualize the preview of the report. I'm using the ocx control and CR 8.5 an Access 97. I introduced in my project the file global32.bas with the API of CR. The problem is: I want to change the db name like when i print the report. Infact if the report is...

Hi, I'm trying to make a from in VB that visualize the preview of the report. I'm using the ocx control and CR 8.5 an Access 97. I introduced in my project the file global32.bas with the API of CR. The problem is: I want to change the db name like when i print the report. Infact if the report is...

Hi, I'm using CR8.5 e VB6. In my application I'm not using the new RDC but yet the OCX control for exporting the reports; but now, I want to view the preview of the report in the VB application. In the manual of CR I found the Report Viewer Control, but it has seemed to understand to me that...

Hi, I'm working with VB6 e CR8.5, and I use the rptControl. When I click the print report button (that is a command button) I want that the report is printed without another window (Export Options) where, in theory, I can choose if i want one page or al pages. How Can? Bye N@pol€on

Hi, is it possible that if I inserted new records in the database then the reports don't work? The eroor is: Error detected by database DLL. If i verify the datadase, it says that now is up to date and then it works! But the report that didn't work had some subreport or grouping, while the...

Hi, This is the problem: I have to suppress three subreport if no record is reported. 'Cause I'm not able to do this, I think to suppress all the field in the subreport. The problem is that the report header is always suppressed or never, why? Thi sis the code: In the suppress formula...