 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Crystal Report / July 2008Columns
Hello All, I have a question about columns in Crystal Version 8.5. I hope this is the right group. Here is my question. I have a report and in the detail section I have it set for 2 columns then under that in the footer section for the group I have a graph of the data in the detail section. What I would like is if there is 16 rows I would like 8 in the first column and 8 in the second column. I know I could tell it to go from left to right but I want my data to go down and then over after X amount of records. If there are 20 then 10 and 10 if there are 19 then 10 and 9, etc. Thanks for your help, Rodger > I have a question about columns in Crystal Version 8.5. I hope this > is the right group. Here is my question. [quoted text clipped - 6 lines] > down and then over after X amount of records. If there are 20 then 10 > and 10 if there are 19 then 10 and 9, etc. Hmmm. I've tried to do this and failed. Very annoying. Andrew  SignatureAndrew Gabb email: agabb@tpgi.com.au Adelaide, South Australia phone: +61 8 8342-1021 ----- Andrew, I think I have an idea I just do not know how to do it . . .. . OK If I create a SP with a TEMP1 Table and order it the way I want which is date then I have another temp table to add a sorting field. I count how many rows I have for each group I then update the temp table A1 for the first record A2 for the second B1 for the third B2 for the fourth, C1 for the fith and C2 for the sixth, so on and so forth. Then if I have it sort by that new column and have Crystal go across then my data will look like this A1 A2 B1 B2 C1 C2 I am just working on how I can do this . . . . > > I have a question about columns in Crystal Version 8.5. I hope this > > is the right group. Here is my question. [quoted text clipped - 10 lines] > > Andrew Obviously if you are willing or able to make temp tables then it's not a problem. (I usually can't.) It's even easier if you're making the table row by row. There are lots of ways to do this, but I'd probably add "X" and "Y" fields rather as you have done. Then use a subreport to group on Y to give the rows. A bit of fancy footwork then shuffles them to their right position in the row. One other obvious way is to store the data in an array and put it out in a text box, any way you want. Using html or rtf you can format it as well. But usually it's not worth the effort. I do this occasionally for short summary lists. Andrew > Andrew, > [quoted text clipped - 28 lines] >> >>Andrew SignatureAndrew Gabb email: agabb@tpgi.com.au Adelaide, South Australia phone: +61 8 8342-1021 ----- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.