crystal report.

Posted on 1999-10-27
Medium Priority
Last Modified: 2012-05-04
how do i do this.

i already create 1 report using crystal report tools. name helpme.rpt.

now i want to give my a user a tool that he/she can modify the contains of that report.

1.like he/she can modify the structure of that report. such as he/she just want to print some records maybe this abc field = cde where
xxx = help and what ever. so this data will directly go into crystal report which is name help.rpt.

2. the command to change the help.rpt header and footer.

for your information i dont want to instal crstal report in that machine.

Question by:JOHNHO
  • 2

Accepted Solution

ventond earned 200 total points
ID: 2163281
There are a couple of different ways to do this, if you are reading records from a database you can say:

Report1.GroupSelectionFormula="{Table1.field} = 'xxx'"

If you just have data on the report that you may/may not want to print then you can make formulas on the report:

Formula1 'A place holder
in code you would say:
Report1.formulas(0) = "Formula1='Y'"

then in report for other things you might want to print based on Formula1.

if Formula1 = "Y" then
   "This is data"

I hope you get the idea.

Author Comment

ID: 2164180
how do i get table1.field.

what is that ?
lets say i have 3 field.

1 field = abc
2 field = cde
3 field = ghj

does it mean abc.field ?

Expert Comment

ID: 2167360
I don't really understand what you are asking.

Do you mean how do I only print those items on "TableA" where the value of "FieldA" is = "abc"?

Report1.GroupSelectionFormula="{TableA.FieldA} = 'abc'"


Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month5 days, 7 hours left to enroll

601 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