Sitemap

Amicuk Programming Answers

Create a Bex report based on the client requirement

2015-10-11   Views:0

Advertisement

Hi Experts We are using 3.5 version SAP BW. Our Client requirement is to create a report. as below CC01 Qty Ltr Ripple xxxxx.xx CC01 Qty Ltr Ripple xxxxx.xx CC01 Qty Ltr Ripple xxxxx.xx CC01 Profit Value Ripple xxxxx.xx CC01 Profit Value Ripple xxxxx

Hi Experts
We are using 3.5 version SAP BW.
Our Client requirement is to create a report. as below
CC01 Qty Ltr Ripple xxxxx.xx
CC01 Qty Ltr Ripple xxxxx.xx
CC01 Qty Ltr Ripple xxxxx.xx
CC01 Profit Value Ripple xxxxx.xx
CC01 Profit Value Ripple xxxxx.xx
CC01 Profit Value Ripple] xxxxx.xx
Where CC01 is Company Code
QTY Ltr is the formula value that i have created for them
Profit value also is the formula that i have created
Ripple is the value that they want it to be seen in the reprot as a standard which is not available anywere in the multiprovider
xxxxx.xx are the total values of Qty LTr and Profit values per month (eg: 01.2011)
I have created the reprot and able to get the values but i do not get the CC01 for every line, and even Qty Ltr or the Profit Value in every line of the report , And i do not know how to hard code the Ripple.
Please adivice hope i am clear.
My repot displays this way. may be based on the company code.
CC01 Qty Ltr Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
Profit Value Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
CC23 Qty Ltr Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
Profit Value Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
CC09 Qty Ltr Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
Profit Value Ripple xxxxx.xx
xxxxx.xx
xxxxx.xx
Thanks Regds
Sri

The replay answer
Advertisement
With the code, you've presumably logged on to the database. To insert objects on to a new report you'd want to use code along the following lines:
private void AddTableFromDataSet(ref CrystalDecisions.CrystalReports.Engine.ReportDocument rpt, System.Data.DataSet ds)
ISCDReportClientDocument rasReport = rpt.ReportClientDocument;
// Convert the DataSet to an ISCRDataset object (something the ISCDReportClientDocument can understand)
CrystalDecisions.ReportAppServer.DataDefModel.ISCRDataSet rasDS;
rasDS = CrystalDecisions.ReportAppServer.DataSetConversion.DataSetConverter.Convert(ds);
// Add the dataset as a data source to the report
rasReport.DatabaseController.AddDataSource((object)rasDS);
// Add a field to the report canvas
// Note: This is quick and dirty. No positioning, resizing, formatting, etc.
CrystalDecisions.ReportAppServer.Controllers.ISCRResultFieldController rfc;
CrystalDecisions.ReportAppServer.DataDefModel.ISCRTable crTable;
CrystalDecisions.ReportAppServer.DataDefModel.ISCRField crField;
rfc = rasReport.DataDefController.ResultFieldController;
crTable = rasReport.Database.Tables[0];
crField = crTable.DataFields[2]; // Hardcoded field "Customer Name" in the Customer table from Xtreme Sample Database
rfc.Add(-1, crField);
// Save the report template to disk (without data)
//object path = @"c:\documents and settings\administrator\desktop\";
//rasReport.SaveAs("test.rpt", ref path, 0);
//MessageBox.Show("Done!");
For more info, see sample apps on the following link:
http://wiki.sdn.sap.com/wiki/x/IgBmBQ
Also, consult your 'Report Application Server .NET SDK Developer Guide" and  "Report Application Server .NET API Guide". I'd provide the appropriate links, but you do not mention the version of CR you are using...
Thread moved to the '.NET - SAP Crystal Reports" forum.
Ludek
Follow us on Twitter http://twitter.com/SAPCRNetSup
Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

Go to See the other 7 answers

Create a Bex report based on the client requirement

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts We are using 3.5 version SAP BW. Our Client requirement is to create a report. as below CC01 Qty Ltr Ripple xxxxx.xx CC01 Qty Ltr Ripple xxxxx.xx CC01 Qty Ltr Ripple xxxxx.xx CC01 Profit Value Ripple xxxxx.xx CC01 Profit Value Ripple xxxxx[More]

Unable to Create a QBE report based on View

Category:DefaultRelease time:-0001-11-30Views:130

I have a view which is based on 4 tables. The view by itself works fine.When I create a QBE report based on that view it gives the ORA-01445: cannot select ROWID from a join view without a key-preserved table (WWV-11230). I am not able to understand[More]

Creating a performance report based upon a custom group

Category:DefaultRelease time:2015-10-11Views:130

I am trying to create a simple performance report based on a SCOM group that I created, however when I run the report the relevant data cannot be found.  When I look at the group membership I see a list of Windows servers.  I then go into a generic p[More]

