I have successfully created a SET and the appropriate links.

I'm trying to create a Statement of Account for a Balance Sheet account to inlclude the following:

1 - Opening Balance (I believe the best way to handle this is to sum all historic data for the account).  How do I create an expression that calculates an opening balance and that asks me "what date would you like the balance as of? when I run the report

2 - Activity during a period (need it to ask me what date range) - I have gotten this one to ask me the Parameters

3 - To list a subaccount name of a general ledger account (I have accomplished listing the full account name however I want the last name in the subaccount

4 - Add the verbiage on the report "This report is for the period from X to Y" where X and Y are from the date range in item 2 above

5 - Limit the report to only list balances from a subaccount of another account

Any help would be greatly appreciated and I love the product.

Thanks,

Guerin

I think you're talking about QReportBuilder here and not QODBC? Report expressions are handled by the calling program or application, such as QReportBuilder, Crystal Reports or MS Access Reporting. As far a the structure of each report within QODBC is concerned, this can be found using stored procedures. See: What do the new stored procedures SP_REPORTS and SP_PARAMETERS do? fro more.

I've been slowly building up the range of QuickBooks reports available in a range of reports found if you search for: "How do I run a"

Thank you - you are correct - I am attempting to create reports in QReport Builder and struggling a bit.   Is there either: 1) a forum similar to that of QODBC or 2) someone I can speak with to help?

Thanks

As at April 2, 2007 there isn't a QReportBuilder forum. Suggest you contact the sales office in your region directly for further assistance.

For QReportBuilder support see: QReportBuilder Priority Phone Support - Click to get Help Now!