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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
crosstab returning duplicate rows
We are using Cognos 8.2. Have built a list report based on a SQL query which returns desired rows and results with no duplicates. We then used the 'Pivot list to Crosstab' from the Structure menu to convert to crosstab. We configured the crosstab and it returns rows. However it returns...- JoeyArr
- Thread
- Replies: 2
- Forum: Cognos solutions
-
SSIS Check if file exists for 60 minute window
Hello, I am new to SSIS programming and am working on a project to check if a flat file exists on a file share between 5 and 6pm only. If not there, email failure status to be sent. If there, query flat file and output to another flat file and output to new folder. Then email success...- JoeyArr
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
count responses across a row
I have a simple survey form which I am trying to count 'Yes' responses to a series of 15 questions. I am not able to count across the row of data in the Responses table accurately. My formula looks as follows: Totalyes:[question1]*-1+[question2]*-1+[question3]*-1...- JoeyArr
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Passing Field Value
Trying to pass my projectID field to my next form in sequence. But the following form seems to write a new record. I have it set up with a switchboard for mainly navigation purposes. The users will navigate through forms according to the request (logo, writing, event and such) On the main...- JoeyArr
- Thread
- Replies: 18
- Forum: Microsoft: Access Forms
