Search results for query: *

environment: CR 8.5 When I close and open a report, currently it prompts for me to log into datasource. How can CR users avoid this login prompt when opening the CR report? I used ODBC connections in crystal dictionary to connect to multiple datasource. I thought once I make connection in...

environment: CR 8.5 How to subtract a year from a given date range? eg. date range is: 04/01/2006-03/31/2007 I'd like to get a date value prior to 04/01/2006 (subtract 1 yr from mimimum of range value) which would be 04/01/2005. Date is a parameter field ({?Pm-?Fiscal Year}) that accepts...

1) How to calculate GrandTotal of shared variable? Currently it's calculating wrong. Fields are grouped by 'account' field. In Group Header section formula @GetBeginningBalance= whileprintingrecords; shared numbervar BeginBalance; BeginBalance; In Detail Section (suppressed)...

Hi, I got parameter query that runs ok in Crystal SQL Designer. I am using this as datasource ('source.qry') in Crystal 8.5. I expected it to ask for parameters 'year', 'Start Period' and 'End Period' when the report was run. However, it doesn't ask for the parameters when report is run. How...

environment: Crystal 8.5 How to create parameterized query? Following SQL runs ok in Crystal SQL Designer. This query will be used a data source in crystal report. Fields 'gl_year' and 'gl_period' will need to be parameter fields. So, when user runs the report, it will ask for year and...

When I do groupby gl_acct, the following error shows up. Can anyone find out why? Thanks. You tried to execute a query that does not include the specified expression 'gl_acct' as part of an aggregate function. SELECT IFS_gl_balance.gl_acct, IFS_gl_master.gl_abbrev_desc, (SELECT...

Thanks much to you both. I really appreciate your time and help. I passed a shared numeric variable from sub-report called 'BeginningBalance' and placed it on the main report's account group header. The main report is grouped by account. (Finally this part is working) The report should...

Environment: Crystal 8.5 Main report has subreport. It is linked by Year, Period and GL account. Period is a numeric parameter field which accepts range values. In the sub-report Select expert, I want to modify the criteria for period to accept minimum value of Period passed from the main...

I have number parameter field 'period'. It accepts range values (0-13). I dropped this field in the report so whatever the range value user selects, report should display it. eg. if user selects start value: 0 and end value:1, report needs to display: 0 - 1. Currently it shows blank. If it is...

Using Crystal 8.5 There's 6 columns in a table: year, period, account,balance_debit, balance_credit, balance_amount(i.e. balance_debit - balance_credit). The account balances are by account, year and period. year period account balance_debit balance_credit balance_amount 2006 0 1000...

the following SQL calculates Beginning Balance. I am not sure what is the logic behind Beginning Balance calculation in the SQL. Can anyone explain the logic behind it? I want to calculate beginning balance in Crystal report using the two tables mentioned below. Thanks. SELECT...

Environment: CR 8.5 I want to calculate beginning balance of general ledger accounts from table 'gl_balance' in sub-report. The beginning balance is in period 0 for each fund (eg. 1000, 1001, 1002...). There are 13 periods (period 0, period1,period 2...). Each fund can have many general ledger...

In SQL server 2000, following error shows up when below SQL is run? How to fix it? I want to display a Debit column if gl_amount > 0 and Credit Column if gl_amount < 0. Thanks. Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near '>'. SELECT gl_detail.gl_year, gl_amount...

CR 8.5, SQL server 2005 tables using ODBC connection. I need to display General Ledger Balance sheet for two periods on two separate columns for comparison purpose. How can I achieve this? eg. SQL produces following results. How to display period3 in one column and period 12 in another in CR...