Search results for query: *

Hello All, I'm trying to create a formula that returns records for the previous year up to the previous Saturday. I have two date formulas: StartDate: CurrentDate - 366 EndDate: {table1.DateField} - (dayofweek({table1.DateField},crSaturday)-1) In my record selection formula I have this...

Hello All, I’m having trouble with an Append query. Specifically in the WHERE clause. Every week I need to append records to Table01 from Table02. Table02 is a linked table from another DB that contains records of employee donations. Table01 tracks the donations in my Access DB. To eliminate...

Hello All, I’ve been hacking away at a stored procedure for a while with no success. Time to ask the experts. I have a form that uses this query to pull two values from a string. User chooses one value. SELECT DISTINCT Field = CASE WHEN SUBSTRING(Field, 1, 2) IN ('A1'...

Hello All, I've uploaded several reports to my BOE (11.5) via the CMC. No problem there. The reports were developed to use either a TEST or PROD database (SQL Server 2005). Most of the reports use dynamic parameters. However, when I click on the parameter value link to select new parameters...

Hello All, I’m struggling to find a way to pass data from one page to another. The code to my input form is below. This works fine. <script type="text/javascript"> function GoToForm2() { parent.location = 'Form2.asp' } </script> <Form action="Form1.asp" method="get"> <p>...

Hello All, It seems simple enough but I can’t seem to get the syntax to work. This is what I’m trying to do: I have a form with a text field in which a user can either leave blank or enter a number. This will be used in a query criteria. If left blank return all records. If populated, then...

Hello All, I’m not that familiar with ASP (more on the database side) and have been given a task that I’ve been struggling with. It seemed simple enough at the beginning but I just can’t seem to get it to work. I have a Listbox that pulls First_Name, Last_Name from a table. No problem there...

Hello All, I'm very new to JavaScript and have run into a problem. I have a form that has a couple of radio buttons, which make some sections of the form visible or invisible depending on the value of the radio buttons. The problem is I don’t need to validate fields if they are hidden, but...

Hello All, I’m having difficulty with an If-Then-Else statement. I can get the correct value for some records but not all. My report is fairly simple. The report returns records for every day of a user defined date parameter. The formula I’m trying to write needs to determine weather or not...

Hello All, I don’t think this is possible (though it would REALLY make my life better if it is). Is there a way to create a group from a date range parameter? I need to create a group that displays each day starting on a {?StartDate} date parameter and ending on a {?EndDate}date parameter...

Hello All, I've tried to figure this out (it may not be possible) but waht I need to do is count consecutive dates and then group by that. For example, User ID Name Location #of Days Start Date End Date 1234 WAYNE GREEN NY 3 2/15/08...

Hello All, I need to create two groups: 1. A group by Type 2. A group that lists each person and total the number of days they stayed at a particular hotel. Data Sample Below: Any/all help suggestions would be greatly appreciated! -tl

Hello All, Disclaimer: I am a complete novice in asp.net That said, what I would like to do is have users choose a value in a drop-down box on an .aspx (2.0) page and have that selection take them to another page. This seems simple enough, but I’m having the most difficult time figuring it...

Hello All, I have one user on a Mac. Does anyone know of a report viewer for the Macintosh (OS X)? It seems they are all for the PC only. I'm using 'Crystal Corral' for the PC users but can't seem to find one for the Mac. Is a browser-based app the only solution? Many thanks, - tm

Hello All, I need a query that selects a dataset (this will be used as a subquery) which only pulls records if one of the fields sums to 100. Employees work on several projects. Each allots a percentage of their time accordingly - adding up to 100% of their time. I need to pull only those...

Hello All, I’ve not used SQL in quite some time and am having a little trouble remembering how to do this (if I even knew in the first place). What I need is the column records in query #1 where the DISTINCT criteria in query #2 is true. I’ve tried a UNION, WHERE IN or EXISTS queries but...

Hello All, I’m trying to work out a way that I can count certain records twice. What I’m trying to do in the formula below is this: If {table.created_date} in {@StartDate} to {@EndDate} Then "New" Else If {table.completed_date} IN YearToDate Then "Completed YTD" I have a weekly report...

Hello All, I’m having trouble writing a WHERE statement that returns the records I want. What I need is a rolling 12 months. That is, if I ran the query today I want returned records where the value of the date field is 02/01/2006 – 01/31/2007. In my WHERE clause I have...

Hello All, I have a report based on a stored procedure that returns records of tasks that were completed the previous week. It’s run on Mondays and returns those tasks where the ‘completed_dt’ field has a date in the previous week. WHERE completed_dt BETWEEN DATEADD("dd",-7, GETDATE()) AND...

Hello All, I have an Access table – tbl_BgtYrHrs – that has three fields and values like: client_name budget_yr total_hrs AcmeCo 2006 500 GenCo 2006 200 DataCom 2006 300 AcmeCo 2007 600 I have a report where users can choose a budget year as a parameter value. I want to use...