About Crystal Report 6 with "saved data with report"!

[IThelp]

I'm using Crystal Report 6. When my application printing a report (to printer), it also set to create another report to a file in "rpt" format. I suppose when i open that saved report file, i should get the same data as the printed report. The problem is when i open the saved report from my application, the saved report will get the lastest data instead of the data during the printing. It seems to me that the saved report has been refreshed and retrieving the lastest data instead of displaying the "saved data". So, any solution that just to display the "save data with report" record?

 

[kenhamady]

Are you exporting the report to RPT?
Why not have the orignal report set to save data, and have the app simply save the report under another name after it has been printed? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[IThelp]

Yeap! I export the report files to another folder with the same report names as original reports in rpt format. The original reports are located at different folder. If i open the exported report files directly, i will get the exactly "saved data" that i want. But, if i use my app to open, i would not get the "saved data". My application statement as follows :

With mdiMain.rptMain
.Connect = gstrCR_Connex
.ReportFileName = gstrNA_Temp_Path + strNARpt
.Destination = 0
.Formulas(0) = ""
.Formulas(1) = ""
.Formulas(2) = ""
.Formulas(3) = ""
.SelectionFormula = ""
.WindowState = crptMaximized
.PrinterSelect
.Action = 0
End With

This things happened when upgrade my Crystal Report 5 to Crystal Report 6.

Please advice.

 

[kenhamady]

So this used to work fine, and now it doesn't? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[IThelp]

Yeap!! it doesn't work fine. I have tried with Crystal Report 7, it works!!! Anything that i can do with my crystal report 6?

 

[kenhamady]

Is Yeap supposed to be Yep?

Let me clarify the problem. You can create a file with saved data from the application, but if you try to print it from the application you get fresh data. Is that the problem?

You say this works with 7, do you mean if your application uses the 7 dlls you can print the saved data? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[IThelp]

Yep! You are right!! i can print the saved data with 7 dlls.. but not 6.

 

[kenhamady]

I am sorry, I can't think of why that would be, unless there is a bug in the 6 dlls.

And you are sure there is no other difference in the environment, or code or report, just the different dlls?

What would happen if you created a report outside of the app in the CR designer, then saved it with data, and last tried to run it from the app with the V6 dlls? Would it refresh instead of running the saved data? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Guest_imported]

I am accessing a report from work, we are running MS Proxy 2.0. I can get to the site fine; however, if I try to open a report it shows the symbol for crystal then opens or seems to, then there is a small area on the screen dislaying downloading. Then it ends and the report is not displayed. If I completely bypass the proxy completely it opens fine. This is not an option. When I put a sniffer on the network it shows that there is one packet that does not get delivered. I am going to put the sniffer right on the proxy to see if more information is available. Any thoughts, or answers that might halp me through this delema.

 

[kenhamady]

You added your post to an existing question. Please add it as a new question, probably in the new "Crystal Integration" forum. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Guest_imported]

crystal report 8
ms-access 2000

i made a query with union all with 3 table name
ie
( select * from ..condition..where tname='tname1'
union all
select * from ..condition..where tname='tname2'
unioan all
select * from ..condition..where tname='tname2'
)

i made file dsn for that database.
now in crystal report ,under option of sql,odbc i select dsn and then select query
after that it ask for discrete value for parameter fields for 3 table name (tname 1,tanme2,t name2) which i have used. but i didn;t pass anything like parameter.
so what will be the problem.
if use query without union query (simple uery)it will not ask for anything

 

[kenhamady]

Please ask this as a new question. Not a follow-up. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)