RE:[sap-basis] List Report to CrossTab
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Snowy (Certified Netweaver '04/Oracle Basis consultant) on Mar 25 at 3:43 PM |  Mark as helpful |
Hi,
this is not a BASIS issue, I would post this in an Oracle forum, probably one that handles developments.
---------------Original Message---------------
From: priyapinky
Sent: Thursday, March 25, 2010 1:53 PM
Subject: List Report to CrossTab
> i have created a list report using native sql query
>
> select
> trunc(finish_time) finish_day,
> job_exit_status,
> job_exit_code,
> count(job_id)
> from dw_t_jobdata
> where finish_time >= '1-feb-2010' and finish_time < '01-mar-2010'
> and cluster_code = 1
> and (job_cmd like '%icfb%' or job_cmd like '%layout%')
> group by trunc(finish_time),job_exit_status, job_exit_code
>
>
> i need to create a crosstab report for the same , every time i go to structure and select pivot to cross tab i get error saying some asyncerror..
>
> could anyone please let me know whats wrong with doing crosstab?
__.____._ this is not a BASIS issue, I would post this in an Oracle forum, probably one that handles developments.
---------------Original Message---------------
From: priyapinky
Sent: Thursday, March 25, 2010 1:53 PM
Subject: List Report to CrossTab
> i have created a list report using native sql query
>
> select
> trunc(finish_time) finish_day,
> job_exit_status,
> job_exit_code,
> count(job_id)
> from dw_t_jobdata
> where finish_time >= '1-feb-2010' and finish_time < '01-mar-2010'
> and cluster_code = 1
> and (job_cmd like '%icfb%' or job_cmd like '%layout%')
> group by trunc(finish_time),job_exit_status, job_exit_code
>
>
> i need to create a crosstab report for the same , every time i go to structure and select pivot to cross tab i get error saying some asyncerror..
>
> could anyone please let me know whats wrong with doing crosstab?
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
SnowySAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
55% of IT Pros Use Social Media to Advance Their Careers. See the Survey Results
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
