Search results for query: *

Sorry, I'm a newbie when it comes to sql. I'm getting an error "incorrect syntax near "set

Is it possible to have a case statement as such; Case When Field_1 = x then Field_2 = n END

I need to display a count of 1 hour time blocks available from a block of time minus the duration of transactions scheduled within the block of time. For example, a staff member has 2.5 hours blocked off (2:30pm to 5:00pm) as available time in the dbo.Schedule_Staff table. However, in the...

I'll give it a try! Thank you

I have a clients served report in CR 2008 that I run each quarter. I enter a start datetime and an end datetime. The counts are cumulative and are grouped by a fiscal year formula based on the months within the date range entered. I'd like to be able to enter the current fiscal year date range...

Thank you- I was able to get it to work!

Is it possible to have my crosstab only count the records that are not suppressed? I am displaying records that have a group count great than 1 and I'm suppressing those that are less than 1. My crosstab is counting all the records.

How can I write a comparison formula where the group avg font color is based on the variance between the report avg and the group avg?

Thank you Ian!

Hi Ian- Thanks for your help, Here is an example of the cross tab I'm working with. I don't want the totals to include the months from last year beyond the LASTFULLMONTH to get an accurate comparison of the fiscal years to date. Not sure how to apply your formulas..... Last Yr Count -...

I need to compare month last fiscal year to current month and fiscal year. I don't want to count the months for last year that are less than the Last full month for the current fiscal year. So I don't want a count for April, May, June of 2012. How can I modify this count formula? if...

There are 2 columns, FY12 and FY13 and the rows are months-- Is it possible to have the summary row only calculate for the MTD of the current FY?

I am comparing the past FY (July-June) to the current FY. How can I pull in only the matching months for the current fiscal year to date? I don't want to see any months beyond the current month for the past fy. MED MEDEVAL FY12 FY13 +/- Seen FY12 FY13 +/- Seen Jul 656 61% 1066...

I have added a column to my cross tab as a calculated member"% Seen". The calcuation formula is formula= sum(formula),group/distinctcount(field),group It's only pulling in the very first % for all the months. How do I get it to calculate for each month?

Sorry- As you can tell I have no experience with Java. We have a dashboard app that has the option of using java script expressions and I'm trying to do a count based on different field values. We have a field in the data source called "Proc_Code". I need to count if the Proc_Code = "EVAL" .

How would I write an expression to count if X = Y?

Having a connection to another data source with the full list of months work! Thank you

Thank you but I can't use the date field because for some months there is no data. I still need to display the month with 0 totals.

Is there a formula that can be used to group the months of a date range??

How would I count the clients that have a metcnt >0?? I have suppressed records.