Changing columns

[lkatz1]

Is there anyway to reverse right to left column, so a report shall print the record #1 in the right column instead of the left, when we have report with 2 column width?

[MikeC]

Re: Changing columns

David,
Sounds like by simply reversing the order would accomplish this....unless I am not understanding the question.

[lkatz1]

Re: Changing columns

We want all pages shall be reversed to start from right side

[MikeC]

Re: Changing columns

David,
If like in my screenshot, then I think it is doable with some work. I used 2 subreports and filtered by record number for simplicity...used

recno()>=round_up(reccount("products")/2,0) for the Left subreport

and

recno()<round_up(reccount("products")/2,0)

for the right.

Much more would be required to actually do this though--perhaps even creating another field with a row count (one way).

But should be able to just take the second half of the records, find the first recno() of that half and place all records >= to that on the left side...etc.

If the records are first filtered in some way then would have to take that into consideration as well.



EDIT: am not used to right to left thinking so the above should be

recno()>round_up(reccount("products")/2,0) for the Left subreport

and

recno()<=round_up(reccount("products")/2,0)

for the right.....but gets you the idea I think.

[lkatz1]

Re: Changing columns

We are not working with recno() but alepbatically

[MikeC]

Re: Changing columns

Hi David,

We are not working with recno() but alepbatically

And you couldn't have said this in your initial post?? Regardless, what progress have you made in the last 2 days on this report? Anything that even comes close?

Without having a sample from you with some dummy data showing what you have so far and what filters and such you may have,....and all the criteria you want/need in the report up front....and a picture, drawing, what-have-you that somewhat shows what you want to end up with...

I don't believe many people can help without most/all of the above...at least not without playing a guessing game for the next week or more. With all the functions at hand within Alpha there sure seems a way to do almost anything.

---what have you tried so far?? Can you sort prior to the report?? Does the data wanted in the report include ALL the data or has it been filtered first??? These are just the simplest of questions that need to be addressed by anyone wanting to help....and which a sample would answer very readily so long as explicit instructions are given.

Just a few thoughts I had....you noticed I did not address your problem at all---I really cannot without more information....and at this point I am not even sure if you are ready to be helped without you first helping us by giving all the necessary information...if in doubt on what to give when asking a question, simply give everything possible...especially taking the time to create a small sample.

[lkatz1]

Re: Changing columns

how do we upload a dbf ddm all files

[Stan Mathews]

Re: Changing columns

In the FAQ under What Are Attachments?

[lkatz1]

Re: Changing columns

here is the sample file

[MikeC]

Re: Changing columns

David,
Not a big deal but next time add your database files as well, the adb, alm, alb, alx files....that way a new database doesn't have to be created by someone--someone wanting to look at the sample just has to navigate to it and open.

Still waiting for info....be specific.

[lkatz1]

Re: Changing columns

we want the first name shall go downwards in right column then start printing the left column the same for all pages first list of names in right when finished the whole page shall start left column down

[lkatz1]

Re: Changing columns

Any suggestion

[MikeC]

Re: Changing columns

Hi David,

I have been round and round with your problem for bit and made some progress....enough that I think you can experiment around a bit.

Using what I stated in Post #4. I know the record number is not how you want it sorted.... :) But yes it is ! You simply duplicate your table, name it something else, and either zap or use overwrite as a choice in a Copy Operation. The way to do this is to first have the Genie create the Copy Operation and save it. The problem is you cannot choose the order with Action Script. So right click on the saved Operation, choose "view xbasic" and then use either of the choices that are presented--to use confirmations or not....I chose not to but a pesonal preference really. Then Copy the xbasic and say put it onto a button, or wherever really but for testing a button is well suited for now. Change the Order to equal your last name field.

Now base your report on this new table and use the info in Post 4 to get you going (you could use ceiling() instead of roundup() I believe). I think you should be able to get something along the lines you wanted this way.

I will post a small sample if necessary of what I did if necessary. If more records than will fit on a page then you can either know beforehand how many will fit or figure out how to limit them to so many per page.....

[lkatz1]

Re: Changing columns

Very Good
but in preview the following pages are blank 2-4-6-8-10 etc
how can we fix it?

[lkatz1]

Re: Changing columns

Also it's spliting the whole dbf that means when it finishes half of the name on right side it starts the left column ex: dfr file of 200 name the first 100 are continuasly in right column no matter how many pages the rest 100 in left we want that second page (shall be left column not contituation on page (2) 3 it shall be on left side