Bugs In Subreport
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
ADVERTISEMENT
Nov 3, 2015
I am trying to create a report with a sub report in Sql Server 2012 using Report Builder Version 3. I can run the subreport without any problems. I read where using a shared connection can cause this error so both the main report and the subreport use a connection that is embedded in my report.
For testing, I created the subreport without a parameter and added it to the main report. When I ran it that way, the report worked and sub report displayed the data. So I know it can read from the database.It seems to only give me this error when I am trying to tie the two reports together using a parameter.
View 2 Replies
View Related
Jul 14, 2015
Using SSRS 2014 and VS2013 rc5.
How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.
First, Is this even possible?
Second, How?
View 10 Replies
View Related
Dec 16, 2006
Hi,
I have a report which contains a subreport placed inside a list. when the subreport returns no data. it appears as a blank space in the main report. So i want to suppress the list when the subreport returns no data. Can somebody help me with this?
thanks
shri
View 1 Replies
View Related
Mar 17, 2008
Can we include a subreport which aslo has another subreport in a master report? (assuming all three reports have parameters too)
Thanks
View 4 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
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
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
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
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 25, 2008
I'm having trouble getting a subreport to work inside a main report.
I keep getting this error upon preview:"A parameter in the subreport 'Summary' has the name @DB. Parameter names must be CLS-Compliant identifiers"
Here's a description of my setup right now.
In my Main Report, I have a Year(String) and CompanyCode(string) Report Parameters, with Available Values that I specified.
Right Clicking the subreport, in the SubReport Properties(still on the main report), I specified the subreport I want to use and on the parameters tab, I have two parameters @DB with the value of =Parameters!CompanyCode.Value, and @Yr with the value of =Parameters!Year.Value
In the Subreport, the Dataset has 2 parameters, @DBName and @Year
On the Layout section, the Report Parameters are the same as the main report.
I do not have a dataset on the main report because it's not needed, I basically only need it to pick between either the Detail and Summary sub-reports to show.
Any help on this would be greatly appreciated, I'm still pretty new to SRS, but I'm learning quickly and have picked up a lot, some things I still struggle with.
Thanks!
View 3 Replies
View Related
Feb 13, 2007
Hi guys, I am new to Rs2005. I have created 4 seperate reports that each use their own datasource. I want to display these 4 reports as 1 big report. I want a title page followed by a summary page. The summary page must include the 4 reports within its summary, ie...report 1 on page 3, report 2 on page 5 etc..... The page numberering must also match up. Therefore page 1 is the title page and page 2 is the summary. If this is possible, how do i reference the report names within the same report to display on the summary page. Can this be done? I will very much appreciate your help.
View 1 Replies
View Related
Dec 20, 2005
SQL Server DB; using Access ADP frontend; i have a report that shows companies; and a subreport that shows all the employees for that company and the committees they serve on.
There is a one to many between Committee and MemberContact
Committee
Marketing
Customer Service
Membership
I would like to display in a subreport info like this
Joe Blow - Marketing, Customer Service
Jane Blow - Membership, Marketing
Which is a concatonation of the fields on the one side of the relationship.
Possible? help appreciated.
View 1 Replies
View Related
Oct 4, 2007
Dear All
I have 2 report. one report master and the other is detail report.
i have this record
NetSales 1000
-------------Gross 1200
-------------Discount 200
Contribution 1 800
-------------zzzz 100
-------------yyyy 100
Contribution 1 is Netsales-zzzz-yyyy. in my cube i use customrollupcolum. so that in pivot table this condition is no problem. but in the RS is problem.
so, in RS i use 2 report. one report as master define group1 (NetSales, Contibution 1). and the other report as detail of master report. so i use subreport in the table in master report. but the parameter in the sub report cannot handle value parameter from table (netsales,contibution 1).
how can i do that
thanks
View 2 Replies
View Related
Nov 16, 2007
Hello,
I need to sum up a sub-report value, but I don't know the syntax to reference the subreport.
How do I reference a subreports value to sum it up?
Thanks,
View 7 Replies
View Related
Aug 4, 2006
I want to combine a bunch of reports (which are stand alone reports on there own) as subreports in a parent or master report. We have done this in Crystal Reprots in order to get a group of reports out in one file.
The issue with Reporting Services is the header and footers of the subreports are not rendered, so I have to repeat the logo information for each subreport in the body of the parent report. I can do this in a table or list or rectangle, but I have to do this for each subreport. Is there any way that I can specify the name of the subreport at runtime? That way I can put everything into a List and drive it from the database. I noticed that the dropdown to select the report name does not allow you to create an expression for this field.
View 3 Replies
View Related
Jul 31, 2007
Hi,
Can anyone tell me how to get a scrollbar inside a subreport.I'm using SQL Server 2005 Business Int. Solution.I'm having more than 1000 rows for a subreport.I want to fix the width and hieght of the subreport so that i can get a scrollbar in the subreport.Please, help me regarding this.
Thanks,
Saradhi
View 3 Replies
View Related
Jun 26, 2007
We have a strange problem. We have a grouping that returns summed values in textboxes (in the group header) and the last column includes a subreport. When we run the report, the textboxes in the group returns the sums, however the subreport displays "No Rows Returned" as that is the parameter value for NoRows. However, we know that there should be some rows in the subreport as when we preview that report using the same parameters, it displays properly.
Just for fun, we created a new group header (using the same grouping level) that included nothing except for that subreport and when we preview the report, it properly shows the subreport values.
What could be wrong here? And thanks for the information.
View 1 Replies
View Related
Mar 3, 2008
I added an action to a date field in a table that jumps to a report. Is there any way to overlay this report over the current window without clearing the screen and showing the report on a new page? That seems extremely UN-windowslike. I can't add it as a subreport and then conditionally make it visible because I'm using the date field as a parameter for the subreport.
Thanks.
View 9 Replies
View Related
Aug 23, 2007
I get an error "Error: Subreport could not be shown." when I set subreport rendering from snapshot. When I render subreport with the most recent data everything works fine.
Does anybody know how to use snapshots for subreport? Thanks in advance.
View 1 Replies
View Related
Apr 13, 2007
Hello:
I have a subreport in a group footer in a table and when I set the subreport property to hidden the report prints fine however, when I set the subreport property to visible it appears to overlay a portion of the data in the prior rows and it overlays some of the data in the rows that follow the subreport.
Has anyone come across this situation?
An example of my report with and without the subreport follows:
** Example of Report without Subreport **
DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE
1361 AL BALDWIN COUNTY 0913 03/29/2007 06/01/2007
COPYING SERVICE
1918 2HSC $164.00
2971 2HSC $164.00
MAILING SERVICES
1918 2HS $124.00
2971 2HS $124.00
DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE
1658 AL MOBILE 0913 03/29/2007 06/01/2007
COPYING SERVICE
1918 2HSC $164.00
2971 2HSC $164.00
MAILING SERVICES
1918 2HS $124.00
2971 2HS $124.00
** Example of Report with Subreport **
DIR # ST DIRECTORY NAME PUBCO CLOSE ISSUE
1361 AL BALDWIN COUNTY 0913 03/29/2007 06/01/2007
COPYING SERVICE
1918 2HSC $164.00
2971 2HSC $164.00
MAILING SERVICES
1918 <----- The subreport appears to overlay the data
2971
** SUBREPORT WILL PRINT HERE AND IT PRINTS AS EXPECTED **
<------ The directory information is overlayed
COPYING SERVICE
1918 <----- The subreport appears to overlay the data.
2971 It continues this way throughout the report.
MAILING SERVICES
1918
2971
View 1 Replies
View Related
Apr 17, 2007
i want to display the reportheader and footer of a sub report from master report eventhough there is no data is populated for subreport.
View 1 Replies
View Related
Sep 12, 2006
Greetings,
I have a report which contains three subreports. Each subreport is contained within a rectangle in the main report so I can force a page break after each subreport. In each of the subreports, there is a graphic and a text box on one line, then another text box below those two items, then a table below all that. My problem is that if one of the subreports returns no data, it is resulting in a NoRows sort of situation and not even the graphic and the two text boxes are shown. I understand that you can set a NoRows message, but ideally, I want my NoRows message to be the graphic and the two text boxes, not a plain text message.
I'm not sure if this is even possible or at the very least if I could conditionally force a page break in my rectangles based on whether one of the subreports returns a NoRows situation.
Thanks In Advance
View 6 Replies
View Related
Apr 29, 2007
Hello,
I'm doing a report with six subreports, I would like to put a scroll bar in the subreports to keep all of them with the same size. Anyone knows if it's possible ?
If someone could give me some tip, it will help me a lot.
Thanks.
Maurício
View 3 Replies
View Related
Jan 18, 2007
Hello,
I got a report with a landscape format, and inside it i got some subreports, but two of them are subreports with matrixes. Those two subreports are making the page to be printed into 2 pages, but the second page is always empty, is there a bug, a misconfiguration or misusage of the subreport?
Because instead of having 42 pages i will have two times more. How can i avoid this?
Using borders i noticed that it is the subreport that grows much more than when it is generated individually, since individually it fits in one landscape page, as a subreport it needs 1, 5 that makes it 2 pages, and the last one always empty
Thank you
View 5 Replies
View Related
Jul 17, 2007
Dear friends,
I'm getting an error when I add a subreport in a main report and using paramters...
The error is:
"Error: The SubReport could not be shown"
In the data tab of subreport I insert the parameter, and in the main report I select the subreport and add the parameter...
Someone knows what's the problem?!
regards!!!
View 5 Replies
View Related
