Search results for query: *

Figured out the solution: QualifiedName= Split(myReportDocument.ReportClientDocument.Database.Tables(0).QualifiedName, ".") myTable.Location = QualifiedName(0) & "." & QualifiedName(1) & "." & QualifiedName(2) Somehow this doesnt work: strLocation =...

Finally, I figured out. It's not the code can't pick up the latest version, its just that the code didnt point to the right location of the table. We had code for SQL datasource, something like : strLocation = crConnectionInfo.DatabaseName & ".dbo." &...

Hi hilfy, Thanks for your reply. But the issue here is not Crystal Report file itself. The report running perfectly in CR 2008, but the same file can't bring the correct result if its been called from .NET webpage. Any ideas regarding this .NET/Crystal Report issue?

Further to my other question here, the code has error when run to myTable.Location code. myTables = myReportDocument.Database.Tables For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables myTableLogonInfo = myTable.LogOnInfo With...

Thanks Dell! My second issue becoming a bigger one now, the .NET CR presents data from a previous version of Oracle Stored Procedure result, which has been deleted and proved in CR2008 (Report opened in CR2008 picks up the latest version of the sp). I tried to take off "Save Data with Report" ...

After i changed the name of the stored procedure in Oracle, and saved in CR2008, .NET still looking for the old version of the stored procedure. Do i need to dispose the connection in .NET and if so, how? Thanks a lot!!

I have this CR connect to Oracle database, it runs okay inside CR2008, but its extremely slow when i run it from .NET by using ExportToStream (PDF) function. How should i improve the performance? Thanks a lot for any hints/help!

Another strange thing is, after i change the parameter looks like the Crystal Report shows result from a previous version of design. e.g. I changed the package on Oracle but the report doesnt reflected the change at all.

I am buidling a .NET app which will take parameters from users and pass to a crystal report, at the end the crystal report will be export as PDF format. The strange thing is, if i test the Crystal Report via CR 2008 then the report with the same parameters can be brought up quickly in PDF from...

Okay, now i can simplify my questions as below: I need to design a conditional split, the value of the checking field should be in a range, which would be an array variable. I can now get the dynamic array variable, but just dont know how to make the condition checking. Thanks for any...

Thanks Williey. But the reality is I only have read permission on both remote databases. More suggestions?

Hi all, I need to select some data from a remote database, in the where clause i have a subquery which defines the select criteria. The subquery is from another remote database. SELECT db1.field1, db1.field2 FROM remotedb1 db1 WHERE db1.field3 IN (SELECT db2.field4...

Finally, I solved this problem. It turns out that some NULL value in the data resource conflict with the destination table contraints. Weird thing is, SSIS package didn't issue any errors, and the result shows package finished successfully, i guess this could be a bug in SSIS?

Hi, I am creating a DFT from an Oracle view to a SQL table, it shows in the data flow diagram that there were 1,360,358 rows wait to be transferred, but the destination table only get 872,829 reords. The output shows package finished successfully, without any errors. What's happening here...

crParameterFieldLocation = crParameterFieldDefinitions.Item("pfRepStartDate") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value =...

I am using the calendar to sends dates to my crystal reports. The weird thing is, most of the time the calendar works fine, but sometimes it sends null strings which lead my crystal report crashes. Any hints?