Wednesday, May 30, 2007

Crystal Report and C#

Does the title seem familiar? Well for me I've been working with Crystal Report 8.5, SQL Server 2000 and VB for almost three years now. But C#... wait a minute it is not a mistype or anything, this is a new programming language for me. Maybe not entirely new, because it has been wondering around since the introduction of Visual Dot Net by Microsoft. Ok, to cut the story short. Last couple of days, I've been given a task to migrate some of our reports from VB6 to Dot Net. I have successfully exported a report, but have been unsuccessfull in a report which has subreports in it. I don't know what's wrong, because in the report itself I have defined the link value which links the main and subreport. If I ran it from VB6 it's perfect, however each time I ran it from Dot Net the same window pops up. The window always ask for a discrete value for each parameters in the subreport. I tried to feed a value in it or passing it programmatically but still no success. Has anybody experienced the same problem? Or does anybody know what's going on and how to overcome it?

1 comment:

  1. woo hoo.... At last I found the problem and solve it. Turned out I was wrong with the datasource. I was pointing the datasource of the subreports to a table where it should be a view. And we have to explicitly passing the values for the parameters of the subreport. Now it's working, time for a quick surf on the internet...