Search results for query: *

I have just received a Sagem F@st 1201 V2 ADSL2+ modem from Optus which I have connected to my computer via a USB cable and it works. This replaces a DLink DSL 302G modem. I had the DLInk modem connect to a DLINK wireless router DI 524 for the wirelss devices at home (TIVo, laptops etc.) and it...

My spreadsheet looks like this A B C D D ID # Sex Age Build Criteria 11111 F 17 Slim Brown Hair Black Eyes Wears Glasses 22222 M 23...

Hi, I am using Crystal Reports XI with an Oracle 8 database. I am trying tp draw a line graph of the report below. Each value is a calculated value. For each period I have a formula to calculate Sum((Tran_Cnt), Prod_line) (@SumPeriodxx) and have a Running Total that is a distinct count of...

My data is actually grouped on two fields with PClass being the lowest level. The output should look like this: PROD_CLASS Ave Age Jul Ave Age Aug Ave Age Sep ------------ ----------- ----------- ----------- Product One 34 37 40 Product Two...

I need to determine the Sum of groups of records and for each group use the Sum to determine the Average for the group. My data is grouped on PClass and is as follows : PClass Months No. (Month * No.) MONEY MARKET 184 1 184 MONEY MARKET 52 2 104...

I am trying to create a report with three columns. The first column indicates the total number of Transactions for each Type of Bank Account for a given period (acnt_type). Of this total no. of transactions, I need to display the number of ATM transactions, in the second column. The third column...

I am using CR10 with an Oracle database. I need to display a Bar Chart with a drill-down facility to four levels. When I drill-down on the chart the information is displayed as a report. Is there a way to display the drill-down information for each level as another bar-chart instead of a report...

I'm trying to produce a drill-down report with a bar chart using CR10 and an Oracle database. I am grouping at two levels. The first group is the Period and the next group is the Location. At the detail level I am displaying the amount. The report looks something like this: March 05...

Thanks for that, it works fine.

ACNT_HIST.PERIOD} is a Number field and contains values like 200503, 200502, 200502, 200412 etc. I need to only extract rows for the last twelve months. I need to get the maximum value of the period and then calculate the previous 12 months. If MAX(ACNT_HIST.PERIOD} ) returns 200503 then I need...

I need to retrieve the MAX(period) because I need to use this value to retrieve rows for the previous 12 months only and not all the rows. I thought by finding the MAX(Period), I would then be able to calculate the starting period from which to retrieve the rows. Once I get the MAX(Period) I...

Hi, I am using CR10 with an Oracle database. I am trying to retrieve rows based on the maximum value contained in a column as I only want some of the rows. This is what I am trying to do but I keep getting an error in the formula. Could someone please help. WhileReadingRecords; numberVar...

Hi, I keep getting an SQL Exception when the following query is executed but no rows are returned. Connection Conn =getConnection "jdbc:mysql://localhost/test?user=abc"); Statement stmt = Conn.createStatement(); rs = stmt.executeQuery(Some query); rs.next(); ErrMessage =...