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 > october 2005 > threads for wednesday october 26

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

converting reports
Posted by HSalim[MVP] at 10/26/2005 9:03:13 PM
Hello. Any one know of a utility to convert reports from Access and Crystal into SRS? Thanks in advance for any input Regards HS ...more >>


Update Parameter Value based on another parameter being changed
Posted by Kezza at 10/26/2005 7:39:03 PM
Hi All I have to parameters they effectively offer 2 methods of finding the same kind of data. First the id, second the employee name (with the id as the value) If a user selects an id then I would like the second parameter's value to reflect the change(jump to the same record so that they ...more >>

vbNewLine bug -- please provide a workaround
Posted by davedave at 10/26/2005 7:08:02 PM
If I set the value of a textbox to =vbNewLine & vbNewLine & vbNewLine & 12345 & vbNewLine & vbNewLine & 67890. then I would expect it to be rendered as -- blank line -- -- blank line -- -- blank line -- 12345 -- blank line -- 67890 but instead, when rendering to PDF, it comes out as 12...more >>

Generating reports dynamically
Posted by IP at 10/26/2005 6:10:02 PM
I am new to reporting and Yukon and trying to understand reporting services. I am trying to determine if it is possible to define reports programmatically and send them to a yukon server (or SQL server 2000) and have it generate an Excel report and place it at the specified location on the f...more >>

rs:about the Scope parameter of a aggregate function
Posted by aoeabc at 10/26/2005 4:44:02 PM
A valid scope is the name of a grouping, dataset, or data region. Only groupings or data regions valid scope is the name of a grouping, dataset, or data region. Only groupings or data regions . the meaning of data region? for example?...more >>

Perform aggregate against group value
Posted by SevDer at 10/26/2005 4:36:13 PM
Is there a way that I can perform my aggregate function agains the value in group row instead of details row? Because I do not show numeric values in the details but group row. -- SevDer http://www.sevder.com A new .NET Source For .NET Developers ...more >>

Report subscription execution order in a schedule?
Posted by Susan at 10/26/2005 4:18:29 PM
When a schedule is triggered are the subscribed reports all executed immediately or sequentially? ...more >>

Specifying Parameter Default value as NULL
Posted by pmud at 10/26/2005 3:00:05 PM
Hi, In the parameter properties dialogue box, i want to set the Default Value of a parameter as null. how can I do that? I tried = Null in the Default value. But that didnt work. Any help is appreciated. Thanks -- pmud...more >>



ice…
Posted by NotCpiP at 10/26/2005 1:47:14 PM
Just find out that for small size table, reporting service works fine. When the size/total record of the table is increasing, the display process becomes slower and slower. I managed to trace it and find out that in my case, 300,000 records consumes more than 2 minutes for the report manage to...more >>

RS 2005 - Paraemeter "Groups"
Posted by Jason L Lind at 10/26/2005 1:11:04 PM
Hi, I am investigating moving one of my client's reports from ASP 3.0 based to RS 2005. Many of their reports have Paremeter "Groups" such that a report can be displayed by entering a daterange, a week number or a month. The stored procs are designed to only take the daterange paremeters and t...more >>

EXPORT TO PDF - double lines won't export
Posted by krister tidics | FOX IT at 10/26/2005 12:58:07 PM
Has anyone seen this before: if you set the borderstyle for any cell to double, when you export to PDF, it appears as a single line. Is there a work-around for this, aside from a adding another row? These are pretty complicated reports, and I don't want the added overhead of managing the visibil...more >>

ReportViewer control and scaling issue
Posted by Keith at 10/26/2005 12:30:02 PM
When using the reportviewer control on a web page, we would like to set the width and heighth to a percentage of the container that it is placed in. It appears that the defaults are 400px. Of course these can be changed, but you may experience horizontal and/or vertical scroll bars or a wind...more >>

Enable parameter selection
Posted by Alex at 10/26/2005 11:38:03 AM
I have two reports. On Report1, I have a hyperlink action that brings up Report2, passing the required parameters it needs. But when Report2 is shown, I don't have the ability to change the parameters, E.g. in Report2, I have a parameter in a list with a Show\Hide options. When getting redirec...more >>

