on 03-02-2016 4:23 AM
Hi Zaid,
Right click on the total column and select the option Edit Summary then select the radio button "show as percentage of" Total field
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK. See if this works:
1) Right-click the Total Column Header > Calculated Member > Insert Child. A blank column with zero values is added at the start
2) Right-click the top left corner of the Crosstab > Advanced Calculations > Calculated Member > Select the radio button labeled 'After'. This moves the new blank column just before the Total column
3) Right-click the 'Total' column header > Column Grand Totals > Suppress Grand Totals. You may also want to suppress the Row Grand Totals in a similar manner.
4) Go to the Crosstab Expert and remove the percent formula I suggested earlier from the Summarized fields. Instead, add the Total Marks field as the second summary field
5) Right-click the blank header cell in the new column > Calculated Member > Edit Header formula > Type in:
"Percentage"
6) Right-click the first zero value in this column > Calculated Member > Edit Calculation formula > Add this code:
gettotalvaluefor("Subject",0) % gettotalvaluefor("Subject",1)
Notice how the database field 'Subject' is enclosed in double quotes
7) Highlight the second summary field in the Crosstab > Suppress. This is the Total Marks field and we don't need it for display
😎 Reduce the size of this summary field so that it barely takes some space.
If you follow all steps correctly, you should get this:
-Abhilash
It's available for download here.
-Abhilash
You cannot use a dataset in the designer. A dataset is a .NET construct for .NET SDKs. However you have several options:
1) Build a Dataset Provider DLL and use that to create your report. See Using The .NET DataSet Provider in Crystal Ente... | SCN
2) Create an XML from the dataset and use that to build your report. Then in your .NET app point the report at the dataset:
crReportDocument.SetDataSource(dataSet)
For more information see re datasets:
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx |
Crystal Reports for Visual Studio 2005 Walkthro... | SCN
- Ludek
Senior Support Engineer Product Support, Global Support Center Canada
Follow me on Twitter
Got Enhancement ideas? Use the SAP Idea Place
I Open Crystal report standalone designer,for the first time, Made a cross tab report and select VS made Dataset (as ADO.Net(XML)) that resides in Visual studio project directry. and then I added that report in visual studio, and runs the report, its look strange that it accepted the VS dataset and Showing the data
Yeah Right clicked on header but I didnot find that option.however when I right clicked on top left corner of CrossTab, I saw Option "Advanced Calculation" >"Calculated Member"
Made Calculated member here. Set the insertion formula,Edit The Header, I run The report it shows me the Percentage column at runtime,not at design time. but now Im facing error when I Edit Column Value Formula
.May Be your trying to guide me acorrding to different look and feel of the UI of different version thats why Some options are here and there with different headings.
Lemme tell you whole story, Im using Webservices(WCF Rest) Services return data in form of List<CustomClass> . My Reports are for client side,(No Need of DB Connection at client side), Report DataSource is List. Report dont have any data at design time so my Preview Window not showing any data. its showing empty rectangle of Cross Tab
User | Count |
---|---|
74 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.