source: http://saurav-nav.blogspot.tw/2013/12/nav-2013-r2-report-repeat-table-header.html
Even the table properties Boolean Repeat Header Rows on New Page doesn't help.
so let's see how we can repeat header in New Page.
* I will be doing it for NAV 2013 R2, and using Report Builder. The Steps Remain Same for NAV 2013 also.
For Demo Purpose i am using Report 6 - Trial Balance.
1. Open the Layout of Report in Report Builder.
2. In the Column Group Pane Select Advanced Mode, as shown below.
3. Once in advanced mode you will see static Rows for Each Header Line. (so if you have 4 header rows you will have 4 static rows)
4. For Each Header Row that you want to Repeat on New Page, select the corresponding Static Row and set these properties.
- set KeepWithGroup to AFTER
- set RepeatOnNewPage to TRUE.
Above image shows how i set the properties for 3'rd header row.
* When you click on a static Row, the corresponding row is selected in the table.
If you want to repeat all four lines in New Page, Repeat the steps for For all Header Rows.
Save the Report and Run in Role Tailored Client.
Below is the outputs.
Here comes the thoughts.
Tuesday, October 6, 2015
[NAV] Using Groups to Choose the Number of Rows per Page
source: http://www.wiseowl.co.uk/blog/s257/ssrs-rows-per-page-pt2.htm
Using Groups to Choose the Number of Rows per Page
The most accurate way to control the number of records on a page in a report is to combine grouping with a simple expression. This part of the blog series explains exactly how to make this technique work.
Step 1 - Create the Basic Report
For our example we'll create a simple report with a table containing a list of 263 films. Our aim is to make each page of the report display only 10 rows. The design of this report is shown in the diagram below:
This is the basic design of the report. For demonstration purposes we've added an expression to calculate the row number of each record in the table.
The expression that we've used in the Row column is shown in the diagram below:
The RowNumber function calculates the number of each row in the current table. We don't need to include it here but it helps to demonstrate the effect.
The results of running this report are as follows:
The report contains 6 pages. The first 5 pages contain 48 rows and the final page contains 23 rows, making a total of 263 records.
Step 2 - Add a Grouping Level
The next step is to add a grouping level to the table using the groups panel at the bottom of the screen:
Right-click on the (Details) row and choose Add Group > Parent Group...
On the dialog box that appears, click the button shown in the diagram below to launch the Expression Builder dialog box:
Click the fx button shown here to launch the Expression Builder.
In the next dialog box, enter the calculation shown below and click OK.
The number 10 in this expression ensures we see 10 rows per page, but you can change this value if you want to.
Click OK once more to apply the grouping level to the table.
Click OK again to apply the grouping to the table.
Step 3 - Remove the Automatic Sorting
If you try to preview the report at this stage you'll receive an error message similar to the one shown below:
The error message you'll see when you preview the report.
To prevent this error from happening we need to remove the automatic sort that has been applied to the group. Start by right-clicking on the group in the panel at the bottom of the screen:
Right-click on the group name and choose Group Properties...
Complete the dialog box which appears as shown below:
The numbered steps are described below.
- Click on the Sorting tab.
- Select the sort that you want to remove.
- Click on the Delete button to delete the sort level.
- Click OK.
You should now find that when you preview the report you can see all of the data in groups of 10 rows.
Each set of 10 rows has a different value in the Group1 column.
The next step is to put each group on a separate page.
Step 4 - Add a Page Break Between Each Group
To add a page break between each group, right-click on the group name in the panel at the bottom of the screen:
Right-click the group name and choose Group Properties...
Complete the dialog box which appears as shown below:
The numbered steps are described below.
- Select the Page Breaks tab.
- Check the box shown here.
- Click OK.
When you preview the report you should find that you have the specified number of records per page.
We get the exact number or records we require on each page, at the cost of having more pages in the report.
To tidy things up you could delete the first two columns in the example shown above - neither are required to make this technique work.
At this point you know everything you need to make this technique work for any number of records per page (up to the maximum that the page size can handle). If you're interested in how the expression we've used actually works you can read the next part of this blog series to find out!
Saturday, May 16, 2015
[Electrophysiology] Greg Gage: How to control someone else's arm with your brain
Here comes the thoughts:
This is quite awesome and yet scary. It just demonstrated how amazing human's brains are. 人類的大腦真的是很奧秘神奇!
我在想,要是volunteer不做出動作,而只是用"想"的,是否也可以控制另一個volunteer的手? 如果是這樣,那真的是有點可怕?
What'd happen if Sam just "thinks" about it? Would she be able to control Miguel's arm?
If so, that's really scary.
試想,未來你只要用"想"的,就可以控制另一個人去做,這樣我想現今的法律和道德界線可能更模糊了!
Thursday, May 7, 2015
10 good ways to 'Tell me about yourself'
Posted by Guest Contributor from TheLadders.
'If Hollywood made a movie about my life, it would be called...' and nine more memorable answers to this dreaded job interview question.
By Scott Ginsberg
You know it’s coming.
It’s the most feared question during any job interview: Do you think I would look good in a cowboy hat?
Just kidding. The real question is: Can you tell me about yourself?
Blecch. What a boring, vague, open-ended question. Who likes answering that?
I know. I’m with you. But unfortunately, hiring managers and recruiters ask the question. Even if you’re not interviewing and you’re out networking in the community — you need to be ready to hear it and answer it. At all times.
Now, before I share a list of 10 memorable answers, consider the two essential elements behind the answers:
1. The medium is the message. The interviewer cares less about your answer to this question and more about the confidence, enthusiasm and passion with which you answer it.
2. The speed of the response is the response. The biggest mistake you could make is pausing, stalling or fumbling at the onset of your answer, thus demonstrating a lack of self-awareness and self-esteem.
Next time you’re faced with the dreaded, “Tell me about yourself…” question, try these:
1. “I can summarize who I am in three words.” Grabs their attention immediately. Demonstrates your ability to be concise, creative and compelling.
2. “The quotation I live my life by is…” Proves that personal development is an essential part of your growth plan. Also shows your ability to motivate yourself.
3. “My personal philosophy is…” Companies hire athletes – not shortstops. This line indicates your position as a thinker, not just an employee.
4. “People who know me best say that I’m…” This response offers insight into your own level of self-awareness.
5. “Well, I googled myself this morning, and here’s what I found…” Tech-savvy, fun, cool people would say this. Unexpected and memorable.
6. “My passion is…” People don’t care what you do – people care who you are. And what you’re passionate about is who you are. Plus, passion unearths enthusiasm.
7. “When I was seven years old, I always wanted to be…” An answer like this shows that you’ve been preparing for this job your whole life, not just the night before.
8. “If Hollywood made a move about my life, it would be called…” Engaging, interesting and entertaining.
9. “Can I show you, instead of tell you?” Then, pull something out of your pocket that represents who you are. Who could resist this answer? Who could forget this answer?
10. “The compliment people give me most frequently is…” Almost like a testimonial, this response also indicates self-awareness and openness to feedback.
Keep in mind that these examples are just the opener. The secret is thinking how you will follow up each answer with relevant, interesting and concise explanations that make the already bored interviewer look up from his stale coffee and think, “Wow! That’s the best answer I’ve heard all day!”
Ultimately it’s about answering quickly, it’s about speaking creatively and it’s about breaking people’s patterns.
I understand your fear with such answers. Responses like these are risky, unexpected and unorthodox. And that’s exactly why they work.
Otherwise you become (yet another) non-entity in the gray mass of blah, blah, blah.
You’re hireable because of your answers. When people ask you to tell them about yourself, make them glad they asked.
'If Hollywood made a movie about my life, it would be called...' and nine more memorable answers to this dreaded job interview question.
By Scott Ginsberg
You know it’s coming.
It’s the most feared question during any job interview: Do you think I would look good in a cowboy hat?
Just kidding. The real question is: Can you tell me about yourself?
Blecch. What a boring, vague, open-ended question. Who likes answering that?
I know. I’m with you. But unfortunately, hiring managers and recruiters ask the question. Even if you’re not interviewing and you’re out networking in the community — you need to be ready to hear it and answer it. At all times.
Now, before I share a list of 10 memorable answers, consider the two essential elements behind the answers:
1. The medium is the message. The interviewer cares less about your answer to this question and more about the confidence, enthusiasm and passion with which you answer it.
2. The speed of the response is the response. The biggest mistake you could make is pausing, stalling or fumbling at the onset of your answer, thus demonstrating a lack of self-awareness and self-esteem.
Next time you’re faced with the dreaded, “Tell me about yourself…” question, try these:
1. “I can summarize who I am in three words.” Grabs their attention immediately. Demonstrates your ability to be concise, creative and compelling.
2. “The quotation I live my life by is…” Proves that personal development is an essential part of your growth plan. Also shows your ability to motivate yourself.
3. “My personal philosophy is…” Companies hire athletes – not shortstops. This line indicates your position as a thinker, not just an employee.
4. “People who know me best say that I’m…” This response offers insight into your own level of self-awareness.
5. “Well, I googled myself this morning, and here’s what I found…” Tech-savvy, fun, cool people would say this. Unexpected and memorable.
6. “My passion is…” People don’t care what you do – people care who you are. And what you’re passionate about is who you are. Plus, passion unearths enthusiasm.
7. “When I was seven years old, I always wanted to be…” An answer like this shows that you’ve been preparing for this job your whole life, not just the night before.
8. “If Hollywood made a move about my life, it would be called…” Engaging, interesting and entertaining.
9. “Can I show you, instead of tell you?” Then, pull something out of your pocket that represents who you are. Who could resist this answer? Who could forget this answer?
10. “The compliment people give me most frequently is…” Almost like a testimonial, this response also indicates self-awareness and openness to feedback.
Keep in mind that these examples are just the opener. The secret is thinking how you will follow up each answer with relevant, interesting and concise explanations that make the already bored interviewer look up from his stale coffee and think, “Wow! That’s the best answer I’ve heard all day!”
Ultimately it’s about answering quickly, it’s about speaking creatively and it’s about breaking people’s patterns.
I understand your fear with such answers. Responses like these are risky, unexpected and unorthodox. And that’s exactly why they work.
Otherwise you become (yet another) non-entity in the gray mass of blah, blah, blah.
You’re hireable because of your answers. When people ask you to tell them about yourself, make them glad they asked.
Sunday, March 8, 2015
Wednesday, March 4, 2015
Quotes from unknown
People come together and move apart. It's the age-old ebb and flow of relationship.
Often the thought of pain is actually worse than the pain itself. It's never as bad as you think it's going to be.
The behavior sometimes has to com before the feelings.
A person's character can be measured by how they act in a crisis.
Often the thought of pain is actually worse than the pain itself. It's never as bad as you think it's going to be.
The behavior sometimes has to com before the feelings.
A person's character can be measured by how they act in a crisis.
Saturday, February 28, 2015
[ENG] 英文俚語
Mistakes are stepping stones to success. - 失敗為成功之母
With every end comes a beginning. - 柳暗花明又一村
With every end comes a beginning. - 柳暗花明又一村
Subscribe to:
Posts (Atom)