Click Ok to save your changes and you’ll see that the Parameter Fields list is updated to reflect the new order. To change the parameter order, click on the parameter you wish to move and then click on the up and down arrows located in the top right corner. That is how they will appear when you refresh the report data.
Key Business Benefits:
Meet Chris Walker from HTRI – his company migrated from SQL to HANA in February 2017
Learn three different ways to migrate from SQL to HANA. With the high emphasis on SAP HANA as the platform of the future, how do these typical customers begin to strategically plan their migration into the HANA based platform of the future. Instead users will choose micro applications designed specifically for their primary day-to-day requirements, highly focused, able to work on any device, and consumed in a SAAS licensing model. Has anyone done it. How do these typical SAP Business One companies migrate into the future and move from SQL to HANA. More importantly the true promise of the cloud and all it will mean to business in the future, will only be realized fully by customers running real-time databases, like HANA. Understand that this is not a TACTICAL UPGRADE – rather this is a STRATEGIC DECISION. Is there more than one way to make this transition. The vast majority of SAP Business One Customers today run their ERP system on Microsoft SQL. Many industry analysts believe that within 3-5 years users will no longer work from desktops and laptops running large, full features application clients, whether they be old style fat clients (like most SAP Business One users run today) or even HTML web based application running in a browser. Additional Notes:
Most SQL Customers know about HANA and would like to have at least some of the deliverables and features in the HANA version. They just have no idea how to get there or what the costs might be. What are some immediate benefits. This change is essential in order to truly take advantage of the full collection of features SAP delivers in each new version of SAP Business One; some only available in the HANA version.
You now have two items in the list of values that the user can choose from. Since the report is only for managers in North America, we will manually create the list of values. Click on the second row and type in “USA”. Leave the description field alone because the country name is self-explanatory. In the Value list box, click on the first row and enter “Canada”.
When the user opens the report he or she is prompted with each question and the answers are used to carry it out. In their most basic form, report parameters are simply a means of asking the user questions about what they want printed. New parameter values can be entered each time the report is viewed. The biggest benefit is that you don’t need to save a separate copy of the report for each user. Some examples of typical questions are, “What sales district do you want to report on. ” and “What is the minimum sales amount you want to see. ” Questions such as these let the user take a report that was designed to be used by multiple people and only view the data that he or she is interested in. Figure 4-aa shows a parameter prompting the user for a report date and the print range.
Only the Values column gets populated. You have to type entries in the Description column manually. Even if you have a field specified for the Description column, nothing gets inserted. A word of caution when using a database to add individual items to the list of values: when adding individual items the Description column doesn’t get filled in for you. Hopefully, this problem will be corrected in a future maintenance release.
Furthermore, when our industry underwent a monumental collapse we knew we had to quickly adapt or we would disappear. As a reverse logistics company who buys retail and sells wholesale, we needed a versatile system that could handle our industry specific challenges. With the support of Consensus International we created a set of documents and reports customized to our very particular needs. This time creating tools to integrate SAP to online market places like Amazon, EBay, Walmart, etc. Join us in this session where we will share our experience of adapting to change under extreme pressure. It allowed us to process purchases from thousands of small suppliers, who were selling thousands of different SKUs in multiple conditions. Once again, we were able to adjust SAP to meet the needs of our new business model. Finding an ERP software solution for a company like Blue Trading wasn’t easy.
Yes, there are tools in SAP Business One to access this data, but what are the basic ways to use these tools in order to jump start your personal skill set. This course seeks to provide the foundation to grow from. A good refresher for longer term user and a must have for all new users of SAP Business One. Everything is there, but how does one find the data they need. This 90-minute training session will go through some of the query basics within SAP Business One, such as:
Obtaining the basics of creating Queries
Become aware of the complete Query tool set
Comprehend the power of Queries
Mentally connect queries and reporting options
Appreciate how SAP Business One leverages the use of Queries
See Queries in Action
Key Business Benefits:
Download the course contents and deliverables (All illustrations are Video recordings and may be re-played at any time)
See queries working in Crystal Reports and Microsoft Excel
50+ free Queries (All may be imported to your system) learn how
Learning to create your own Queries will not remove the need to obtain help from your consultant, but it will greatly reduce this need for many requests. SAP Business One, unlike many contemporary ERP systems provides users with the ability to query or ask questions of their database.
Versions of Crystal Reports and several versions of Sage 300 ERP, the number of will keep frequently polling their server to see if there are any updates. On my laptop Crystal would print quite slowly the first time and then would print. I too
faced the common error ‘server busy this action cannot be .
For example, if you are asking the user a Yes/No question then the data type is Boolean. Another example is a parameter used in the calculation of a sales commission. If you are asking the user to enter their User Id for security purposes, then the parameter is a String data type. It must be a Number data type. Although the user could type in the same numbers using a String data type, you wouldn’t be able to use it in any calculations. Determining the proper data type is usually not very difficult because the data type is defined by how the parameter is going to be used in the report.
The prompts are directly linked to the database and the list never goes out of date. Thus, although DCPs insure that the data is always up to date, there are times it isn’t the most efficient solution. This is called Dynamic Cascading Prompts (DCPs). New to Crystal Reports XI is the option to make a list dynamic. As soon as the data in the database changes, the report will recognize this and present the user with a list of values that reflects any changes. One problem with DCPs is that they incur more overhead because every time the report is run it has to query the database to get the latest list of values.
For example, if you entered a range of 1,000 and 1,999 then it would include all numbers from 1,000 up to and including 1,999. The range includes the values entered. The user enters two values that are the beginning and ending points of a range.
The cViewSERVER Crystal Reports scheduler automatically delivers reports to. The SMTP server is busy or unavailable, ensuring all reports are delivered.