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 friday may 5

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

Using query parameters in a Case statement
Posted by Denise at 5/5/2006 5:18:01 PM
Hello I am using Reporting Services within Visual Studio .Net 2003, connecting to a SQL Server 2000 database. I am trying to use a query parameter within a Case statement but am getting a syntax error. The query is as follows, with the @StartDate parameter in the second 'Quarter' case sta...more >>

formatting textboxes
Posted by dataGirl at 5/5/2006 2:51:02 PM
I am rendering a report in VS 2003 and I need to know: 1) If it's possible to combine two different text formats in one textbox? Sample database field = Notes.description I want to be able to manually add the word "Notes: " (which I want to be bold) in front of the data that's in the Notes...more >>

VS2005 ReportDesigner consistently crashes
Posted by Elliot Rodriguez at 5/5/2006 2:34:01 PM
For some reason, whenever I include a sub report in a table control, VS2005 *always* crashes. It crashes when I attempt to preview the report and I am waiting for the parameter textboxes to show up. They never make it. They simply crash, and the Preview window reads "an error occurred durin...more >>

WMI Provider Error
Posted by tao_benz NO[at]SPAM hotmail.com at 5/5/2006 2:03:52 PM
I am new to Report Service and got the following errors. After I unistalled the Report service, the Configure Report Server still there. When I launched the Configure Report Server it says "An unknown error has occurred in the WMI Provider. Error Code 80040219" I reinstall the Report service ...more >>

Licensing issue
Posted by moonsuncool NO[at]SPAM gmail.com at 5/5/2006 12:04:43 PM
We do not want to install IIS on our database server to run Reporting Services. As I understand that if RS is installed on a seperate server, an additional SQl Server license is required. This will be pricey! Are there any other options available? If we install IIS and RS on the database se...more >>

Jump to report - ERR - One or more data sources is missing credent
Posted by MSSQLServerDeveloper at 5/5/2006 11:30:02 AM
I have a chart where I want to jump to a report when the user selects a certain piece of the pie. In development, this works fine. ALSO from the report viewer the report being JUMPed TO works fine individual, but when I try to jump to it from the chart, I get the error, "One or more data sou...more >>

Unattended Install
Posted by JoeVB at 5/5/2006 10:07:02 AM
I have been having trouble with the unattended install. I created a INI file based on the template provided but in the MSI logs I get an error: Licensing information is not correct. Please pass in a PERPROCESSOR or PERSEAT. In My INI file I have: PERSEAT=50 (along with all the othe...more >>

Opinions on Organizing - Solutions and Projects
Posted by WonderingFool at 5/5/2006 8:38:02 AM
How are you organizing your solutions and projects? Are you creating a new solution for every 'group' of reports? I am starting to wonder if I am getting too granular and will have problems later on locating the reports. All my reports have the same shared data source. Right now, I am cr...more >>



Fixed Headers in RS 2005
Posted by kelkoenig NO[at]SPAM gmail.com at 5/5/2006 7:58:18 AM
I've been playing around with RS 2005 for a few days trying to validate the new features/enhancements with it vs. RS 2000. I'm looking at the Fixed Headers enhancement and wondering if I'm doing something wrong. I set the table property of 'Header should remain visible while scrolling' and the ...more >>

errors in rssrvpolicy.config
Posted by taz at 5/5/2006 3:24:01 AM
i was tweaking the <CodeGroup> sections in rssrvpolicy.config last week and seem to have corrupted something. i get 100 errors as below. can anyone please help (or send me a default-install version of the file). thanks. t. --- Could not find schema information for the element...more >>

Installation Of SSRS
Posted by SSRS NEW at 5/5/2006 12:32:01 AM
I have two machines on a network (Machine A and Machine B). Machine A has SQL Server and IIS installed on it and Machine B is the web server. Machine B does not have Sql Server. Is there any way by which I can upload my .rdl files on Machine B ie; create the virtual folders (Reports and Re...more >>

expression question
Posted by angi at 5/5/2006 12:00:00 AM
Hi Dose "Expression" can write any syntax such as CASE... WHEN... Structure? I have a serial code such as B1, B2, B3. When B1, the "jump to url" to http://b1.aspx. B2 the http://b2.aspx I wirte this use IIF now but feel this way dosen't make sense. So is any other way can instead of IIF? Tha...more >>

how can i Assign 2 data sets for a single table in RDL file
Posted by mur via SQLMonster.com at 5/5/2006 12:00:00 AM
hai, my requirement is : in tabular reports , i need to Assign data fields from dataset 1 to Table Header row and ,for details row i need to Assign data fields from dataset 2 is there any way to assign multiple datasets to Single Table? . if yes could you please tell me how to assign ...more >>

SQL Server 2005 Reporting Services to ORACLE OLAP databases ?
Posted by Ernestas Sysojevas at 5/5/2006 12:00:00 AM
Hello, Do anyone know or maybe have experience there IS or NOT possible to connect with SQL Server 2005 Reporting Services to ORACLE OLAP databases ("Oracle Express" or "ORACLE OLAP") and make reports from Oracle OLAP cubes? Ernestas Sysojevas ...more >>

layout problem
Posted by angi at 5/5/2006 12:00:00 AM
Hi, I have 4 subreports in a report and adjust thier position well on layout tag. Preview on the report designer everything is fine. But deploy to report server and browse on IE the subreports all on the wrong position! How can I resolve this problem? Thanks for help! Angi ...more >>


DevelopmentNow Blog