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...

No, I resolved the problem. I've to install the service pack 3 for CR 8.5. Ciao da N@poleone

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...

Thanks for all your suggestions. I resolved the problem with the functio Chr to write the character "&". Ciao da N@poleone

The error is at runtime: error number 3061. I think it is the "&" character into the string. Now I'll try with the Chr(0026). Ciao da N@poleone

Sorry, maybe ow i'm OT. The Idea of concatenating the two fields is wonderful. Now the problem is: is it possible in MS Access??? Your solution returs me a error in VB and I don't know if is fault of VB or Access This is the new code: "SELECT trajectory_id, traj_type, 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, 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" & _...

I think that the only solution is to make four subreports. I wonder why a so powerful software like CR isn't able to group not hierarchically on different fields!!! Perhaps this problem is solved in newer version than mine??? (8.5) Ciao da N@poleone

I would prefer the first solution, but I don't understand how base a formula on several fields! I have to return an array??? but it isn't possible!! I can't imagine other way to return the data of interest. Can you give me a start point, a suggestion to make the formula, then I could go ahead...

I tried to change the join type (it is equal join, perhaps this is the problem), but all the options in the Visual Linkink Expert, in the section Link Options, are unavailable (grey). Where do I can or add the right options to the join type as you say above Ciao da N@poleone

I changed the linking between the varoius tables and also between the main report and the subreport. Now the result is this (putting the two query fields in the details section togethet with the other fields) details query2 query2 query2 query2 query2...

I don't understand very well, however I changed the linking between the varoius tables and now the result is this (putting the two query fields in the details section togethet with the other fields) details query2 query2 query2 query2 query2...

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...

Sorry, I forgotted the technic characteristics: CR 8.5 VB 6 Ms Access 97 Ciao da N@poleone

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...

Sorry, I forgotted to tell you that I'm using CR 8.5, VB 6.0 and MS Access 97 Ciao da N@poleone

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...

Sorry, but the link doesn't work. Ciao da N@poleone