Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mberg
Starting Member
1 Post |
 Posted - 2009-04-07 : 12:57:13
|
| Hi all,I am tasked with creating custom reports from our help desk software database for metrics and the like. I have been asked to generate a report to show a count and data for when word orders get changed from one queue to another. The queue field is Tasks.Respons but in my database I don't see anywhere this data is actually captured. How do I go about this? A sql expression in Crystal? I have been doing some research but have very limited experience. Something on UPDATE perhaps? Any suggestions are welcome.Thank you! |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-04-07 : 13:29:30
|
| Hello;You didn't give us any info on what version of SQL you are running (2000,2005, or 2008?).You did not supply a database name but from your post it seems like your table of interest is called Tasks and the field (column) of interest is called Response.So at the very least you are looking for the Response column of the Tasks table in Database ABC.So run this query..use ABCselect col.name from sysobjects obj inner join syscolumns col on obj.id = col.id where obj.name = 'Tasks'This will list all of the columns from Table Tasks in Database ABC.From there you should be able to locate the Response column and view the data.Once you have a handle on where the data is and what you want to report on you can address what reporting mechanism to use (Crystal or SSRS). I personally prefer SSRS.r&r |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-04-07 : 13:31:29
|
| changes are typically tracked one of two ways. Either in a "transaction" like table where changes are actually new rows rather than updates. Or by using an Audit table. An audit table is usually populated by a trigger on the subject table and records all the changes as new rows. Sounds like you will need to go back for some clarification to whoever gave you this task.Once you have a specific question, use this topic to see how best to ask it:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxBe One with the OptimizerTG |
|
|
|
|
|
|
New to SQL - Crystal Reports