Search results for query: *

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...

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...

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...

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...

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'm trying to calculate percentage complete between 2 dates in oracle. Shown below is how I did it in excel. A3 B3 C3 Pct 4/13/2010 6/3/2011 7/23/2010 24% =DATEDIF(A3,C3,"D")/DATEDIF(A3,B3,"D") Thanks, Sherry

I have a report with multiple groups headers for example: GH3 GH3a GH3b GH3c .... Is it possible to only repeat GH3b and not the others when the report flows to another page? Thanks, Sherry

Using 10g, I have a table of report names and user names. I need to count the total number of times each report was ran and the total number of unique users that ran each of those reports. I want to show the total report count and the total unique user count. Thanks, SZ

Using 10g. I'm trying to use BULK COLLECT INTO to create some variables to use in some calculations and some if..then..else statements. I don't know if I'm using it correctly or not. DECLARE TYPE employeeData_type IS TABLE OF temp_table%ROWTYPE INDEX BY PLS_INTEGER; employeeData...

Using Oracle 10g, I need to figure out starting from today's date, what phase will I be in in 6 months according to the schedule. Start End Phase 1 1/31/2009 Phase 2 2/28/2010 6/16/2010 Phase 3 6/16/2010 12/31/2010 Phase 4 12/31/2010 5/10/2012...

I'm using CR 8.5. I have a formula that displays the value without any decimals when table.rpt <> 4. When table.rpt equals 4 then I want to see the decimal places. The code below works, BUT I need to add the dollar sign in the first instance, but so far no luck. Both of these fields are...

Using CR 8.5 with oracle backend. I have a main report with a column called 'rpt' which will either be a 0 or 1. I have 2 subreports, subreport 1 will only print if rpt = 1, the other subreport 2 will only print if rpt = 0. When one prints the other is suppressed. I have suppressed other...