More Bugs In SSRS 2k5 ....
Aug 13, 2007
Here is another one thats been bothering me for quite some time and I believe for user with regional and language settings to non-US English.
I have my regional settings set to Canadian English. I am using Calender controls to pick up Start, End dates in my report. When I pick a date from calender it automatically converts it behind the scenes to US English I believe. Therefore when I run the report, I get the result set, say from Oct 8 instead of Aug 10. Further, if I select the date as 13 Aug, the following error gets thrown (as a result that the SSRS is not able to identify 13 being any month of course)
"An error occured during local report processing. The value provided for the report parameter 'StartDate' is not valid for its type".
Is there a solution to this problem? The underlying date type is DateTime, so why should it matter which regional setting I use?
Comments anyone?
View 9 Replies
ADVERTISEMENT
Dec 21, 2006
Where can a person go to report SSRS 2005 bugs? I didn't see any area for error reporting.
These are the few bugs I've recorded, but I've seen so much more :(
On 2005sp1, and mainly using ssas 2005 for source data:
When you have an existing report parameter that was created by the graphical query designer area for dataset1, and then you go to make another dataset and add the same hierarchy and choose for it to be a parameter, it will overwrite what parameter settings you just had (ie, not multivalue and a special default value I desired).
When adding subsequent series or category fields to a chart, the default series/category grouping name remains the same and causes a error when attempting to run the report. IE: chart2_CategoryGroup1, chart2_CategoryGroup1, chart2_CategoryGroup1 - all names are the same for all of the 3 groupings that I've added.
View 3 Replies
View Related
Jan 28, 2000
I just recently ran into the problem of a memory leak using xp_sendmail with certain parameters. After going online with microsoft I found out this is a known bug. Is there anywhere that they list all the bugs currently known for SQL 7 after applying SP1
View 1 Replies
View Related
Jun 16, 2006
[url=http://www.arcon5.com/modules.php?name=News&file=article&sid=280]excel bugs[/url]
hey guys,
i thought this arcle may be of interest to you all... with office suite being very popular and all that
View 2 Replies
View Related
Aug 17, 2007
Does anyone know if there is there a published list of outstanding SQL Server bugs? I keep coming across bugs and I would love to have link to where I can proactively review them.
View 4 Replies
View Related
Jun 27, 2007
I have a table contain a sub report . when I run on preview (visual studio), no problem . but when I run from my application , the report viewer just show "Report been generated" , never show the report .
after try and error I discover that when the query from main report return no records , plus the table contain a sub report , the problem occur only if you run it from your application using report viewer . not from visual studio . is this a bugs? anyway to resolve this or work around?
thks
View 1 Replies
View Related
Jul 11, 2007
try copying a connection manager from one package to another
it does not work
e.g. excel connection manager
it loses the name of the connection manager and also the file you are pointing to
so it is basically no different to 'add new connection manager'
also
try copying the name of the connection manager to another connection
select connection, hit F2 (edit) ctrl C,
try pasting!
in order to paste you have to right click on the selected text and select copy from the context menu
this is not a bug
this sloppy, poorly tested software
View 1 Replies
View Related
Mar 20, 2008
I tried SQL mirroring in beta 1 , then it was gone, until SP1.
Now I can not setup mirror, it is fine if it is just hard to setup, but it seems it is full of bug! The mirroring has to be stable, since I am trying to mirror product db, what a diaster if something goes wrong.
I am trying two servers, both has 9.0.3042. First I tried to setup on my home machine, I VPN to my network, After I config security, I see two connection strings:
TCP://sql8.mydomain.netsql2005:5022
TCP://sql5.mydomain.netsql2005:5022
and I click start mirroring, then I got error - Alter failed due to invalid connection string. Hard to figure it out, right?
Then I tried the same thing on a server in the network, this time I get
TCP://sql8.mydomain.net:5022
TCP://sql5.mydomain.net:5022
and it doesn't show that error anymore, I am not sure why the connection should be like the latter format, but in anyway, how come SMO can not make it right?
then I get another error, SQL server doesn't exist or can not access, I search on the Internet, it seems that error could mean anything, include that the mirror db is not in restore mode.
But I did set the mirror db in restore mode and both sql5 and sql8 are under same domain, pysically close.
So what else I can check?
Any suggestion?
thanks
View 5 Replies
View Related
Apr 6, 2006
There are four limitations or apparent bugs I have experienced in 2005MS. Two I know are for real.Two real limitations/bugs --1. Can't edit table-valued function.2. Can't get nulls to be missing (blank) in text output paneTwo more I just encountered, and am wondering about --3. DB->All Tasks->Import Data->Load CSV file (exported from Excel) ->garbled table as some rows end up being extra columns. The samespreadsheets load okay from XLS format.Table should have shape A, instead has shape B:A B|...| |...||...| |...||...| |......||...| |......||...| |...||...||...|4. SET NOCOUNT OFF has no effect after SET NOCOUNT ONIs there a way to work around these, or are they real bugs?
View 4 Replies
View Related
Oct 10, 2007
I am getting incorrect results from my paging query, where the same results are being returned multiple times. Here are two queries I have found to bring the same results:select top 20 * from lookupdocuments_dbv where catname_cst='MyCategoryName' and (docid_cin not in (select top 620 docid_cin from lookupdocuments_dbv where catname_cst='MyCategoryName'))select top 20 * from lookupdocuments_dbv where catname_cst='MyCategoryName' and (docid_cin not in (select top 640 docid_cin from lookupdocuments_dbv where catname_cst='MyCategoryName'))When I remove the catname_cst where clause it brings back results properly (i.e. records 622-642 and 643-663). What is wrong with my where clause that is causing identical data to be returned?
View 8 Replies
View Related
Dec 8, 2006
I was creating an SSIS package, seemingly simple. One of the tasks I needed to do involved copying our production database to a seperate DB instance for staging. I wanted an SSIS package that would stage production so we could push and test changes.
My first problem is that I tried to create a simple Transfer Database task. When I tried to run the task, I got an error stating that our Stored Procedure, DtsRun, could not be scripted. It's an encrypted stored procedure.
A little annoyed, I decided that I'd do a transfer SQL objects instead. Now I don't want to hard-code my objects to xfer based on the current schema and edit this SSIS script every time we make a DB change; I just want it to copy ALL objects except for my encrypted proc. I'll just build a list with with another task.
I decided that I'll write a script that generates a list of proc names, and I'll pass that to the Copy SQL Server Objects task. Well apparantly I can't assign a collection value with a script. I have to create ANOTHER package that modifies THIS package because (1) The entire package isn't exposed to the script task and (2) object variables can't be used in expressions.
Am I missing something? So because I use a single encrypted stored procedure, I have to write 2 fairly complex packages to copy my database? That's just stupid. I can understand if SQL can't move the encrypted package while the database is online. I could deal with that. But the extremes I have to go to JUST to copy my database are truly rediculous.
I was really excited about SSIS, but I've been really dissapointed. The performance of the designer on my machine is really poor (I have a Core T2700 with 2GB RAM). Just about every error message I've gotten, both design-time and run-time, I've had to google because they're so obscure. And if you can only store blittable types and strings in variables, that severely limits the functionality of a package (without going to programmatic extremes).
Most of all, I'm really dissapointed in the expression system, If the CLR is loaded into the SSQL/SSIS runtime, then why am I coding it using ANOTHER proprietary coding syntax???? I thought .NET was meant to keep people from having to redesign the wheel???
Microsoft is constantly pushing C#, yet I can only script in VB.NET, which means I now have code-bases in different languages.
Overall, I'm really dissapointed with SSIS. The usefulness of the added functionality in SSIS packages is shrowded by the massive list of nuances.
View 8 Replies
View Related
Feb 21, 2007
Hello guys,
We have customers that are using web synchronization. Could you, please tell us when service pack for the bugs, discussed in thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=689428&SiteID=1 will be reliazed?
What replication participants should apply the service pack in a configuration where Subscriber (MS SQL 2005 Express) gets synchronized with Publisher/Diustributor (MS SQL 2005 Standard)?
Thanks.
Alexander.
View 3 Replies
View Related
Jan 22, 2004
Hey!
Has anybody here had any issues with the MS03-031 security patch and SQL 2000 on Windows 2003?
We recently installed this patch on one of our test SQL 2000 machines, and the performance of queries running on this machine have gone up (gotten worse) by at least 10X.
We use indexed views and all queries are run with WITH(NOEXPAND) to force the indexed view to be used.
Anyway, after the patch was installed, the queries on the indexed view will ONLY use the clustered index, and not any of the other indexes, causing a Clustered Index Scan.
I removed the patch (well, re-installed SQL) patched it up to SP3a, and performance is back to normal.
Anybody experience anything similar?
Paul
View 4 Replies
View Related
Apr 24, 2007
Hi,
Does anyone know of a link or list that has all the parameters for the "rs:" section of the URL access parameter, except for the ones in the Microsoft books?
Thanks,
View 1 Replies
View Related
Sep 3, 2015
Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012
My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?
if not what code changes we should do?
View 3 Replies
View Related
Sep 12, 2007
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
The developer PC is Windows Vista Business.
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
Thanks!
-ErikR
View 4 Replies
View Related
Oct 25, 2007
Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?
I really appreciate your help on this.
Thanks,
Sam
View 6 Replies
View Related
Mar 11, 2008
I did a quick Google for this but found nada...
If I develop a report in SSRS 64 bit, can it be ported to a 32 bit installation? Any issues?
I will do my own testing, but I was curious if anyone else had experience doing this.
View 1 Replies
View Related
Jun 3, 2008
send me some procedures to test reports in ssrs (sql server 2005)
sunil
View 3 Replies
View Related
Jan 14, 2008
Hi,
In a .net application there is a link that brings up a SSRS report.
I have noticed that if it is the first time this report is requested i.e. Application has just been opened and the report button is clicked, then it takes a while to get this report to appear on the screen. But if this report is requested again (i.e. for the second time or more) then it only takes a few moments for the report to appear on the screen.
So it seems that only the first time the report is requested it takes a longer time to get this report. Is there a way to reduce this initial load of the report?
Thanks
View 3 Replies
View Related
Nov 12, 2007
Can anybody give share with me how to establish the basic connection between SQL Reporting Services and Great Plains 9.0? They are on two separate servers if that makes a difference.
Dennis.e.graham@hotmail.com
View 3 Replies
View Related
Aug 13, 2007
Hi. We currently have about a 100 Crystal Reports with embedded images and text in the *.rpt files. If we were to switch to SSRS 2005,
Can we do a global search-and-replace of images and text within the SSRS reports? We have some letterheads that have names of people who might change every year or two.
Are there any tools to convert Crystal Reports *.rpt files to SSRS reports? These 100 reports would be time-consuming trying to convert to SSRS.
Thank you much
Alex
View 2 Replies
View Related
Mar 6, 2006
Hi Guys
I have an ancient app that produces a pipe delimited file for the printing of certain invoices (which i can present in reporting services). I am able to fire a batch file or script from this able and pass the name of the file through to the script...
My question is: is it possible to have the stored procedure fire a DTS pkg to "massage the data" before running the report?
Has anyone had any experience doing this or other ideas i could try. i'm using SQL2k
TIA Stephen
View 4 Replies
View Related
May 21, 2008
hi guys,
In ssrs i have two rows, The two row i have to design in to vertical, how to do?
anybody plz help me
View 3 Replies
View Related
Feb 14, 2008
I had a potential client ask if SSRS would work with a vpn connection if someone is off site. Does anyone know if this will work?
Thanks,
Ryan
View 6 Replies
View Related
Sep 3, 2007
Hi,
I want to get five tables of a report to be repeated on different sheets of excel based on a variable.
Thanks in Advance.
Nalini
View 5 Replies
View Related
May 20, 2008
I have a stored procedure wihich returns the table like
class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
022 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120
041 $120 $110 $100 $80 $150 $120
006 $120 $110 $100 $80 $150 $120
002 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120
i want to display a report in SSRS in two groups 1st group (001, 021, 003, 005) there is no 022 in this table where in another group (006,036) there is no 002. it should display as follow with the total of sales
class sunday monday tuesday thursday friday saturday
001 $120 $110 $100 $80 $150 $120
021 $120 $110 $100 $80 $150 $120
003 $120 $110 $100 $80 $150 $120
005 $120 $110 $100 $80 $150 $120
total 480 440 400 320 600 480
class sunday monday tuesday thursday friday saturday
006 $120 $110 $100 $80 $150 $120
036 $120 $110 $100 $80 $150 $120
total 240 220 200 160 300 240
in the Dataset of SSRS i can see only class, sunday,monday,tuesday,wednesday,thursday,friday,saturday.
plzzzzz help me how it is possible in SSRS or any other sujjestion. it will be appreciated... Thank u all in advance...
View 3 Replies
View Related
Jan 7, 2008
hi
we bought ss2000 std ed in 2003.
how can i get ssrs 2000? is it a free download?
thanks
evan
View 5 Replies
View Related
Sep 26, 2007
Hello
I am going to Intsall SSRS on Cluster load balanced web servers. Shall i install SSRS on both nodes? When i go to msdn, the caption as:
"You must use other products to support access through a virtual server and cluster deployment. Reporting Services does not provide load balancing functionality or virtual server features that allow you to access all report server instances through a shared URL address."
I have my vip and virtual url ready for installation. how can i install SSRS in high availability? please advice. Thanks.
View 3 Replies
View Related
Apr 4, 2008
Hi All,
I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.
Thank's in advance..
View 2 Replies
View Related
Apr 10, 2008
Hello everybody,
I'm new to SQL,I have a interview tomor,so please i need a website from where i can get questions related to SSIS & SSRS.Please help me.
Thanks in advance
View 3 Replies
View Related
May 11, 2007
How it is possible to Run (2 or 3)Reports(SSRS) From SSIS With Default Parameters ? Please Help Me Out
Praveen John
Software Engg
Regards
Praveen John
+91-9895074288
"Frankly, my dear, I don’t give a damn"
View 1 Replies
View Related
Sep 5, 2007
I'm trying to set up the Report Manager Virtual Directory. But the little X just wont turn into a tick - even though I click New, then OK, then Apply.
Has anyone else had this problem?
I've managed to get SSRS running before but for the life of me I can't get it going! So annoying! Does anyone have a link to a simple Walkthrough or something for getting SSRS of the ground so that when you navigate to http://localhost/reportserver, you don't get "The Page can not be found".
View 2 Replies
View Related
