Report studio Study Notes

[Value prompt]

1. Create a parameter. The user-selected value is received by this parameter.

 

2. Set filter conditions: [Department-Full name] =? Parameter 1? (Or set it in the query first. You can change the operator to in to select multiple options and select the UI as the check box group ). The prompt defines a filter expression containing parameters to filter specified data items using the values received by the parameters.

 

View in query 1:

 

3. Set Query Information: Set the display content of the drop-down list box, that is, the filter conditions and display conditions can be different. For example, you can use the project type code to filter, but the project type is actually displayed (skip this step if the filtering condition is the same as the display condition ).

4. Set the initial value: Give the query a default initial value, otherwise it will set the initial value in the form of a separate page. Set the "Default Value" option in the property to add an initial value. (Optional)

5. Add a prompt button: the type of the prompt button is "complete ". (Or set "auto submit" in the value prompt attribute pane ")

 

 

 

[Select search prompt] first determines a selection range based on a certain search rule, and then selects.

1. Create parameters.

2. Set filter conditions: [Department-Full name]In? Parameter 1? (Query is used for reports. 1. The prompt is query 2.

).

 

3. Add a prompt button: the type of the prompt button is "complete ".

 

 

 

Hide a column]

1. Create a value for the parameter receiving value prompt: Add a text item on the prompt page, write "show parent department", add value prompt, and accept parameter "parameter 1 ".

 

2. Add a Boolean variable to the value prompt. The value prompt parameter determines its true/false status.

Attribute --- static option --- create Boolean variable 1. The given condition is paramdisplayvalue ("parameter 1') = 'you', and the true and false use values and display values of Boolean variables are given.

 

3. Bind the specified column to the Boolean variable. The Boolean variable determines whether the column is displayed.

Select a specified column, and click "list columns" on the right of the attribute ":

 

Use "generate variable" to bind the specified column to the Boolean variable:

4. set the default value to "yes" in the value prompt property. You can add the "finish" prompt button (or set automatic submission in the value prompt property; you can bind multiple columns to the same Boolean variable to bind multiple columns at the same time ).

 

 

 

[Detail filter]

1. Select the column-Filter button (or, in the query, drag the filtered data item into the "Clear filter" and set it ).

 

 

 

[Text Box prompt] Only data rows in a specified range of income are retained in the report.

1. Add a prompt page (toolbar ).

2. Add two text box prompts to the prompt page and use them to receive the lower and upper limits of the number range respectively.

[Contract amount] >=? Parameter 1?

[Contract amount] <=? Parameter 2?

 

,

Specify to filter the summary data:

 

3. You can add the "finish" prompt button.

 

 

 

[Style variable]

1. Add a string variable: drag the left string variable to the variable box in the condition explorer.

2. Write a variable expression: In the displayed report expression window, enter a variable expression to specify the conditions for the variable.

 

3. string variable name: In the attribute pane, select "other --- name" to name the variable.

4. assign a value to a string variable: add several values that are consistent with the expression to the variable in the conditional expression.

 

5. Bind a specific data item to a string variable: select the data item to be set in the condition format.

 

6. Attribute pane condition large style variable item: After a value of the string variable is selected, the background color of the Resource Manager bar turns green. You can set the format for this value.

 

7. Running result:

 

 

 

 

[The value prompts to remove the dotted line and parameter name]

1. Add "HTML project" and set its name in "properties --- description.

 

(1) div1: <Div id = "test">

(2) div2:

1. <Script language = "JavaScript">
2. VaR test = Document. getelementbyid ("test"). getelementsbytagname ("select ");
3. Test [0]. Remove (1 );
4. Test [0]. Remove (0 );
5. Test [0]. removeattribute ("haslabel ");
6. </SCRIPT>

(3) div3: </div>

2. Running result:

 

 

Note: The value prompts to remove the dotted line and parameter name and cut and add "-------- please select ---------" Line

Div1: <Div id = "test">

Div2:

1. <Script language = "JavaScript">
2. VaR test = Document. getelementbyid ("test"). getelementsbytagname ("select ");
3. Test [0]. Remove (0 );
4. Test [0]. Options [0]. Text = "-------- select ---------"
5. Test [0]. removeattribute ("haslabel ");
6. </SCRIPT>

Div3: </div>

 

 

 

[Drill-through between reports] drill-through from a summary report to a detail report to View Details of interest.

1. Create a detailed report:

 

2. Add a connection parameter:

 

3. Create a summary report:

 

4. Create a trace definition connection to the detail report:

 

 

 

 

[Add image]

 

 

 

[Change object height and width]

 

 

 

[Layout calculation]

1. toolbox --- block --- layout calculation:

 

The value prompt has been added to this report to display the value received by the prompt. Before this computation, you can add the following text: "This is a qualified parent department :".

2. Input computation expression:

 

 

3. Running result:

 

 

 

 

[Activity Report]

1. File --- convert to Activity Report

2. Add data to the check box group, select a project, right-click, and click go to query, as shown in

 

3. Pull the major dimension tables of the contract into the data items and filter out "HZ" (generate query 1 ).

 

4. Go to the page manager and drag the contract code in query 1 to the Data check box group.

 

5. Add "tab controls" and modify the tab names respectively. You can add new tabs.

 

6. Add query 2 to each option page, and each option page references the same query.

 

 

 

 

 

7. Add connections to the Data check box group and Tab controls, and set the variable value and container selection.

 

 

 

8. Set the crosstab chart and the pie chart as the list, and select the behavior settings. The other settings are consistent with the list.

 

9. Running result:

 

The default values are ksz and zcb. The list is highlighted. When ksz or zcb is selected, the List data changes accordingly, that is, the List data is filtered. The cross table page is the same as the list page, the bar chart and pie chart are highlighted only when ksz and zcb are selected.

 

 

 

Download activity report: After the activity report is downloaded, you can view the report offline without viewing the Report on the system.

 

Report studio Study Notes