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 Chriss Miller 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: *

  1. galaxy0815

    IMR Data output shown differently on different PCs

    Hi drlex, I copied the impromptu.ini file from a machine where it it working to one where it is not working. Normally I would expect that the other machine has the same settings after the file copy was done. But still the same issue. The imr file looks different on both test PCs. Any other...
  2. galaxy0815

    IMR Data output shown differently on different PCs

    Hi, I have a strange issue with Cognos Impromptu 7.4.4 that I never faced before. What I have done: I have created an SQL Query(not via Catalog drag&drop, but via hardcoded SQL) and placed this query into an IMR file. Finally I formatted all columns in the way I wanted and saved the file...
  3. galaxy0815

    date calculation - 12th of last month

    Thanks!
  4. galaxy0815

    date calculation - 12th of last month

    Hi, Can you please let me know if there is an easier way of calculation from todays date the 12.th of last month as this one here: date(trim(Char(YEAR(CURRENT DATE - 1 MONTH)))||'-'|| trim(Char(MONTH(CURRENT DATE - 1 MONTH)))||'-12') Looks so complex for this simple task. Thanks
  5. galaxy0815

    Rekursive SQL Query

    @MarcLodge, Your point is correct, but this issue just occured when I copied the statement here. Seems that it was missed when I did copy and paste. But the statement I try to execute (which contains the AND) still fails with above error message which I do not understand. Can anyone please...
  6. galaxy0815

    Rekursive SQL Query

    Hello, Sorry to come back on this again, but I have an additional issue: I tried to write the above mentioned query here: SELECT t1.Clientnr, t1.Country as Old_Country, t2.Country as NEW_Country, t1.Stopdate as Changedate from ClientAddress t1, ClientAddress t2 where t1.Clientnr =...
  7. galaxy0815

    Rekursive SQL Query

    This works perfectly! Thanks very much!
  8. galaxy0815

    Rekursive SQL Query

    Hello, I have an issue with a query I need to create. The following in my Basic table with the name ClientAddress: Clientnr----------AddressLine---------Country---------Stopdate 47-----------------Mainstrett3---------GERMANY---------30.Nov.2010...
  9. galaxy0815

    subselect - Resultset in a comma separated row

    Hi, Still trying on my side, but maybe try with one of the below: SELECT replace(replace(XMLSERIALIZE(CONTENT xmlagg(xmlelement(Name a, CAR)) AS VARCHAR(32599)),'<A>',''),'</A>','; ') FROM car_availablility or SELECT replace(replace(xml2clob(xmlagg(xmlelement(NAME a...
  10. galaxy0815

    subselect - Resultset in a comma separated row

    Hello, Please be advised that I have a complex SQL Statement that joins various tables. Within this statement I want to do the following (not sure if this is possible): As 3rd field in the select part of that complex SQL statement, I want to enter a subselect that runs over a table called...
  11. galaxy0815

    SQL Multiple Joins + Subquery limitation

    Sorry for this. I was not aware that this "truncation" of the Sql would have such an impact as I thought it would be enough to post just the part were I have the issue with. The next time I face such an issue I will post the full SQL statement. Thanks!
  12. galaxy0815

    SQL Multiple Joins + Subquery limitation

    Hello, Please be advised that I tried to simplify the SQL a bit (so showed pseudocode). Therefore I just wrote select * from. The important part was the integration of the select max().. into my multiple joins. And this is the solution (again just showing the join part): ... LEFT JOIN...
  13. galaxy0815

    SQL Multiple Joins + Subquery limitation

    Hi, here is the query without pseudocode and I tried to format it manually a bit better. Select Employeegroup.* FROM ( ( ( SRS.Employeegroup AS Employeegroup INNER JOIN SRS.Employeedetail AS Employeedetail ON Employeegroup.ID = Employeedetail.ID and Employeedetail.ENTITYTYPE='01'...
  14. galaxy0815

    SQL Multiple Joins + Subquery limitation

    Hello, I searched already through the web and the forum but could not find a solution for my issue. The issue is I have a query with several left and inner joins and I want to limit one of the joins with a subselect. But obviously this is not working. Here is the pseydocode of my query: select...
  15. galaxy0815

    Impromptu 7.4.4 - Script 'switch to' error message

    Hello, Quick question on Cognos installation. We received new PCs in our Offices (better hardware, same OS (Windows XP SP3)) and since that we have the following issue: When we run Cognos Scripts (they run reports, create folders and save the files in there) we always get the following error...
  16. galaxy0815

    Cognos Macros - save .MCX files in different folder?

    Hello, It might be a simple question, but I could not find any solution for this. We have several Cognos Script Macros (that run Impromptu Reports). As soon as you run such a Macro (.MAC) it saves automatically the compiled .MCX file in the same folder. Is there any way (either in Impromptu...
  17. galaxy0815

    Cognos Impromptu - double quote output

    Hi, Thanks for your help on this! I was able to change a bit on the project scope and so I can create the report without those double quote columns.
  18. galaxy0815

    Cognos Impromptu - double quote output

    The thing is that I need to re-create a specific file format where the output is saved in ascii / csv and it is required that not all columns are surrounded by "" signs. There should be just one column (a blank column) that should be sourrounded by those signs, but I do not get this working. So...
  19. galaxy0815

    Cognos Impromptu - double quote output

    Hello, I tried in several ways to create a report field that should just show "" (double quotes) in the final csv/xls output but I was never able to get this working. Either nothing (blank) was shown in the output or I had """"" or """""""" in the output. Does anybody know what I need to...
  20. galaxy0815

    BO Edge XI31 - scheduling + password protection after database upload

    Hi, Hope anybody here can help me. The Firm I am working in bought a few months ago "BusinessObjects Edge Standard XI 31" application. But as far as I understood till now the application has some limitations which are for us a requirement to have. Those are Scheduler: - Scheduling on...

Part and Inventory Search

Back
Top