Crystal Reports Syntax for datediff and date range problems.Crystal noob here, taken on more than I can chew.We had a previous admin that put together a rather complicated report pulling data from sql, inserting into excel and using a bunch of formulas to create subreports.The first criteria of the data is a list of all open tickets, their ticket number, the open date and the assigned user.That part is simple.The second criteria for data is a list of closed tickets for the last 3.NullIf and Coalesce can be used to more easily deal with blanks and nulls in sql fields.Excel Data Queries Use MS Query to Treat Excel as a Relational Data Source Excel ranges can work like relational tables.You can join them by common fields.I have a Crystal Report and in it is a sub report.The main rpt has an Excel file named Sheet1 in Crystal Rpt even though on my desktop the name of the XLS file is.The criteria of the report are the following 1.For each ticket number show the number of days open.I tried acheiving this by usind Date.Diff in the Section Expert and inserting a new Detail, then using the x 2 next to Supress and the following formuala attempts Attempt 1 Date.GIF' alt='Crystal Report Edit Sql Query In Excel' title='Crystal Report Edit Sql Query In Excel' />Diff d, opendate, closeDateAttempt 2 Local Date.Time.Var d.Local Date.Time.Var d.Date.Diff d, d. Both formulas tell me that a boolean is expected not sure what to doCould this be an issue of date format Is using the x 2 the correct way to enter calculated results into my reportCreate a subreport showing the department which the ticket was generated from this is in another table.I linked the two tables with the appropirate field without problem.For each department, show the assigned user then the amount of tickets still open within a certain range of days.Toshiba Treiber Download Externe Festplatte Wiederherstellen on this page.Like above, trying to get a date range formula to work is just not happening for me.The part where I am really stuck is with the Crystal syntax.I just keep getting formula errors.As and FYI here are the SQL queries that captured the data Query 1 SELECT refnum, DATEADDsecond, callreq.AS opendate, SELECT userid.FROM cacontact.WHERE contactuuid callreq.AS assignee.Alvin E Os Esquilos 3 Download Avi Legendado Faroeste '>Alvin E Os Esquilos 3 Download Avi Legendado Faroeste . Tattoo Flash I 2009 Pc Iso File . FROM callreq.WHERE status OP AND assignee lt NULLORDER BY assignee DESC Query 2 SELECT c.FROM cacontact a inner join callreq b on a.OP AND b.ORDER BY c.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |