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...

Main report is grouped by account. Sub-report is in Group Header #1a of Main report. It is linked to the main rpt by year, period and account. I noticed that in sub-rpt there are some accounts that have Beginning balance, but those are not showing up in main report because those accounts...

Thanks, works perfect. Really appreciate your help!

here's 1 minor problem I am having with implementing shared variable 'BeginBalance' from sub-report into the main report. The main report and sub-report is linked by year, period and account. Problem Case) In sub-report some accounts may/may not have beginning balance for some...

Thanks. I am little confused with second line. What it does exactly? {@GetBeginningBalance} + Sum ({gl_balance.balance_amt}, {gl_balance.account})

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...

I think the reason Beginning Balance appears zero is: when I use the selection formula {table.year} = {?year} and {table.period} <= {?period} eg. for following, user enters period 1 of 2006. year period account balance_debit balance_credit balance_amount 2006 0 1000...

The above formula gives Beginning balance as 0, though I think it should have been correct. Another example below - if user selects period 1, the beginning balance can be calculated using Running total of account 1000 for both period 0 and 1, and by subtracting the period 0 balance_amount from...

The beginning balance is being determined by period. For eg, if user enters period 2, the beginning balance for period 2 is sum of balance of period0 and period1. If user enters period3, the beginning balance for period3 is sum of balance of period0, period 1 and period 2. The formula for...

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...

Thanks. I am seeing the result now but beginning balance amount from sub-rpt is not correctly tied to the gl_account in main report. I am not sure if this is correct site to ask, but here is the SQL that calculates the Beginning Balance. I don't know the logic behind the calculation. If anyone...

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...

How to pass variable from sub-rpt to main rpt? In the main report, when I use the shared variable 'getBeginBalance', main report shows 0 as beginning balance even though the shared variable 'setBeginBalance' shows the correct beginning balance amount in the sub-rpt. In the main rpt, the sub-rpt...