Search results for query: *

I have to run a series of audit reports each month. For each month I count the number of audits(audit #) number of failed audits(yes/no ) and then do a calculation to find the failed percentage. Essentially 3 formulas. Right now I have a start time and end time that I have to replicate in all...

Hello Folks, I am trying to create a daily report that will capture inforamtion from a SQL database. The only problem I can;t seem to resolve is a formula to extract ony informations based on yesterdays date, sord of. The report will be ran once per day. It will be ran through Crytal Reports...

Hello, I have a command object created to extract the following fields: AreaAudited: (ex Slots, Table Games) Section: (ex BlackJack, Live Payments) GameAuditStartDateTime: (date time field) ReviewMethod: (Pass, Fail, Live) Number: (Audit number ex GA20120002122) Violation: ( I want to create...

Hello, I have a command object created to extract the following fields: AreaAudited: (ex Slots, Table Games) Section: (ex BlackJack, Live Payments) GameAuditStartDateTime: (date time field) ReviewMethod: (Pass, Fail, Live) Number: (Audit number ex GA20120002122) Violation: (incorrect payment)...

Hi THere, I am creating a manual crosstab and would like to count the number of records that occur between two sets of dates. I am using the following formula if month({gameauditstartdate}) in [1] then ({gameauditstartdate}) else 0 I would like to be able to select the more than just the...

Hello, I am creating a crosstab report that will show values based on month of the year. I want to use a formula in a column that will capture the inforamtion based on each month. I want to view the inforamtion by year(2005 - 2007) for each row. I thought of using this formula but I keep...

Hello, I am preparing a bank discrepancy report that will group the discrancy amounts into groups based on 10.00 dollar increments. It would start at 0 - 10.00 and work its was up to 90.00 - 100.00. I would like to project it over a calendar year and hoped to use a crosstab with the dates(by...