Solved

Passing Formula to cr viewer

Posted on 2003-10-30
3
413 Views
Last Modified: 2006-11-17
Hi

 How can i pass multiple formulas to cr viewer through vb.? i don't want to use this

CR_Report.FormulaFields(8).Text


 because the sequence is hard to remenber.

Instead of 8 is it possible to specify formula name like it can be done in Cr activex control.

Thxs
0
Comment
Question by:jatinderbahl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 30 total points
ID: 9650384
Yes and no.

The names are available but I don't think they can be used as an array index like
CR_Report.FormulaFields("MyFormula").Text

You can do something like

for i = 1 to CR_Report.FormulaFields.count
    if (UCase(CR_Report.FormulaFields.Name(i)) = UCase(FormualaToPassName)) then
      CR_Report.FormulaFields(i).Text = NewFormulaString
   end if
Next i

A little slower but it works well.  I pass all my information to reports in a similar manner.

mlmcc
0
 

Author Comment

by:jatinderbahl
ID: 9662888
thnxs
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9664066
Glad I could help

mlmcc
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question