Optimizing Reports
Posted by Weston Weems at 10/26/2005 9:47:45 AM
I've got a report thats somewhat time consuming that runs on my reporting server, and what I've found is that if I select anything more than a few months in my daterange parameters, its like 5 minutes to run. What I'd like to know... Can I snapshot a years worth of default data, and have t...more >>

My browser times out after 30 seconds; others don't
Posted by Bob at 10/26/2005 9:38:41 AM
I have several reports on a Reporting Services server. Most reports take less than 30 seconds to download to my browser - I can see them fine. One particular report takes a minute to download - others can see it, but my browser times out after 30 seconds. I get the message: "The page you are ...more >>

RS 2005 with other browsers?
Posted by Ross at 10/26/2005 9:17:59 AM
Hi all Can anyone report on how well the early releases of RS 2005 works for browers other than Internet Explorer, especially FireFox? This was the main thing that prevented us using RS behind our customer portal website. I'm not so concerned about the toolbar etc but more the html for rel...more >>

Formatting a string from the code
Posted by chalexan at 10/26/2005 9:15:02 AM
I have a textbox that displays the amout of free disk space in megabytes. I'm working on converting it to gigabytes and if it's less that one gig, I want to display the string "Critical" bold and in red. Can this be done? Thanks....more >>

font color inside bar graph
Posted by chalexan at 10/26/2005 9:12:21 AM
Is there a way to change the point lable color of the font if it's inside of the chart beside a bar? I have a chart that shows the percentage of disk space free. Once the chart gets less that 25% it runs out of room to put the point lable percentage beside the bar so it puts it on the bar. ...more >>

chart control
Posted by Bill at 10/26/2005 9:12:04 AM
I would like to set some of the properties in the chart control at run time from the database. Is there a way to set the properties at execution time?...more >>

Installation - Only help file installs, No virtual directories or
Posted by K M Dhariwal at 10/26/2005 8:36:06 AM
Hi, I am trying to install Reporting Services on Windows 2003 server (with no service pack). Initially it says Visual Studio is not present which is fine, i press next, then it goes into installation and there are no prompts for rs components, sql database creation etc. once installation is f...more >>

Move Reporting Services Web Installation to another Web Server
Posted by Paul Ennamorato at 10/26/2005 8:03:02 AM

Setting Parameters
Posted by Chris Tollisen at 10/26/2005 7:44:06 AM
In the Parameters section of Report Manager you can specify a default value for a parameter and then uncheck the prompt user box so the report always runs with that parameter. Can this functionality be set in the Report Designer or does it require manual intervention every time? Hope someone...more >>

Support for Mac / other browsers in 2005 version?
Posted by TNS at 10/26/2005 6:53:26 AM
We are currently considering basing a new project for a large client on SQL Server 2005 and Reporting Services. But a large number of the users have Mac's. Will they be able to view and create reports? I haven't been able to find any info about what is supported on Mac and in other browsers than...more >>

Q: SP2
Posted by JIM.H. at 10/26/2005 6:10:07 AM
Hello, Is RS service packs cumulative, meaning can I just directly install SP2 without SP1? Thanks, ...more >>

Should I use Reporting Services?
Posted by Peter Wong at 10/26/2005 12:36:02 AM
Hi there, I have been asked to rewrite some Access forms which generate reports into 'ASP.NET' technology. There is a current ASP.NET system in use with a SQL Server 2000 database. The Access forms connect to the SQL database along with its local tables, so it would be best to remove the Acces...more >>

Sum of all groups, which scope?
Posted by SevDer at 10/26/2005 12:00:00 AM
Hi, I have a situation as follows TABLE Header1--------------------- Header2--------------------- GROUP1 MoneyValue1 MoneyValue2 OtherValues Details someotherValue1 someOtherValue2 GROUP2 AnotherValue Footer The output is as follows TABLE NAME No Heading11 Heading...more >>

Drill Down - VS ok - Report Server not ok
Posted by Kim Ellis at 10/26/2005 12:00:00 AM
I have RS reports which when run from within Visual Studio, work perfectly. When deployed to the Report Server, drill down does not work. All other aspects of the reports work correctly, but not drill down. Clicking the + shows what looks like activity but the drill down section is not expande...more >>


DevelopmentNow Blog