Crystal Report and SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Crystal Report and SQL

Author

Topic

azim
Starting Member

29 Posts

Posted - 2002-02-15 : 04:07:54


Rpt1.SelectionFormula = "{absentees.studentid}='" + Val(Text1.Text) + "' and {absentees.year}='" + Val(Text2.Text) + "'" 
Rpt1.Action = 1

azim

Nazim
A custom title

1408 Posts

Posted - 2002-02-15 : 05:35:56

What is your question Azim?

--------------------------------------------------------------
"Happiness is not something you experience, it's something you remember."

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2002-02-15 : 06:30:47

Perhaps Graz could introduce a section where people post answers and we make up the questions to fit them

azim
Starting Member

29 Posts

Posted - 2002-02-15 : 06:33:27

thanks nazim
the question
can i creat report with Crystal Report with this code
i want to print the student absent days in year 2002 only

same like :
select * from absentees where studentid like '" val(text1.text) '" and year like '"val(text2.text)"'"

can you translate this code to crystal report code
thanks a lot naZIM

azim

Nazim
A custom title

1408 Posts

Posted - 2002-02-16 : 00:05:25

The First step will be creating a standard report with crystal report where your datasource will be absentees.

if you are calling the report from VB. instead of using + replace it with & otherwise your code is fine.

Rpt1.SelectionFormula = "{absentees.studentid}='" & Val(Text1.Text) & "' and {absentees.year}='" & Val(Text2.Text) & "'" Rpt1.Action = 1

HTH

--------------------------------------------------------------
"Happiness is not something you experience, it's something you remember."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources