Hi, I'm looking on some basic "how to" to add a calculated field to a table. I know a bit of how to do this, but I did not find anything like this in the Wiki. I've got the Eureka version. I know that generally one creates a new field on the f...
Hi, I'm having difficulty in being able to rename 2 columns that appear in a database view. Here's a simple example. I created as shown below, which is merely a join of the incident and problem tables. I'm just using this simple example he...
Geoff/Mary,Not sure if anyone from SN is watching this thread, but I just wanted to echo Mary's comments. SN does do a good job in reporting duration fields using a dynamic format (i.e. reporting duration in minutes, when it is only minutes, and th...
Paul,Thanks for your reply. It makes sense. And, I agree, it defeats the purpose of being able to dotwalk to a field without having to add in another table into the DB view. But, I'm glad there is a way if we absolutely have to do it.Regards,Sc...
Hi Vibha and Kalai,Actually, I have a need to do the exact thing that Vibha asked for. And, that is relabeling a column (in a database view) that is a field that is referenced in another table. I've tried multiple ways to do that and can't find a...