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
The database is Oracle.  Recently I requested our DBA to do a database refresh, and here was she did. 1. Drop the user (TDEV, schema owner) in Dev. 2. Recreate the user, TDEV, with the same password, roles and tablespaces. 3. Using Oracle export comm [More]
< MODERATOR:  Message locked.  Please read the [Rules of Engagement|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] before posting next time. > Hi Can any one send me the Schedule Manager config settings. Reregards cheersH [More]
Hi all, We are having a problem when creating and changing a sales order in CRM. When a sales order is created and rapidly changed (or changed more than one time) from CRM, backend is receiving 2 events (from BO BUS2032, CREATED and CHANGED) but at t [More]
Hi, I was given a task to do some housekeeping of users directory Basically, the structure is of below. /User DIR ---UserA ---UserB ---UserC ---UserD ---UserE Each user contain several type of files. I wan to do a housekeep of the directories to remo [More]
I am able to use the Kaltura player quite well if on my menu page, which allows for navigation to the video-playing page, I use rel="external", but I give up all Ajax navigation buttons. If I don't use rel="external" the poster frame d [More]
Dear all, I work with five projects having interrelationships. 1.I had the reflection of a project 2.Reflection project was exported and sent to contractor as xer file. 3.xer file sent by contractor was imported into the reflection project and it was [More]
How do I transfer a PDF file from my iMac to my iPhone 3Gs? I've uploaded this PDF doc to my website but dont see how to download it and store it locally on my iPhone anywhere in the Safari running on my iPhone. Also, I've downloaded the app iPDF but [More]
our user wants cancelltion document(S1) should be posted to the old date i.e when it is invoiced (f2)posting date that means both should be same date. it should happen with out any manual changing of dates. Can any one help me please ,ponts will be r [More]
Flash 10.2 fixed the problem of video tearing of Flash applications under Linux with the move to use OpenGL for displaying.  Does Air 2.6 (or will a future version) support the same OpenGL layer and/or is there a config file like the Flash mms.cfg th [More]
As we all now, there's a huge security hole in flash. It's not a question, what to upgrade urgently in 32-bit systems, but the crap company Adobe didn't provide us a 64bit version of this new flash beta. The question is: In 64bit systems wouldn't it [More]