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 TouchToneTommy 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 BillOfPlano
-
-
How to edit SQL with parameter
Thanks a lot. Can the child has more than one column in select...So, in effect, I have ([field1], [login]) in ([tabular model1].[field1], [tabular model1].[login]) also, the setting of Cross Product to 'Allow' in the parent query or child query -- assume parent. Right?- BillOfPlano
- Post #5
- Forum: Cognos solutions
-
How to edit SQL with parameter
Yes. But, we notice the sub query will have much better performance than the join. I just wondering how can I doing a subquery -- do I have to do it in framework manager? Bill- BillOfPlano
- Post #3
- Forum: Cognos solutions
-
How to edit SQL with parameter
Hi, I am a new user and just start to learning Cognos ReportNet. How can I edit the report sql and add the following where condition into the report sql: ( ('*','$LOGIN$') IN (select perm_value,user_name from user_permission where permission_type = 'supplier') OR (im_supplier.supplier_name...- BillOfPlano
- Thread
- Replies: 6
- Forum: Cognos solutions
