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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Replace Function for Apostrophe character in the Report.net
This worked! Thank you!- dslaster
- Post #10
- Forum: Cognos solutions
-
Replace Function for Apostrophe character in the Report.net
I have a problem similar to this. We just upgraded to Cognos 8.4.1 and this worked before in Cognos 8.1 MR 2. I want to select all names that don't contain an apostrophe. This is in my filter: [Business View].[Constituent Person View].[ADDRESS_NAME] not like '''' When I try to validate the...- dslaster
- Post #8
- Forum: Cognos solutions
-
Union with SQL
dmunson, I tried what you suggested. I am on CRN, and it wouldn't let me add queries 1 and 2 as children to query 3. Am I supposed to add the tabular models from 1 and 2 to 3? If not, how do I add the queries? When I go to the report page, it lets me add the facts from query 1 to the report...- dslaster
- Post #7
- Forum: Cognos solutions
