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!

  • Congratulations strongm 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. elsolo21

    Update a table from another table

    Yep, I just got that...5 minutes too late to post it. thanks for the help.
  2. elsolo21

    Update a table from another table

    Maybe this is just my lack of SQL experience but how would 'O.[2010] = N.[2010]' work if 2010 doesn't exist in Table1? Also, I don't think I see how this would work when Table2 brings in a new combination of Company,State and line with the right join thanks, -Eric
  3. elsolo21

    Update a table from another table

    Lets see if this helps: Existing table 1: Company State Line 2005 2006 2007 2008 2009 A NY P 100 200 200 300 400 B PA L 100 200 200 300 400 A PA Q 200 230 300 400 400 New Table 2: Company State Line 2010 A...
  4. elsolo21

    Update a table from another table

    Thanks for the reply. You're right, the structure is horrible but there are so many things built off it that it would be a huge project to change it. I thought of an append query but then I would just have double the records and the attributes would be doubled in some places. One thing that...
  5. elsolo21

    Update a table from another table

    I have an existing table with about 10 attributes and columns for 5 years of data. I want to take another table with similar attributes but only one year of data and update the first table. This one year is for a new year which does not exist in the first table. For example: Table 1 attr 1...
  6. elsolo21

    I’ve tried everything I know but the report still says the date prompt

    Maybe I'm not understanding what you're doing but even if the prompt is optional, it still needs to show. I have your issue myself and I've had to create two separate reports. One with the date logic built into the filters and another for the user to use with the date they want. -Eric
  7. elsolo21

    Ajax support for Cognos

    I apologize if I'm asking this wrong but does Cognos support AJAX at all? If not, does anyone know if there are plans for that. I talking about AJAX support for Cognos Connection and non-'studio' work. I find it very cumbersome to manipulate reports between folders with the constant refresh...
  8. elsolo21

    Report errors with Excel/PDF output

    Our Admin figured it out. I had a join between two queries. In one of the queries, I had a calculated field on top of the list in the Query explorer window and the item I joined with below that. She flipped them and it worked. We're not quite sure why it worked. I don't see how that and...
  9. elsolo21

    Report errors with Excel/PDF output

    I'm using Report Studio 8.3. I have a report that validates fine and I get output with html but when I select any Excel or PDF option I get the following error: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the...
  10. elsolo21

    Scheduling issue

    Since our tables are updated nightly, I made sure that the report is scheduled mid-morning to avoid time issues. The only time I will have problems is if there are technical problems on the backend and the database isn't updated correctly. But that's always an issue with whatever you do...
  11. elsolo21

    Scheduling issue

    Thanks, that gave me the general idea of what to do. I had to use different functions but the idea was the same. I'm using Cognos Report Studio 8.3. I apologize for leaving that out before. The statement I used for one of the dates was: (IF (_day_of_week(current_date,1) IN (1,2)) THEN...
  12. elsolo21

    Scheduling issue

    I have a report that has two date prompts that needs to be scheduled Mon-fri, but the dates are different based on what day of the week it is. My chart is (Date1 and Date2 are referring to the day in the previous week): Today Date1 Date2 Monday Wed Thurs...
  13. elsolo21

    Unable to save/open as Excel or .csv output - intermittent problem

    It was the Google toolbar. I noticed she had it yesterday and I totally forgot about that messing up a lot of web applications. She allowed pop-ups and it worked and then she just uninstalled it since thre was no need to have it. Thanks for the help. I looked at IBM support but I must've not...
  14. elsolo21

    Unable to save/open as Excel or .csv output - intermittent problem

    I know this is not a Cognos issue but it seems to have only come up with one of my users who is trying to output reports in either Excel or .csv format. Most of the time, the report runs, a box pops up for a split second (Way to fast to see if anything is in it) and then closes with no output...
  15. elsolo21

    Sorting Text items

    Even though I couldn't reformat them, I used your suggestion to sort on length and that worked perfectly. Thanks for the help!
  16. elsolo21

    Sorting Text items

    When I used your SQL (and other methods to reformat) I get: An error occurred while performing operation 'sqlOpenResult' status='-28'. I'm not sure what that's about. Any ideas? thanks for the help.
  17. elsolo21

    Sorting Text items

    I have a data element that is formatted as text. The are actually dollar values. I need to find a way to transform them in Cognos to be able to sort in value order, not text order so instead of: $1,000,000 $5,000 $70,000 I need it to be: $5,000 $70,000 $1,000,000 If I knew the list of...
  18. elsolo21

    Conditional Filters

    I think I'm either missing a really easy concept or looking at this the wrong way. My problem is that want a filter to be 'optional'. What I'm doing it I'm prompting the user if he wants to use a filter. If Yes is selected, then the data is filtered, if No is selected, then all data...
  19. elsolo21

    Forcing 'zero' rows

    I thought I saw this somewhere but I can't seem to find it. I have a list report from Report Studio 8.3 where I have 2 data elements plus the month number (Jan=1, Feb=2, etc) and then a count. I concatonate those first three fields so I have that and the count. The problem is that not every...
  20. elsolo21

    Parsing Error

    This seems like the easy answer but are you using an '=' sign instead of 'in' on your filter for this item? -Eric

Part and Inventory Search

Back
Top