|
Crystal Reports for Visual Studio .Net 2003 Parameter Passing |
|
Living in Software Development
|
By host on
11/30/2006 6:58 PM
|
|
|
|
Today I wrote a Report for a client using Crystal Reports for Visual Studio.net 2003. The report uses two stored procedures in MSDE as the datasource for the main report and one subreport. Both stored procedures use the same parameter name, and when I first ran the report I received multiple parameter prompts, even though the parameter name in both stored procedures is the same. There is a linking that can be done between the main report and the subreport to suppress the duplicate parameter prompts. The way you do it is to open the report in Visual Studio. Right click the subreport in the design view of the main report and click "Change Subreport Links." From the Available Report Fields list, I selected the parameter from the Report Fields and added it to the "Field(s) to link to:" list. As soon as I did that, a new control popped up below the two lists where I could select the subreport parameter to link, and then the multiple prompts issue was squashed.
|
 |
|
Comments (0)
|
|
|
|
IIS Under Construction Page |
|
Living in Software Development
|
By host on
10/23/2006 9:53 PM
|
|
|
|
I just finished porting the content over from www.lowcountrygeologic.com and I was ready to build the new DotNetNuke version. The only problem was that the Lowcountry Geologic was a live site. I needed to display an under construction page to let users know that the site didn't just drop off the map. Putting up an under construction page wasn't as straight forward as I though it should be, but I still came up with a quick and easy solution. In IIS I created another site for the under construction page. Then I removed the identity (host header value) from the old site and moved it to the under construction site. This is done by right clicking on the site in IIS, then clicking Properties. On the Web Site tab, click the "Advanced" button. Click the "Add" button and add the domain. I left the TCP port 80 and entered the domain name as the Host Header Value. It may not be the preferred way to do things, but it was qu ...
|
|
|
|
Comments (0)
|
More...
|
|
|
Lessons in GDI |
|
Living in Software Development
|
By host on
10/15/2006 8:58 PM
|
|
|
|
Today while I was working on my thumbnail generator I ran into a nasty OutOfMemoryException while creating thumbnails from JPEG/JPG files. Of course I spent time pouring over my code to find the memory leak but when nothing turned up, I started researching the problem. Turns out that my code was good, and the issue lies partly with GDI. It turns out that GDI throws the OutOfMemoryException as a default exception. I looked to the images I was converting and found the issue was caused by some invalid images. The file system reported their sizes as 0. As soon as I deleted them, the thumbnail utility worked without issue.
|
|
|
|
Comments (0)
|
|
|
|
Mass Thumbnail Generation Woes |
|
Living in Software Development
|
By host on
10/14/2006 10:14 PM
|
|
|
|
I am burning the midnight oil lately trying to get www.lowcountrygeologic.com converted over to my DotNetNuke Store module and it is time to convert the pictures. The old site dynamically generated thumbnails, but the new one uses a thumbnail on the file system to speed up operations. The trouble is that Lowcountry Geologic has over 5500 images, and I had to generate a thumbnail for each of them on the server. There is no way I am downloading that much data, and even if I did, my image editing software will only let me process 40 images at a time.. My first idea was to find a free thumbnail generator. A quick Google search revealed many options. I downloaded each of them, and one by one I found a reason why none of them would work for me. One of them overwrote my source images. Another of them forced me to change the file extension. Others added a prefix or suffix to the thumbnail. Another one wouldn't let me choose the size of the ...
|
|
|
|
Comments (0)
|
More...
|
|
|
L’s Gone Wild |
|
Living in Software Development
|
By host on
10/9/2006 11:17 PM
|
|
|
|
The time to develop DNN Modules has arrived so I downloaded the latest release, 3.3.5 and installed it without any issues. When I opened my new portal, to my dismay there were L characters in front of almost every single control. The fix was to open the web.config and change the ShowMissingKeys key to false.
|
|
|
|
Comments (0)
|
|
|
|
Slow Deleting files through Windows Explorer |
|
Living in Software Development
|
By host on
7/9/2006 9:58 PM
|
|
|
|
Sometimes when I delete a file through Windows Explorer it takes a minute or more. I just had enough today and decided to figure out what was causing the issue. It turns out that my Recycle Bin was loaded far beyond capacity and Windows XP was choking every time it had to add another reference to its already bloated set of files I had deleted in the past. I admit it, I’m really bad about deleting stuff. I always want to hold onto stuff just in case I need it again. You should see my garage! Most of the wasted space was due to to DotNetNuke folders. I seem to have to reinstall that a lot to work out little issues, so there were about 50 past deletions going back months in addition to other various garbage data files that I canned and forgot about. It literally took 15 minutes for Windows to clear out my Recycle Bin, but now when I delete files performance is drastically improved.
|
|
|
|
Comments (0)
|
|
|