Blank Line In My Database Result

[Phudsen]

Good day all,

I have created a Database Results from a table. At the final step of the database results I selected: List-One Field Per Item, then un-checked the check box which says Add labels for all field values.

All is working fine, I am getting the required information. But if one of the fields is blank I am getting a blank line, the Database Results does not look nice.

How to get rid of the blank lines if the field does not contain data.

Example: The table has ProjectId, ManagerName ProjectCost,Location,Position.
The database result is listing the fields as:
ProjectId
ManagerName
ProjectCost
Location
Position

If I have
A176,John Smith,180000,NY,Project Manager the DRW displays the data as:
A176
John Smith
180000
NY
Project Manager

That is Good, but If the cost is not there, the data is displayed as:
A176
John Smith

NY
Project Manager

The blank line does not look nice here.

Thank you for your assistance. I appreciate it

Paulin

 

[Laura2]

I had the same issue with blank lines showing up on my results if fields were blank. The only way I found to get away with it was to create a different table in the database for each field category and then have separate result regions on the form. I know that sounds like a lot of work but it definitely solves the problem.

Laura.

 

[Phudsen]

Hi Laura,

It looks like a good idea, but can you explain more.

How did you create a table for each field?
How did you make the DRW to show only the fields with data.

Thank you

Paulin

 

[Laura2]

Hi Paulin,

Your database should be saved in your fpdb folder. Open the database and manually create the tables. Once they are created, insert your database results on your page and choose the database you just modified as your connection name. It also has a spot for the table you want to pull your results from. Choose the table that holds your first field. Repeat these steps for each other table you've created.

Hope that helps.

Laura.

 

[Phudsen]

Thank you Laura,

I will try it and let you know.

Thanks
Paulin