Showing posts with label babu. Show all posts
Showing posts with label babu. Show all posts

Sunday, March 25, 2012

Crystal Reports Question for BABU/any GURU

Can some one please help me with the below.

I need to write a formula in crystal reports to give the birth dates for this week. For Example: If I am running the report on a Tuesday I need to see the results from Tuesday to Saturday. I know that we can acheive this in 7 conditional steps, but I am looking for a precise formula. Can some one please help me with this.

Thanks
BTry this logic

Date=Date+5

CR.selectionFormula="{DateField=Date}"

Sunday, March 11, 2012

Crystal Report Prob

Thanx Andreas Masur.. But I couldn't solve my prob..Look at it please...

Attention Mr K Babu..Pl see my prob and give me a solution..

I have used the following in my project-
i) V B 6.0 as Front End Tool.
ii) Oracle 8 as RDBMS.
iii) Windows 2000 Advanced Server as Server O.S.
( The machine has dual O.S i.e Windows 98 SE also is there)
iv) Crystal Report 7.0 as Reporting Tool.

Now my problem is While calling a report from VB, I need to REFRESH and SAVE the report in Seagate Crystal Report, otherwise the latest data inserted does not show.

The part of coding used also given below-

RPT1.Selectionformula=Tablename.Fieldname
RPT1.Action=1
Some more points-
i) Another important point is I used DiscardSaveData property before Action property, even then it was not working.
ii) There is no Refresh method shows in the Property and Method List.
iii) Sometimes while saving the Report in Crustal Report I had to use Save As command as the report takes some other name having extension .TMP
iv) The error mostly I faced is "SQL Server could not found, Error 20599"- where as I did not use SQL Server and I used only Oracle 8..,

ThanxI use CrystalRyport. I want to print records in the same line in succession . How do i do?