Create a report that isn't all on one line
I need to create a report that pulls information from 3 tables and stacks the information on top of each other instead of everything on one line. Is this possible?
Forum Discussion
Hi Steve,
I have done something like this in the past using a formula rich text field and a little HTML or CSS. Essentially on the child record you would make a field that you could then set up to draw in and style text from various fields. This way on the table at the very bottom you can have all the fields but then you can draw them all into the formula rich text field to style and colorize the data to make it appear less like one long list and more like a block entry. I have done something in the past when I wanted a dashboard that had a little more visual interest. It just requires you to pick a consistent way you want to display the data and build out the formula.
I have done something like this in the past using a formula rich text field and a little HTML or CSS. Essentially on the child record you would make a field that you could then set up to draw in and style text from various fields. This way on the table at the very bottom you can have all the fields but then you can draw them all into the formula rich text field to style and colorize the data to make it appear less like one long list and more like a block entry. I have done something in the past when I wanted a dashboard that had a little more visual interest. It just requires you to pick a consistent way you want to display the data and build out the formula.
"<div style=\"text-decoration:underline;font-weight:bold;font-size:150%;font-family:Goudy Bookletter 1911;\">"&[First Name]& " " & [Last Name]&"</div>" & "<div style=\"font-style:italic;font-size:120%;\">"&[Job Name]&"-" & [Job Date] &"</div>" & "<br>" & "<div style=\"font-weight:bold;font-size:120%;\"> "What tools were used on this job?" & "</div>" & [Tools Used] &"<p>" & "<div style=\"font-weight:bold;font-size:120%;\">" & "How long did the job take?" & "</div>" & [Total Number of Hours] &"<p>" & "<div style=\"font-weight:bold;font-size:120%;\">" & "What other resources were used?" & "</div>" & [Resources Used?] That is just an example of a type of formula rich text field I have used with a little CSS for this in the past just to end up with a report that has some visual depth to it.