DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Help! Excel to Crystal report

    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:
    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
    			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
    Portland, OR
    If you don’t get an answer here, you might try Crystal’s tech support site: http://support.businessobjects.com/
    Phil Weber

    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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.