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 Shaun E 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: amykrage
- Content: Threads
- Order by date
-
sub-totals by group
I have a report that looks like this (simplified for example): Seq# Cust Type CustomerCount 1 Regular 9 1 Partner 3 2 Regular 9 2 Partner 3 I want to get a total of Customer type within the sequence number. For example, I want to do a...- amykrage
- Thread
- Replies: 2
- Forum: Cognos solutions
-
Processing time excessive for stored procedure report
Can anyone tell me why the processing time for a stored procedure report would be so excessive? If I execute the stored procedure in Query Analyzer, passing variables in, it processes in 1:40. When I create a stored procedure report in Cognos Impromptu, passing variables in, it processes in...- amykrage
- Thread
- Replies: 0
- Forum: Cognos solutions
-
sproc uses datetime, I want to display date
I have an impromptu report (v 7.1) that is calling a sproc. The sproc uses datetime for a couple fields. Is there any way to only display the date in the report when the data comes back? When I try to format the field, I only get options that inlcude times. Any input?- amykrage
- Thread
- Replies: 4
- Forum: Cognos solutions
-
ImpAdmin.exe error when using Dataset
I need to select distinct records with a recordset that contains a text field. In order to do so, I am creating one catalog report with all columns needed except the text field. With a second catalog report, I am selecting the same columns including the text field I need where the company id...- amykrage
- Thread
- Replies: 13
- Forum: Cognos solutions
