Help! Excel to Crystal report


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Help! Excel to Crystal report

  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

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


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center