[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Move fields up or down

Posted on 2012-03-26
6
Medium Priority
?
500 Views
Last Modified: 2012-04-01
I have 4 textboxes which have a print name, address1, address2 and address3.  I have added another textbox making it 5 total fields.  I want to be able to move the fields down or up one depending on the address2 field is not filled initially. In the stored procedures I have coalesced the Address2 if there is no Address in the Address2 field I am inserting the City, State and Zip into that field. IF there is  an address in Address2 field then I move the cit, state and zip to Address3 field. How can I move the fields up one or down one?
0
Comment
Question by:pelon_80
  • 3
  • 2
6 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 37767931
you need to check the value in Address2 and based on the presence of data, you need to write two insert statments.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 37768433
Is this in the report or in the SQL?

mlmcc
0
 

Author Comment

by:pelon_80
ID: 37768535
it is a report
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
LVL 101

Expert Comment

by:mlmcc
ID: 37768754
If you put each field in its own section you can then suppress the blank sections and the fields will move up.

Right click the details section in the left margin
Click INSERT SECTION BELOW
Repeat 3 times

In DetailsA put the name
DetailsB - Address1
DetailsC - Address2
Details D - Address3
DetailsE - City, State, etc

mlmcc
0
 

Accepted Solution

by:
pelon_80 earned 0 total points
ID: 37772055
It okay what I did is create two formulas and according to Address 3 I put Name, Address and City, State and zip in the 2 formula and if there is a second Address field I put the Name, Address 1, Address 2 and City, State and Zip in the other formula 1
0
 

Author Closing Comment

by:pelon_80
ID: 37792650
It worked for me.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Tech giants such as Amazon and Google have sold Alexa and Echo to such an extent that they have become household names. And soon they are expected to be used by commoners in their homes, ordering takeout, picking out a song, answering trivia questio…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question