|
Hi
This might be caused by the way CrystalReports builds it SQL query statements. It builds VERY complex SQL statements by joining all the tables you linked through the wizard. The best way to optimize the performance is using (optimized) SQL-Expressions for data selection with your own sub-selects instead of linking the tables through CrystalReports.
The phenomenon that executing the report takes much longer then working in designer could be caused by the fact, that CrystalReports caches the data once loaded.
Maybe this helps you a little bit
Best regards,
Don Teflon
|
|
|
|
|
Thank You,
The Problem seems that
When the report executes it tries to cash the entire report into memory and then export
But when i chopped the data into batches of 100000 records
Each exutions takes 22 mins to complete.
so there mabye a bottleneck of report against hardware performance
Anyway Thanks a lot 
Best regards,<br />
Chintan Parikh
|
|
|
|
|
Apparently there are no event associated with a change of the form's WindowState property.
How do I know when my windows has been miniaturized?
|
|
|
|
|
If I remember right with every state change the SizeChanged event gets thrown. You would then just have to compare it with the previous state.
|
|
|
|
|
Yep, I found out just a little while ago 
Thanks anyway!
|
|
|
|
|
I installed some software on a client's PC today and had some weird issues with layout and window resizing. He was running Windows 2000 (not sure what service packs right now), and I had to install the .NET Framework (2.0) for him today.
For example, I had some Label controls (with image backgrounds set to a fixed size) positioned in the top right corner of the form (inside a Panel actually) and anchored to the top and right. On his PC though, the Labels were floating about ~30 pixels lower than they should. The rest of the controls seemed to be layed out like normal.
Also, the Form had a minimum size set, but no maximum size. It starts at the minimum size, and resizing the window larger works fine for me on my machines. On his machine, though, the form *started* smaller than the minimum size and he couldn't resize it up to or past the minimum size. He could resize it UP a little bit, but even then it was less than the Form's minimum size (I could tell because of the layout of hte controls and the background image on the Form). The other form used in the application is set at a fixed size, and I set it so you cannot resize it, but oddly enough that form started *larger* than that set size.
Has anyone else seen this behavior? I have installed this same software on other machines in the same company that were also running Windows 2000, and it worked fine, so I'm not sure if it has to do with the machine running Win2K or not. All my test and development machines are Windows XP. Maybe it has to do with his settings under Display Properties -> Appearance in Windows? I'm just hoping someone has seen this before and knows how to fix it or exactly what is causing this behavior.
Any help is greatly appreciated, thanks!
Andy
|
|
|
|
|
I suspect there is a mess between your client's DPI setting and the AutoScale property of your control.
Just as a quick check show the Window's display property => settings => Advanced
If the DPI setting is not 96 that could explain it...
|
|
|
|
|
Hola, I am trying to use C# to make a HTTP POST request. This request should carry file data, and have some parameters in it as well.
This is quite easy with HTTPRequest, but the problem is, I need progress information as well, and the only apparent way to do this is to use the WebClient classes (UploadFile or UploadData). I've been trying both the whole day, without much success.
My code looks something like this:
WebClient client = new WebClient();
Uri uri = new Uri(url);
// Placing the parameters in a name-value collection
NameValueCollection param = new NameValueCollection();
foreach(string[] nameValuePair in parameters)
param.Add(nameValuePair[0], nameValuePair[1]);
// Addin headers.
client.Headers.Add("User-Agent", "MyApp");
// Adding the parameters
client.QueryString = param;
client.UploadFileAsync(uri, "POST", fileName);
Basically, judging from the server response, it appears that the server can see that a file is coming in, but cannot read any of the parameters that I send along in the request. To make matters worse, WebClient is doing something dodgy while using the HTTP protocol: none of the requests turn up on my HTTP sniffer! So I can't tell what is going out of my computer.
Help!!!
- Vikram
|
|
|
|
|
Check for differences in video card/processor and drivers.
We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene
|
|
|
|
|
The problem was that one machine had large font set and the other small font, and a status bar displaying hints was changing size by one pixel when large font was set. Thanks.
|
|
|
|
|
Is there a way to detect the plugging and un-plugging of a device on a Serial Port?
The requirement is such that during application runtime, if a device is connected to the serial port, the application should be able to detect the device.
Help needed PLEASE.
|
|
|
|
|
Normally if a device is ready to operate, it asserts the DSR (Data Set Ready) line. You can check for this in code using the GetCommModemStatus API (for Win32). Polling is generally considered a bad idea - you can wait for a change in these flags to occur with the WaitCommEvent API.
From .NET Framework 2.0, these map to the DsrHolding property and PinChanged event of the SerialPort class.
|
|
|
|
|
Hi,
I was hoping if someone could help me with this problem. I want to edit
datagrid entries without using a linkbutton column for edit and update.
maybe we could do this using javascript. But I dont know how?
On an 'edit settings' button click outside the datagrid, the cells in the datagrid should change into dropdownlists and textboxes with earlier values maintained.
Thanks!
Monisha
|
|
|
|
|
Hi, i'm trying to get a service to create a process text file on a 2nd machine (xp) from a w2003k server. however it fails in a grand way when it tries to create a streamwriter on the xp box! i understand it may be to do with the account etc, but i've set the log on tab for the serviec to be admin but it still fails, i've tried 'p:\thisfolder' as well as '\\thismachine\thisfolder'.
Can anyone point me in the right direction as it's been days of hell on this one.
Thanks
Captain Willard and crew
-- modified at 10:02 Thursday 27th July, 2006
|
|
|
|
|
Mapped drives are stored in the user's profile, and services don't load the user's profile, instead using the default user profile. I'd use a UNC path. We found when doing scheduled backups remotely using NTBackup, scheduled with the Scheduled Tasks feature, for a mapped drive to work successfully, the user needed to be logged in. Switching to a UNC path meant that the user no longer needed to be logged in.
Network shares should be accessible by a service as long as either a) you use a domain account which has permission to write to the folder or b) the user account name and password on the client match with the same account name's password on the server.
You should check the NTFS permissions on the share as well as the share's permissions. Both need to allow the write for it to work. I normally just leave share permissions at Everyone/Full Control and rely on the NTFS permissions.
|
|
|
|
|
Cheers, i managed to get it sorted, i thought i'd had the right permissions set but seemingly didn't.
Dan.
Never get off the boat!
|
|
|
|
|
Is there a way to change managed assembly atrtibute programmatically? for example version number of a file.
warm Regards
Mush
-- modified at 1:19 Thursday 27th July, 2006
|
|
|
|
|
Hi everyone,
I have to convert video files on the fly and I should export some video frame as a jpg (and get video props - duration, etc...). This should be done in an asp.net page.
I've seen ffmpeg does the first work in an excellent way, but I have to execute the external exe... The problem that in hosted environment it's not possible...
Do you know if ther's a project that have already ported ffmpeg to .NET? Or if there's a wrapper for interfacing with ffmpeg dll? I've searched on the net but I found nothing...
For the second task (export some jpg and get info) in php there's ffmpeg-php ... Is there an equivalent project for asp.net?
These are the solutions I've found... If someone knows a different solution I'd appreciate it very very much!
thanks in advance...
|
|
|
|
|
hello friends..
I had Ms Sql Server 2000 installed on Xp machine..suddenly when i observed server's icon on taskbar.it stopped working..when i tried to start it..it couldnt..log file says server evaluation period expired..Is there any way to make it work..or start Sql server on my machine now...
plz help
|
|
|
|
|
SPend money to replace your timerware demo with a normal license.
|
|
|
|
|
one way to make it work is by unistalling it then cleaning up your registry manually.then reinstall it. however, like Dan said, you can spend money and buy the license.
Regards,
Hesbon.
|
|
|
|
|
Hi,
I hope this is the correct newsgroup for this question.
I am creating a test web service that I wish to extend.
The example I am working from suggests that Web Services can be called direct using HTTP GET, eg:
http://server/webServiceName.asmx/functionName?parameter=parameterValue
However when I try this I get the following error:
Request format is unrecognized for URL unexpectedly ending in '/functionName'.
It works fine if I first call the service, click on the public method and then invoke.
I am using IIS5.1, VisualStudio2005 and .NET 2.0
What am I doing wrong? (I even tried altering the IIS settings without success)
Thanks in advance
Andrew
|
|
|
|
|
Have you tried this below?
http://server/webServiceName.asmx?parameter=parameterValue
Mike Lasseter
|
|
|
|
|
Hi,
Yes, however this acts as though I have missed off the
?parameter=parameterValue section.
ie: It returns the usual page listing all the public methods for the web service as though I had used the basic URL: http://server/webServiceName.asmx
Any other suggestions/options?
Thanks Andrew
|
|
|
|
|
Hello,
Writing windows service in c++.Net 2005 it’s clear, but I’ve problems when I
Want to write a windows service in C++.Net 2005 but with unmanaged code.
I’ll appreciate if anyone can give me a clue/hint.
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
