Hello List – summer intern needing help. Using BO 4.1, I’m developing a crosstab with 13 dynamic date “buckets” in the horizontal of the crosstab. I have the user input the start date and I’m attempting to develop the “buckets” using the following pattern (input date(id) + # of days): id, id+7, id+14, id+21, id+28,id+56, id+84, id+112, id+140, id+168, id+196, id+224, id +999. I realize how to do this for generating every seven days then filtering out the needed dates EVERY time you run the query, but that is not my goal. How can this be done with DYNAMIC date changing? My second question is how can I capture the input date only for use as a variable? Any assistance would be appreciated.
Craig Stark
GE ED&C,IM
Craig Stark
g GE Electrical Distribution & Control
A answer to the how can I use a variable just for input to a report and not affect the query is use @Variable(‘Var’) = @Variable(‘Var’).
Then refer to the variable as – =
UserResponse(DataProvider(), “Var”).
You can also write a small script like:
Sub Main
Application.Variables.Item(“Var”) = InputBox(“Enter Var:”) End Sub
Then refer to the variable as – = ApplicationValue(“Var”), in your report.
Robert
Schmidt Interactive Software, Inc.
We now post document examples!!
Hello List – summer intern needing help. Using BO 4.1, I’m developing a crosstab with 13 dynamic date “buckets” in the horizontal of the crosstab. I have the user input the start date and I’m attempting to develop the “buckets” using the following pattern (input date(id) + # of days): id, id+7, id+14, id+21, id+28,id+56, id+84, id+112, id+140, id+168, id+196, id+224, id +999. I realize how to do this for generating every seven days then filtering out the needed dates EVERY time you run the query, but that is not my goal. How can this be done with DYNAMIC date changing? My second question is how can I capture the input date only for use as a variable?
Any
assistance would be appreciated.