Recent content by t16turbo

thanks for that. I used Convert on the second union to change EXTERNAL_ID to a varchar and it seems to have done the job.

just made a change to the first SELECT in the Union. (I had change it to test some ideas) here it is as it should be with the +' - '+ included Select ATEHistory.DepartCode, ATEHistory.TransDate, ATEHistory.Client+' - '+ ATEHistory.clntname, rtrim(ATEHistory.lastname)+'...

hi there, i'm trying to perform a union using the following SQL: Select ATEHistory.DepartCode, ATEHistory.TransDate, ATEHistory.Client+' - '+ ATEHistory.clntname, rtrim(ATEHistory.lastname)+', '+rtrim(ATEHistory.firstname),rtrim(ATEHistory.EmplyCode), ATEHistory.description...

Hi guys, I have several formula fields which return a text string given certain criteria. I use them do display exceptions on project fields. Then display these in one big text string using a formula as follows: whileprintingrecords; numbervar counter := 0; stringvar array x := [{@Version...

thanks guys, PH, your code is basically just the code generated by subtotals. my live data will have about 1100 rows - and if I try to manually create it using the concat column it takes ages to run. i'm wondering what I can do to improve the performance of it. in reality I have about 5 or 6...

hi there, I have the results of a qeury which I then need to subtotal based on two different columns. the data looks like this (simplified) project location actuals etc uk1234 UK 54 23 uk1234 UK 10 7 uk1234 Thai 10 15 uk1222 UK 26 5 I need...

Hi there, I have a text control in the 'before' section which includes 2 data parameters: "Date Range: " & param_start_period & " - " & param_finish_period how can I format these to dd-mmm-yyyy format?

hi there, is there a way I can perform a sum of distinct values in an expression? My sql behind the report returns one or more rows for a single time entry (as I am also returning timehseet notes) My report has grouping levels with the timesheet notes at the lowest levels I need to only sum...

also, the canned reports code is as follows: Sub SetLinkTo( row As AcDataRow ) If IsNull(NikuSequential::ActuateLocale) or NikuSequential::ActuateLocale = "" Then LinkTo = "" Else LinkTo = "/" & NikuSequential::ActuateLocale End If LinkTo = LinkTo & +...

hi, thanks for the suggestion. I used your code instead of mine, but it's still returning the same error. I just dont know what I am doing wrong (or right for that matter) is there somewhere else in the report hat needs altering? or the target report?

Hi, I am trying to use Hyperlinks in my report to fre up a second report when the Client Code is clicked on. I've used a report that comes with clarity as an example, and adapted the code in my report. Sub SetLinkTo( row As AcDataRow ) me.LinkTo = "/PRJ/Support1b.rox?Submit" & "...

hi there, I have some code in the text editor of my report: [code] SELECT NBI_PROJECT_CURRENT_FACTS.CUSTOMER, NBI_PROJECT_CURRENT_FACTS.CUSTOMER_CODE, ODF_CA_PROJECT.DSTI_TRUE_CLIENT3, SRM_COMPANIES.COMPANY_NAME, PROJCLASS.DESCRIPTION, dsti_proj_ref, dsti_proj_act...

thansk guys. that works. well, myold idea works, but I must say I DO like to keep things looking neat and easy to debug.

that makes sense!! right, here's my code: SELECT p.ID, P.NAME, SUM(a.PRACTSUM/3600) as actuals, Support.actuals as SupportTime, NonSupport.actuals as NonSupportTime FROM srm_projects p, prtask t, prassignment a, (SELECT p.ID, SUM(a.PRACTSUM/3600) as actuals FROM srm_projects p, prtask t...

its slightly more complicated than that. its spread out over a resource table (containing the OBS unit of the resource - which is how I will determine support staff or not), a task table joined to the project table, an assignment table, joined to the task table and the resource table. a simple...