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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ret83
-
Get all displayed fields of a report
I found two other possibilities to do this task: ° To loop through the active report: for x=1 to 1000 for y=1 to 1000 getdatavalue(x,y) next y next x ° To export the report as a text file, read in the text file and replace all these long spaces with my delimiter. I guess that is the best way.- ret83
- Post #6
- Forum: Cognos solutions
-
Get all displayed fields of a report
That works fine on a simple list report, it shows all columns, also the filters, and the .Name is just the column name in the corresponding table. When I use it on a sample report with nested sql statements (e.g. Percentage of Group.imr) the QueryItems are the values from the inner query, not...- ret83
- Post #5
- Forum: Cognos solutions
-
Get all displayed fields of a report
Dave Griffin, thanks for the fast answer. Actually you're right. But I need to do it this way. You think it isn't possible to do it better than my solution but as a macro? thx.- ret83
- Post #3
- Forum: Cognos solutions
-
Get all displayed fields of a report
Hi, I'm writing a macro which loops through the columns and rows of a simple list report with some filters applied. I use the following code to do that: rowcount=objImpRep.RetrieveAll + 1 colcount=objImpRep.QueryItems.Count For rc = 1 To rowcount For cc = 1 To colcount fieldvalue =...- ret83
- Thread
- Replies: 6
- Forum: Cognos solutions