WIS 10901 error when creating a webi report based on OLAP unv (SSAS 2005)

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm using two VM. Machine A is running SSAS 2005. I'm able to create SSAS cube. Everything is ok Machine B is runing BO XIR3.1. I'm able to create webi report on relational DB without any problem or opening samples. Both VM machines are on the sa[More]

Open orders display in BEX report based on Key date

Category:DefaultRelease time:2015-10-11Views:130

Hello All, I have a requirement: We have an existing report which needs to have input selection as Key Date. The report should display the Open orders based on the key date mentioned. For Eg: if an item A was Opened on 20th Sept, 2010 and now CLEARED[More]

How to create dynamic Invoice report based on Tax calculations

Category:DefaultRelease time:2015-10-11Views:130

Hi Ppl, I have an invoice report requirement. There are multiple line items in invoice and each line item will have a tax % and discount associated with it. Discount has to be applied at line item level. Tax will be applicable on resultant amount whi[More]

How to create a crystal report based on SAP R3 Tables????????????

Category:DefaultRelease time:2015-10-11Views:130

Dear All!!!!!!!!!!! I am new to SAP BO crystal reports. I want to extract the data from SAP R3 tables and design the crytal report. When i tried to make a new connection; We have lot of connection as OLAP;OLE DB and etc, I am not sure how to establis[More]

How to create a report based on a DataSet programatically

Category:DefaultRelease time:2015-10-11Views:130

I'm working on a CR 2008 Add-in. Usage of this add-in is: Let the user choose from a list of predefined datasets, and create a totally empty report with this dataset attached to is. So the user can create a report based on this dataset. I have a data[More]

WebI report based on BEx query in Live Office document

Category:DefaultRelease time:2015-10-11Views:130

Hi We have a BEx query in BW that has one input ready variable (period). Then we have created a WebI report based on this BEx query (the WebI report itself does not have any prompts). When we run the WebI report we get asked to enter a value in the B[More]

Determine the Struture columns Based on User Entry in Bex Report

Category:DefaultRelease time:-0001-11-30Views:130

Hello Experts, I have requirement as below. Requirement: Create a Bex report to Display Credits and Sales based on Fiscal Period in Rows and Profit centers in Columns ( PC1, PC2, PC3....PCN where N is Number of Profit centers a user entered in Select[More]

Creating report based on master data

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys, I want to create a specific report based on master data in BI cube. for example... a report which takes cost center and period as variable and display expenses for that period and cost center. This report I want to create for all cost center[More]

Hot
Hi, I've got 4,389 photos in my iphoto library on my new imac. Most of them are personal but a few maybe 500 are from my work. I need to get the personal photos safely out of this iphoto library permanently and onto my old (now personal) computer. Ho [More]
DEAR:      I am a fresh man to apple's product. Now, i got ipad air & ipad mini & mbp. but each of the three devices has different apple id...      at the beginning, I didn't realize it is a problem until i use icloud and app purchase.      i trie [More]
Hi I am trying to use count function in EQL query for Metric Bar to show the number of occurrences of a record. When the record type doesn't exist i expect the function to return count as 0. Instead the function throws a runtime exception and the who [More]
In addition to the form fields and the submit button I want to add a simple web link to the form (preferably without creating a button). I can't figure out how. I've tried to add a html UI control, but there is no option for adding links in the html [More]
I have Win 7 Home Premium 64-bit and Outlook 2010. Everything was working fine, until a few months ago when the PDF Preview Handler stopped working. I got the typical message that others were having with the issue with Adobe Reader 9. I have Adobe Ac [More]
Hi Experts, For a standard webdynpro object I have created a new z component configuration by copying from existing one. In the standard there are already 2 existing component configuration. This webdynpro does not have any application created so I a [More]
i partation the harddisk in macbook pro  but the partation is not showing on desktop . how i show the partation on desktop??Click on the Desktop anywhere, then select preferences from the Finder's Finder menu. Click on the General icon in the toolbar [More]
Hi guys, I had to restore my iPhone 4S yesterday, whilst everything seemed fine at first I noticed that in the photos app it shows 9 pictures with the message "Downloading 9 of 63" yet nothing happens, I cant take photos or screenshots as when I [More]
Hi Experts, We are trying to send a FAX using RFC using third party vendor RIGHT FAX to 10 different FAX numbers. We need to send a letter with some fix texts & few variable values . How will the letter be formated and how will it go to different end [More]
Has anyone used the Extract Odd/Even Pages action for PDFs? I'm trying to use it to extract pages from a PDF and save as separate files. When I use it the action spins for a moment, says it succeeded, but I don't get any new files.I know of the java [More]