Crystal Report Prob

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[Moved thread]

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?

Crystal Report based on SQL Query!

Hi all,

I'm working on Crystal Reports in C#. (Ofcourse ... this section of Forums is on VB... But still... i may geta solution for my prob!!)

I need to generate a report based on data retrieved from an SQL Query. Every time I need to pass this Query dynamically to the report, I mean, my SQL Query is not constant but changes depending on certain criteria.

How can I let the Report know this changing Query??
I could generate a report based on a fixed SQL Query. But How to send this dynamically changing Query to the report??

Pls help me out.

Thank you all.

Bye.i dunno about C# but, u can do it in VB.Net by setting the dataset as report source.

may be it can be done in C# too.

Already answered how to do it in VB.net, in this forum.|||Mr. Addidas

Hope the field names and number of fields are same eventhough query is changing.

Why don't you go for procedure with parameters. You can pass parameter dynamically to procedure. In VB the crystal report control provide this facility by ".StoredProcParam(0)" property. obviously you can give any number of parameter.

Second method is you can pass total query as string parameter to procedure.