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 2006 > threads for thursday may 4

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

Adding extra parameter to my report doesn't work.
Posted by siphonalfusion at 5/4/2006 3:29:27 PM
I have a problem in RS 2000 where when I add another parameter to my current two it doesn't work. I've tested the procedures in SQL and when declaring the datasets. The two parameters I have are: "Report_Date" and "Project_Name". The one I add is called "Cap_Num". I've modified all the existi...more >>


Export Button greyed out
Posted by BI_Guy at 5/4/2006 2:19:02 PM
We generate a Reporting Services Report when we try to export it we find the button is greyed out. After playing with the drop down it becomes enabled. We are using Reporting Services 2000....more >>

webforms.reportparameter vs myWebServer.reportparameters
Posted by Sean at 5/4/2006 2:01:02 PM
dim params1 as new microsofot.reporting.webforms.reportparameters dim params2 as new myReportingService.ReportParameters params1.values ' this property exists params2.values 'this property DOES NOT exist in this context, only .defualt values. I need access to myReportingService version...more >>

RS2000 Large report fails to export to Excel
Posted by SBishop at 5/4/2006 1:44:01 PM
I have large report (200 pages, landscape 14x8.5) that will not export to Excel. Last night we scheduled the report to email us the Excel rendered file. The subscription page shows the following error. Failure sending mail: Exception of type Microsoft.ReportingServices.ReportRendering....more >>

function to return multi-selected values?
Posted by MJT at 5/4/2006 1:01:02 PM
Is there a function to return the multi-selected parm values in a comma delimited string? Using RS2005. dataset1 is the source of a parameter I'll call STORE. I have this defined as a multi-select parm. Getting error (cannot add multi value query parameter 'STORE' for dataset 'dataset2' be...more >>

RSActivate - how do I run it successfuly?
Posted by DragonVic at 5/4/2006 12:05:02 PM
I am getting an error... "The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated)" I went to the MSDN site to find a fix... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.a...more >>

Command Type for dataset using Custom Data Processing Extension
Posted by Thomo at 5/4/2006 10:20:11 AM
Hi, I'm writing a custom data processing extension, but I cannot get anything other than a command type of "Text" in the dataset for the report I have setup to use the Data extension I have written. Does anyone know what or where the available command types are derived from? Greg ...more >>

Two issues with Report Builder
Posted by jhcorey NO[at]SPAM yahoo.com at 5/4/2006 10:15:18 AM
I'm not the one building the cube, so hopefully I'll explain this correctly. 1. When I select a cube for my report, in the Entities box I see the sources for the dimensions and facts used to build the cube. When I go to select some facts, I don't see calculated fields. If I'm in Reporting...more >>



Image Sizing
Posted by IanP at 5/4/2006 10:06:02 AM
Hi I have done some research re image sizing and have not been able to confirm if the following be done. Has anybody had this type of request and solved it? .. Logo to display on the page in specific place, limit the image size to a width of 4cm wide or 2cm high. whichever dimension ...more >>

SSQL Reporting Services 2005 Only Admins can see reports
Posted by Bigasg NO[at]SPAM gmail.com at 5/4/2006 9:24:45 AM
This seems to be a common problem as I see mentioned all over the place, but I can't find a resolution. Please help if you can... The problem is that after opening up all permissions (iis, system directorys, individual reports, setting all ids to sysadmin on database) the domain user group I...more >>

always display 10 major gridlines for y axis in graph
Posted by GearĂ³id at 5/4/2006 9:23:21 AM
Hi, I have graphs where I can never be sure of the range of values that will be displayed. How would I set it to show 10 major gridlines on the y axis?? I tried setting the interval to 0.1 but this ovbiously didn't work as the graph shows monetary values? And I can't set an explicit interv...more >>

Tabluar Report grouping and header
Posted by Deepak at 5/4/2006 8:54:01 AM
I have a report with 16 columns in the landscape format. 1.) Is there a way I can add two rows in the table header so that my columns names will not be in two or three lines. 2.) Is there a way to not to let the grouped columns header to repeat for each row. Thanks Deepak...more >>

Spaning multi-column report
Posted by Aaron at 5/4/2006 7:58:02 AM
I have setup a two column report. I need to insert a rectangle that spans both columns near the middle of the report. How can I accomplish this? Thanks, A...more >>

Hide Parameters passed to drillthrough report
Posted by sachin laddha at 5/4/2006 7:45:46 AM
hi, Is it possible to hide parameters passed to drillthrough report? If yes, How? regards, SAchin. ...more >>

Would like to show resolved MDX query syntax
Posted by jhcorey NO[at]SPAM yahoo.com at 5/4/2006 6:42:22 AM
I'm using RS2005 with an AS cube. The query for the report is MDX and contains some parameters. This is all generated by RS. I would like to see what the MDX looks like at run time, with the parameter values plugged in. If I could simply display this from an expression in a textbox, then th...more >>

csv/xml exporting table columns where visible property is being us
Posted by Russ Heath at 5/4/2006 6:19:02 AM
I have a SqlServer 2000 Reporting Services Report that we set the visible property of a table column to true/false using a function that evalutes certain conditions. Even when the column shows up in the report when exporting to CSV and XML it does not show up! Is this a known bug and is t...more >>

List page breaks problem
Posted by Woodgnome at 5/4/2006 6:01:02 AM
Hi, I have set up a simple report containing a list region. Within the list I have the following components : TextBox1 : "Page1" Rectangle : TextBox2 : "Page2" Rectangle TextBox3 : "Page3" Page Footer contains a textbox with "Footer Text" I have selected the "page break after" check...more >>

textbox lineheight in sql2000 reporting service
Posted by Pony Tsui at 5/4/2006 5:56:01 AM
i try to change the lineheight in textbox, but nothing happing, is this property do not effect in chinese version? i use the vs2003, thanks -- Pony Tsui...more >>

Pathing Error: Subreport(s) could not be shown
Posted by RobKaratzas at 5/4/2006 5:25:02 AM
Hi Folks I have a working report with 5 additional subreports on my PC. Also, works fine on the development server. The issue is with PRODUCTION. Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION. Can anyone tell me if suppling the 'path' in the main report .rdl ...more >>


DevelopmentNow Blog