Search results for query: *

I did group that way and it didn't work. I finally got it figured out, though. I did the following: total(CustomerCount) for (CustType + Seq#). This gave me what I needed. Thanks for your input.

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

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

I just got this working - thanks for the response. What happened, is that when I copied the catalog, it did not automatically change the name of the database (when navigating to catalog->tables) The first level lists the dsn connection and the second level lists the database. I renamed this...

Yes - I can create a new report to do that....my question was is there any way to format the dates from a sproc report....it looks like the answer is no? Thanks for your input.

How would I specifically do that? When I look at the Query Data area, the only thing I can see is in the SQL tab (the call to the stored procedure), the group tab (all the data fields in the order they are grouped), the Access tab (data source and query options) and the profile tab creates an...

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?

Thanks for your help - I really appreciate it. I would really like to avoid the sql you suggested. The issue I have is that we have a BUNCH of stored procedure reports - using Access as our main reporting tool to call the stored procedures. We have purchased Impromptu and are in the process...

Yes - that's correct.

Here is the sql for the sub-report. The id from the main report appears to be hard-coded in the sub-report every time I scroll through the id's in the main report - 985 changes to the next id when I scroll. Not sure this is helpful. select T1."iCompanyId" "c1" from...

Here is the sql for the main query - a listing of company id's that meet specific criteria. Let me know if you need the sql for the sub-report (the detail information that I need for all id's in this main query). Thanks. Snapshot was created using the following SQL: select distinct...

OK - I figured out how to scroll through the data with the suggestion saikat123 gave me. Is there a way to see all the data at once versus record-by-record?

Thanks for the input - I have submitted an incident with Onyx (since we purchased Cognos through them). As far as the suggestion from saikat123, it appears like your suggestion should work. My first recordset has 86 id's which is correct, but when I create the sub-report and link the id's the...

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