General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 21st, 2006, 02:02 PM
Driest Driest is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2006
Posts: 4 Driest User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 29 m 41 sec
Reputation Power: 0
.net Crytal Report

I have a .net web application that has a link to a crystal report which queries (with 3 parameters) an MSSQL database for its information. The problem is the crytal report was opened, realized something was wrong, so a row needed to be deleted. It was successfully removed from the SQL database and on teh web page it reports as deleted (as it should), but when you load the crystal report, the row that was supposedly deleted still shows up. I loaded the report in the actual Crystal report program, and it showed the same thing with the deleted item still there. When i refreshed the report however, the deleted item disapeared (as hoped). The thing is a simple refresh from IE (which it opens up in) does not actually seem to refresh the report. I imagine the report is getting cached somewhere, but I dont konw why or where. Even opening the report on another computer produces teh same thing with the deleted item showing up.
I imagine tomorrow when it gets reloaded it will show correctly, but can someone tell me how to force it to reload with the correct parameters when opening from my web app?

The code for loading the page is as follows:

Dim crReportDocument As ReportDocument
Dim crExportOptions As ExportOptions
Dim crDiskFileDestinationOptions As DiskFileDestinationOptions
Dim Fname As String
Dim startWeek As String = Request.QueryString("WeekStart")
Dim endWeek As String = Request.QueryString("WeekEnd")
Dim machine As String = Request.QueryString("Machine")
Dim crFname As String = Server.MapPath("\RawMaterialCost\CrystalReports\CRRawMatDetails.rp t")


crReportDocument = New ReportDocument

crReportDocument.Load(crFname)
crReportDocument.SetParameterValue(0, startWeek)
crReportDocument.SetParameterValue(1, endWeek)
crReportDocument.SetParameterValue(2, machine)

Fname = Server.MapPath("\RawMaterialCost\CrystalReports\CRMatDetails.pdf")
crDiskFileDestinationOptions = New DiskFileDestinationOptions
crDiskFileDestinationOptions.DiskFileName = Fname
crExportOptions = crReportDocument.ExportOptions

With crExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With

'crReportDocument.PrintToPrinter(1, False, 1, 10)
crReportDocument.SetDatabaseLogon("sa", "passwordxxx", "SQL-Server", "DATA")
crReportDocument.Export()
'write pdf file to clients browser
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(Fname)
Response.Flush()
Response.Close()

System.IO.File.Delete(Fname)
End Sub

(all in the page load function)

Nick

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > .net Crytal Report


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap