Last post Jan 21, 2012 04:23 AM by ashish_ksharma1227
Jan 16, 2012 01:19 AM|ashish_ksharma1227|LINK
i am trying to devlop a report in colom wise like
Vender1 vender 2 vender 3 vender 4 ........... Vender_n
Namevender1 namevender2 namevender3 namevender4 namevender_n
MailIDvender1 mailIDvender2 mailID vender3 mailid Vender4 mailidVener_n
Also no of vender is come from DB.
how can we do this
Jan 16, 2012 01:32 AM|Sankalpa|LINK
Try here SAP crystal report user traning
Jan 16, 2012 03:57 AM|ashish_ksharma1227|LINK
I heared something abt pivot and unpivot
to di this........
will u please help me how can i do this
Jan 16, 2012 04:14 AM|Sankalpa|LINK
Pivot tables are called as "Cross-Tab" in crytal report world,
You can add a Cross-Tab table in to your crystal report by selecting menu Crystal Report -> Insert -> Cross-Tab or Right Click on report area and select Insert -> Cross-Tab
there is small wizard you can add columns, and rows to your cross tab table and formatting its row
hope this help :)
Jan 16, 2012 04:58 AM|ashish_ksharma1227|LINK
ye dear i saw this but when i am using this its mendetory total.
i dont want to total this. please give me detail idea abt Cross tab
Jan 16, 2012 06:50 AM|ashish_ksharma1227|LINK
Is there is any opetion to transform row in to colom in crystal report?
Jan 16, 2012 07:01 AM|Sankalpa|LINK
you can hide the total in the cross tab
Jan 16, 2012 07:02 AM|Sankalpa|LINK
yes the way is cross-tab
Jan 17, 2012 12:52 AM|ashish_ksharma1227|LINK
When i am trying to do this with crosstab
its look like
Vender1 vender 2 vender 3 vender 4
Namevender1 namevender2 namevender3 namevender4
MailIDvender1 mailIDvender2 mailID vender3 mailid Vender4
i pur colom as vender
and row as Nameof vender mailidof vender
and hide total
is any thing i am doing wrong
Jan 18, 2012 12:45 AM|ashish_ksharma1227|LINK
Dear Fdrs i try to do this with Crosstab but i dont want to sumrrized data(sum,count etc) means i want as it it data that is in DB.
So what should i do? for doing this is any opetion for doing this.
What should i do when no of colom Exceed .
Jan 18, 2012 05:23 AM|ashish_ksharma1227|LINK
Please help me out
I do this Cross tab
but now problam arraies on daynamic colom
no of colom exceed per page.
I converted this to PDF and set priter serup fir to page
but cross tab data shown on botton of the page not with reletivent position
Jan 19, 2012 01:27 AM|ashish_ksharma1227|LINK
Its very urrgent
How can i fix the position of cross tab
Jan 19, 2012 06:41 AM|Sankalpa|LINK
with crystal report only way is cross_tab, but if you can use SSRS report there is matrix control.
Jan 21, 2012 04:23 AM|ashish_ksharma1227|LINK
Its be done eother by Cross tab in crystal report or Through pivot/unpiovt query in sql server.
I do this by Cross tab
Taking vendename as colom
and mailid,name be taken in summry as mode