Search results for query: *

Is there a way to print a report's selection critiera, derived fields, report vairables and the names of all the tables that are used along with each field. With out maybe copying the SQL statement to a notepad doc and editing out what you don't need?

Pbowen, here is an example of a simple decode statement using the oracle version or reportsmith: DECODE("PS_JOB"."EMPL_TYPE",'S','Salary','H’,'Hourly') The Xlattable table that holds all the description, doesn't have a value to translate Empl_Type. Therefore IF you want...

To go along with Charles suggestion. Depending on how many line numbers there are. you might want to make a seperate report that list these. That way they will know which ones they are selecting. I find this helpful when I have a LARGE list of values, and I can't remember what all the values...

Well all it took was for ADp to loadit on THE server. and that was about it.

Are you tracking total wages over multiple weeks? If so you can use this derieved field to sum the wages over and then only have one row of data for the emp. SUM("PS_AL_CHK_DATA"."CK_GROSS") that should get you what you want

I have tried to use the CHART function in reportsmith, but i get the error message that i need to open Word and install the Chart 97 feature. Well this would work just fine IF i wasn't in a hosted enviroment. My database os located on the severs at a ADP location. because of some liscening...