logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Forgot password?
    • en
    • ru
    • pt
    • es
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Generating reports in SAP NetWeaver with FastReport.Net – Part 1
  • How to make wedding invitations from Excel

    August 25, 2017

    Do you have a celebration on the occasion of the wedding? Do you need to

    read more
  • How to connect to VistaDB

    November 15, 2019

    The Vista database will fall into the type of embedded databases. These databases differ from

    read more
  • How to disable printing reports and other items from the menu when viewing the report FastReport.Net

    February 29, 2020

    The main report viewing tool FastReport.Net is Viewer. This viewer has a rich toolkit for

    read more
  • Create a new report with code VB.Net

    September 17, 2020

    Speaking of the .Net framework, we usually imagine the #C programming language. Simply because the

    read more
  • How to use QR-codes in FastReport.Net

    February 15, 2017

    Nowadays “QR-codes” are gaining their popularity. Unlike conventional barcodes, “QR-codes” allow you to encode more

    read more

Generating reports in SAP NetWeaver with FastReport.Net – Part 1

March 1, 2017

Part 1: Rapid report development  

Landscape:

  • SAP NW 7.31 or higher
  • Workstation with SAP GUI for Windows
  • Fast Report.Net components installed on SAP NW (demo version can be requested via follow link https://www.fast-report.com/en/product/fast-report-net-sap/).

 

Task:

Build report for the current stock of materials. EPM Demo data model is data source for report.

Final report example:

 

1

 

Prepare Data source.

We need to use SAP Query for report data source to be able to create new report.

Run transaction SQ02 and switch namespace to local (we will use local namespace as it will not require transport requests  and you even can build queries directly in production system)

 

2

 

Create new Infoset ZZDEMO_STOCK and choose table SNWD_STOCK as basis table.

 

3

 

Add tables and join them as shown on the screen

 

4

 

Press on “Infoset” button. On overview screen add (drag and drop) data fields to new result field group.

 

5

 

Save and generate infoset.

Run transaction SQ03 and create new user group “ZZDEMO_FR Reports “. Assign infoset ZZDEMO_STOCK to user group.

 

6

 

Save user group.

 

Preparing template

 

Now let’s move to Fast report! Run transaction ZFR_COCKPIT. On the left panel select node Local->Reports-ZZDEMO_STOCK and then press button “Call query” to run Infoset Query.  

7

 

Mark fields relevant for selection screen and report data source. Save query with name “Stock01- Stock overview”.

8

 

After save and return new query will appear in the tree. Now press on it and on the right top panel press “add report”.  On the bottom screen maintain report parameters, set running type as “Run on frontend” and save data.

 

9

 

After report parameters have been saved – press edit button and then “Designer”.  Selection screen with report parameters will appear. Execute report.  As result - Fast report designer will be opened.

 

10

Adjust report options:

  • Menu: Report->Options->General->Double pass.
  • Menu: File->Page setup->Columns->Count->2.
 

11

 

Let’s configure bands

  • Menu: Report->Configure bands.
    • Configure (add\remove) bands as presented on the screenshot

12

Press on “Close” button.

    • Double click on 1st level group header band and put “[MYDATASET.CATEGORY]” as group condition.
    • Double click on 2d level group header band and put “[MYDATASET.PRODUCT_ID]” as group condition.
    • Double press on Data band and choose “MYDATASET” as data source13.

 

Place report elements

  • Choose “text element” from element toolbar and place it on Report title band. Double click on it and put follow text in it “Stock on [Date]”.
 

14

  • From “Data” view drag “Category” to the first level group header band. From “Data” view drag “Product_id”, “TEXT” to the second level group band.  
  • From “Data” view drag “ORG_UNIT_NAME”, “BIN_NUMBER”, “QUANTITY” to the “DATA” band.  Double press on “QUANTITY” element and add “[MYDATASET.QUANTITY_UNIT]” to it.
  • On the report footer place “text element” from element toolbar put follow text in it “Page [Page] of [TotalPages]”.


User and Developer manual for designer can be found here: https://www.fast-report.com/en/product/fast-report-net/documentation/

 

Final template should look so:

 

15

 

Press preview button and view results (in designer mode source data restricted up to 100 rows).

 

16

 

Save report (press SAP standard button) and leave designer.

Now press “Run report” to run report and see results.

 

17 

 

Sometimes preview may be opened in backgroud, use Alt+Tab to switch between windows.

 

RUN

To use this report as standalone (without ZFR_COCKPIT)  we need to create separate transaction for it.

Run transaction SE93, enter any transaction code you want (for example ZZDEMO_STOCK), put short text and choose “Transaction with parameters” as start object.

On the next screen put “ZFR_RUN” as transaction code, check “skip initial screen” and in “Default values” add field “p_rep” and value <your report ID>.

18

 

Save data.

 

Now you can run report directly by calling transaction ZZDEMO_STOCK.

 

about product download buy
Mikhail Drazdou
.NET FastReport SAP

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Our team
  • Contact us

© 1998-2021 by Fast Reports Inc.

  • Privacy Policy