DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Help! Excel to Crystal report

    Hello
    I have to develop a report in crystal report 10. I am new to crystal reports. Sample is given in an Excel file. It has two parts first is pivot table & second is Table which perform some calculations based on following two input values
    • from pivot table (I guess this can be a running field or formula field)
    • from user inputted values (parameters)
    But in excel with the help of GETPIVOTDATA & cells formula, we can perform this task. I am facing problem about i.e.
    1. How can I get cell value of a crosstab in Crystal report 10 to create running field or formula field?
    2. How can I get values of parameter from user after report is created & rest of calculation is waiting for values to be inputted by user in second table?
    3. If the second table is also crosstab then can a crosstab accepts the values from user inputted vals or running/formula fields?
    Below is the demonstration how things are required. If any body can answer/guide me through his precious knowledge I will be thankful to him

    HTML Code:
    	                        MonthNomber		
    Date	Price	Data	1	2	3	Total
    -	-	-	aVal	aVal	aVal	aVal
    			bVal	bVal	bVal	bVal
    -	-	-	aVal	aVal	aVal	aVal
    			bVal	bVal	bVal	bVal
    -	-	-	aVal	aVal	aVal	aVal
    			bVal	bVal	bVal	bVal
    
    	                         MonthNomber		
    			1	2	3	Total
    		     Avg       Avg         Avg      Sum of all 
    		     bVal1    bVal2       bVal3    bVal Avgs
    
    		     User      User         User       Sum of all
    		     val 1      val 2        val 3       User vals
    
    		     Avg 1 /    Avg 2 /     Avg 3 /
    		     User val1  User val2  User val3

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    If you don’t get an answer here, you might try Crystal’s tech support site: http://support.businessobjects.com/
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 2
    Last Post: 01-27-2007, 06:28 AM
  2. A couple of questions on Crystal Report
    By andreasg in forum VB Classic
    Replies: 0
    Last Post: 06-29-2006, 06:08 AM
  3. Excel to Crystal Report
    By shers in forum .NET
    Replies: 0
    Last Post: 10-02-2005, 04:29 AM
  4. Working with Crystal Report Ver 10
    By AM003295 in forum VB Classic
    Replies: 4
    Last Post: 08-12-2005, 09:13 PM
  5. Replies: 1
    Last Post: 06-14-2002, 03:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links