How I use the report designer is pretty simple and consistent. Report data is usualy produced by calling a stored procedure (on SLQ server 2000), I have a few parameters. Some of Paramaters are dates with a default values calculated to give yesterday's date or today - 7 days. And that is the only code in the report itselft. As soon as I click on Yes/No paramater, that doesn't have default, and is int in proc and report, then complete Visual Studio Environment starts flashing, making bip-bip noise, and is blocked, no access and reponse. I can't close it for a while, I can't bring up task manager, and in general this crash is very much resource intensive, Outlook is freezing, can't open IE, new spreadsheet. I am working on windows Xp platform. Eventually I would manage to close VS thru task manager.
As soon as this report is uploaded to Report Manager, the place where all the reports are available to users, on different server, the same report works fine.
Has anyone experienced this and what would be the reason.
Thanks in advance,
Elizabeta R
did you get out of memory exception.. check ur database may be it contains huge data..
run the query in sql server..
No comments:
Post a Comment