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 wednesday may 30

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

long text with blank lines
Posted by Willo at 5/30/2007 7:41:48 PM
Hi; im trying to create sort of a contract in RS, ill get some information from an employee table, but most of the report is plain-fixed text. Im not sure but i think the best way to do it is using only a detail band (ill need to print a contract by employee), and use textboxes for the text...more >>

Changed a parameter to multi-value and now it doesn't work
Posted by Stephanie at 5/30/2007 2:25:00 PM
I have a report with multiple parameters that the user can specifiy before running the report. One of them is a field that the user can type in a value for. It's defined as a string and allows a blank value in the event the user does not want to enter anything. It works fine when not multi-...more >>

Input data
Posted by SurferJoe at 5/30/2007 1:24:49 PM
Are there any mechanisms in report services to accept data on the report form? ...more >>

Change Subtotal background color.
Posted by Scott Burke at 5/30/2007 12:55:03 PM
I created a Matrix report with subtotals. It would be easier to read if the subtotals were shaded. How do I shade the subtotal box. Not the lable box. I can see the box labled totals and it is shaded it is the real total box that I need to shade. Thank you Scott Burke...more >>

Why dont page breaks work???
Posted by Carl Henthorn at 5/30/2007 11:56:02 AM
I have three tables in my report. One for detailed data, and two others for summary info. Since the detailed data table is often thousands of rows long, I have set properties on that table to insert a page break after the table and before the summary tables. When rendered in HTML (preview mode...more >>

Skipping the display of dataset rows in a report table
Posted by mjlinhbg at 5/30/2007 11:56:01 AM
I have a stored procedure which returns three rows from the database into a dataset (two credits, one debit). My report has two tables (on a list); one for credits, one for debits. The list is associated with the dataset. The expressions for the textboxes in the tables contain an "if" stateme...more >>

Sorting in Reporting Services.
Posted by Ram at 5/30/2007 11:21:00 AM
Hi, I have a table in a report which has group based on Name and type. It displays results like Name Type A X B X A Y B Y I want the results to appear with data sorted on names for which i added a sort crtiteria in ...more >>

Unicode export shows garbage in pdf
Posted by Manoj at 5/30/2007 7:08:39 AM
Hi I have SSRS 2005. I have translated all my reports to Chinese and Japanese apart from the English version. When I export the Chinese or Japanese reports in pdf formats it shows garbage characters. The other formats (excel, tiff, html etc.) are working fine. Is this an issue with pdf or d...more >>



Making a row not show
Posted by Ryan Mcbee at 5/30/2007 6:40:06 AM
I have one column that is an expression that either returns a value or returns zero. I would like if it is zero to not show at all. How is this done? Thanks, Ryan...more >>

chart y-axis scales
Posted by farshad at 5/30/2007 6:17:00 AM
Hi, How is it possible to programmatically set the min and max scale values of the Y-axis in a chart? Currently I manually enter values in the Y-Axis scale min/max properties. Thanks...more >>

chart series
Posted by farshad at 5/30/2007 5:49:02 AM
Hi, I have create a report which contains a chart. The series gets populated with the correct data but at the end of each series, there is a text "Series 1" joined to the end of the actual text. How is it possible to make sure the word "Series 1" does not appear at the end of each series line...more >>

Accelerating first call of Reports
Posted by Stefan at 5/30/2007 12:00:00 AM
Hi, is there a possibility to accelerate the first call of a report? It could take up to 1 minute on my Server. After I called a report the first time, its going faster (~5 seconds). Thanks and regards, Stefan ...more >>

Totalling Columns
Posted by Jarryd at 5/30/2007 12:00:00 AM
Hi, At the minute I have a standard matrix style report (pivot table). Is there a way to add totalling columns and rows to the report? It should be possible for the totals hould to be generated in the SELECT statement, but if you can insert columns as totals via reporting services that wo...more >>

Error running rs utility
Posted by _george at 5/30/2007 12:00:00 AM
Hi Trying to render a report using rs utlitlity however I'm getting the following problem The command i issue in the command prompt is: rs.exe -i RenderReport-SalesOrderMarkup.rss -s http://server.com/ReportServer -u Domain\ george -p thepassword -v salesid="SO000644" -t The result; ...more >>


DevelopmentNow Blog