Search results for query: *

Thank you, I'll take a look at it and keep it for future reference.

Thank you for the reply. A co-worker was able to free up some time and help me out with this. I am familiar with the CASE syntax just wasn't successful in making it work. But, this is what we came up with, we also added a little more information to the query. select s.ProjectID...

I'm not sure how to go about this. In my tbl_Project_Employee below I have 4 dummy records. I need a query that selects where the employee_type_id = 48 if it exists; otherwise I select where the employee_type_id = 22. I've shown below the table what my results should be. tbl_Project_Employee...

Thank you, but we actually changed the query so it is working fine now using listagg.

No, I don't. It's a report table where the data can change each time it's ran. That's why I thought of using rowid. Thanks, Sherry

I have a table called rpt_sp_category with the following columns: sponsor, dept_cd, subproject_id, fao_id, fund, agency, orgn, cnt_fund_groups, avail_appr, expenses, spending_plan My problem is the rpt_sp_category will have duplicate records where the cnt_fund_groups > 1, but I only want to...

Thank you for your help, greatly appreciated!

Is there a way to increment a number by date resetting on an id column. For example: Table1 ContID Visit Date 145 1 01/01/2016 145 2 01/25/2016 145 3 02/01/2016 150 1 02/15/2016 150...

Thanks, but I got it.

In this example, I have 3 contracts/projects. The first one has 3 funding sources (Agcy 2207, 2307 & 6207), the second one has only one funding source (Agcy 2207), the third has 2 funding sources (Agcy 2207, 2307). I only want the contract/projects with Agcy 2207 or 2307 (SPID 238.001 &...

I have one table with all available funding agencies. I also have a contracts table. I could have one contract with funding from multiple agencies such as 607, 207 or 307. What I need to find is which contracts are being funded ONLY by agency 207. How would I write this? Thanks, Sherry

Using CF8. I'm creating a report using cfdocument what will export as a PDF. I want the report to look like the following: Vendors Within the City comm_cd sub-heading vendor Name address loc_code vendor Name address loc_code comm_cd sub-heading vendor Name...

I'm using CF8. I have the following partial query - <cfquery dbtype="query" name="getVendor"> select distinct vendor, loc_code from variables.savedlist </cfquery> I'm using this query in a cfdocument pdf type report. I need to loop thru this query and look for where the...

I need to create mailing/address labels. There will be multiple addressees and most likely mutiple pages using Avery 5160. We are using coldfusion 9 as the front end and oracle as the backend. My thought is to use an avery 5160 template which I found on the web, insert text fields for the...

How can I display the text FY 2011 instead of the calculation as the column heading in a report? Thanks, Sherry

What would be the CF equivalent to the SQL 'IN' operator in coldfusion? <cfif #variables.location# IN "LO","AU","SL"> <cfelse> </cfelse> Thanks, SZ

How do I do this? Or can I? Trying to render a recordset using HTML from an oracle 11g database thru CF 8 using cfdocument. I've gotten it to where the groups repeat for each data row, but haven't figured out how to get non-repeating group headers. HEADING Group 1 Data row...

I'm a newbie with Microstrategy. This is something I've done with Crystal, but not sure how to accomplish this with Microstrategy. I will need this with probably every report I do. The situation is, a user selects a department and a fiscal year prompt i.e. 2012 for the FY. That number (2012)...

Using Oracle 10, Coldfusion, CR 8.5 on desktop and CR 11.5 on server. Keep getting this error when I press submit to run report, "A month number must be between 1 and 12". I've changed the parameters in the report to use DateSerial, but still doesn't work, keep getting the same error. Here is...

I forgot to mention that the dates being passed, startdate and enddate are being used as parameters on the crystal reports. Thanks, Sherry