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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Impromptu Scheduler error
I am trying to run scheduler but error message "Internal application error" keep showing. report was created on version 7.1.339.0, I am runing scheduler on version 7.3.1413.0. I tried print the report, save the report, snapshot the report, none is working. Thanks Ethan- EthanL
- Thread
- Replies: 0
- Forum: Cognos solutions
-
write SQL that will give me desirable format
Following SQL gave me the correct result but not desirable format, how can I modify my format so I can have the lay out I want? Select HSP_ACCOUNT_ID, PAYOR_ID, sum(tx_amount) from hsp_transactions Where HSP_ACCOUNT_ID=70000958 and (TX_TYPE_HA_C =3 or TX_TYPE_HA_C =4) Group by HSP_ACCOUNT_ID... -
report with multiple expense summary
I try use Cross tab query but cross tab only allow one value. is there any way I can creat a report like excel pivot table using access? my database includes folloing colums: product, quantity, sale price, allocated adm exp, allocated purchasing exp, allocated supplies, allocated...- EthanL
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
