Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: deangelis
  • Order by date
  1. deangelis

    Column Identity and Datawarehouse

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

    Problems of language???

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

    Problems of language???

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

    Problems with subquery

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

    Problems with subquery

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

    Problems with subquery

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

    Prblems with subquery

    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" & _...
  8. deangelis

    Problems with subquery

    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" & _...
  9. deangelis

    How can i make this groups

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

    How can i make this groups

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

    It prints too much records!!

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

    It prints too much records!!

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

    It prints too much records!!

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

    It prints too much records!!

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

    It prints too much records!!

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

    How can i make this groups

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

    How can i make this groups

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

    Grouping

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

    Grouping

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

    PE_ERR_ERRORINDATABASEDLL

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

Part and Inventory Search

Back
Top