Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > may 2007 > threads for monday may 14

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Master-detail subreports and performance.
Posted by David W at 5/14/2007 11:45:46 PM
If I create a master detail-report using subreports, will a separate query run for each subreport at the time it loads? Lets say I have a report with 500 master rows, will it have to run 500 queries for the subreports before the first page loads? I know there is no on-demand subreport load...more >>


How to stop reporting services deploy
Posted by wozza at 5/14/2007 10:03:52 PM
I am using visual studio 2003 with sql reporting services for sql server 2000. I have a solution with a web application project and a reporting services project. When I start the web application project in the IDE, the reports are automatically deployed to the report server. I would like to st...more >>

Best image format to use?
Posted by Chris Patten at 5/14/2007 3:11:02 PM
I wan to insert our company logo on some of the srs reports, could someone recommend the best format to use? I want the image to look clean when printed as well. ...more >>

ters_such_as_Ä_in_hyperlinks?
Posted by ANeelima at 5/14/2007 2:16:04 PM
I have an rdl file that has a hyperlink. In the hyperlink, I have the following code ------------------------------------------------------------ <Hyperlink> ="javascript:void(window.showModalDialog('" & Parameters!BaseUrl.Value & "/smgr/myfile.aspx?selected=" & Code.StripField("Fields!use...more >>

Needed software for designing reports
Posted by eric.gay NO[at]SPAM gmail.com at 5/14/2007 1:33:06 PM
We currently have SQL 2005 (enterprise) reporting services hitting an odbc based backend (mysql usually). It works great. I run Visual Studio Pro (and have msdn sql server on my local machine), develop reports locally and deploy them. I know the express edition of SQL 2005 reporting servic...more >>

Export to pdf issue
Posted by Phill at 5/14/2007 12:46:01 PM
I have a report with 3 of 9 barcode font. When the report is rendered on pdf format the font is not a barcode. The font is installed on the web server, report server, and the client machine. Has anyone been able to solve this? Thanks....more >>

Matrix Report Again
Posted by John Wright at 5/14/2007 11:44:01 AM
I think I am confusing people with my requests. Let me boil it down to this. I have 19 steps that I want to list on the far left column of the matrix report. Along the top I want to list all the items in my database that are currently at one of these steps. Some steps will not have any ite...more >>

Rephrase my Issue with Pivot Table
Posted by John Wright at 5/14/2007 10:32:13 AM
I have two tables (definitions follow) one called Product, the other called Traveler_Step. The PK-FK link is the Traveler_Step_#. Each product can only be at one step at a time. If the product is done processing the Traveler_Step_# is 0. Not all steps have a traveler at them. What I need ...more >>



Display Multi Value parameter in the report as a field
Posted by Sriman at 5/14/2007 10:09:00 AM
Hi, I would like to show the Multi value parameter values in my report in the title. How can i display all value with comma separated. like If the user selects 4 values of out of 100 , I have to show the report title like "Event Data:comp1, comp2.." Regards, Sriman....more >>

Addtion / Sum of Parameter Array Values - SSRS
Posted by nlulla at 5/14/2007 10:02:36 AM
Hi All, I want to Sum instead of Join Parameter arrays selected values and use it within the report to display data based on total sum of all the values selected. Join concatanates them with comma delimited values but i want sum of all those values. Example as below Value DisplayText ...more >>

Variance on Matrix Report
Posted by mark.humphreys NO[at]SPAM cbg.co.uk at 5/14/2007 8:20:42 AM
I was looking for some help with a matrix style report I am trying to develop. Example, months accross the top, columns would be product grouping, then year. The detail would be a summation of invoice value. I can achieve this no problem. The issue is when I want to get a variance between ...more >>

Percentage of total column in Report Builder
Posted by Jaap at 5/14/2007 12:00:00 AM
Hello, We are the using the end-user tool Report Builder. I want to create a 'Percentage of total' column to a certain table. For example: Value Percentage of total Region A 200 20% Region B 500 50% Region C 300 30% ---------...more >>

Printing a Matrix in Landscape Restarts the PC !!
Posted by Bassam at 5/14/2007 12:00:00 AM
Hello I have a simple report using a matrix data region when i design the report and preview it in SQL Server Business Intelligence Development Studio there is no problem , if i do the following my PC and all PCs i tried on are restarting !! 1. if while previewing the report , a user cha...more >>


DevelopmentNow Blog