|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| how can I do??? |
| Author |
Message |
|
|
| Posted : 2007-12-06 04:31:21 |
|
I used sr_report to to access differents report, but I need to change the parameter "Date" in MS Query every time I access the reports. Is there a way to linking a parameter "Date" with a cell in Excel.
In the before posted : "How do i use prompted date range in MS Excel" explain when you used a SQL but not when you used a sr_report.
I am not talking about used parameter option like "Today" , is a litter different. I am talking about to use "[ ]", so into excel a can link the parameter to a cell. This way a can change the date in excel and only update the sr_report without open MS Query.
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-06 09:46:14 |
You can also extract data for any period like this:
For October, 2007:
sp_report TrialBalance show Debit_1_Title as Date, AccountNumber, AccountName, Debit_1 as Debit, Credit_1 as Credit
parameters DateFrom = {d'2007-10-01'}, DateTo= {d'2007-10-31'}, ReportBasis = 'Accrual'
I don't have an MS Excel example, but see: Running an sp_report in Access using VBA for more on using VBA to program date entry and execution using MS Access. |
|
|
|
|
|
| Posted : 2007-12-19 13:16:07 |
I currently do that. But I need to change the date tree or four time per week. This is the reason because a need to enter in MS Query every time and change the date.
I like to "LINK" the parameters DateFrom and DateTo with cell into Excel; e.g DateFrom=A1 as A1= 12/01/2007 and DateTo= A2 as A2= 12/10/2007. That way when I change the A2 value to 12/11/2007 and after update the query, Quickbook change the DateTo value to 12/11/2007. This way I dont need to enter in MS Query every time I need to change the date.
If not possible, how can I have the Balance Sheet Monthly and the Income Statement Monthly though SQL (without sp_report). This way I know how can I "Link" cells into Excel. The previos post "How do i use prompted date range in MS Excel" explain that.
Thank u and Advance.
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-12-19 14:13:14 |
There are a number of predefined DateMacro options available to you that you can use instead:
|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|
See: How do I run a Trial Balance Report? for more. |
|
|
|
|