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 > june 2005 > threads for friday june 3

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

Calculated column in a table
Posted by Eric at 6/3/2005 4:46:58 PM
Hi, I have a table with a calculated column. There is also a footer which calculates the sum in a column. How I can calculate the sum from a caculated column? Ex: 2 10 5 25 <- calculated column --------------- 7 35 <- ...more >>


XML datasource type in new report
Posted by Alexander Bolotnov at 6/3/2005 3:06:27 PM
hello, I am trying to create a report and use an XML file as a datasource for it with msrs that comes with msSQL 9.0.1116. when I get to the screen to setup datasource name, type and connection string I choose XML as a datasource type and then the edit button next to connection string field...more >>

File Share Data Processing Extension Sample
Posted by yinjennytam NO[at]SPAM newsgroup.nospam at 6/3/2005 3:05:01 PM
Hi all, I am very new to this Reporting Services and I want to follow this sample that comes with SQL Server 2005 Beta. However, I tried everything according to the documentation (build the sample, deploy it by modifying the config files, etc.). Unfortunately, when I create a new report (usi...more >>

Excell row 33 problem
Posted by Joško_Šugar at 6/3/2005 2:56:16 PM
I don't know if any of you have encountered this problem.... When I export to Excel, if my report has 33 rows, last row doesn't show. If it has more rows or less it displays ok...more >>

Reporting services setup
Posted by FRR at 6/3/2005 2:03:06 PM
Hello - How much does Reporting services cost and could anyone tell me what software is required? We are using SQL 2000 and Server 2003. Thanks....more >>

Linking Datasets
Posted by rdavis104 at 6/3/2005 1:27:14 PM
How can you link two datasets on a report that come from different databases. I tried to create a queried parameter that pulls its value from a dataset1 field and use in the where clause of my dataset2 query. It gets an error message indicating you cannot have a forward looking parameter. A...more >>

dynamically changing DataElementName property of text box
Posted by Rich at 6/3/2005 1:00:25 PM
HELP!! I have a report that we dynamically change the order that the columns appear based on user input. Further I want to control the DataElementName of the textbox that will contain that field. I can not seem to find a way to get access to this property using any type of code. I have tri...more >>

Default a parameter to todays date
Posted by Aidan Garnish at 6/3/2005 12:59:34 PM
How can I set the default of a datetime parameter to be todays date? Thanks, Aidan ...more >>



Error exporting report with subreport
Posted by MattiasT at 6/3/2005 11:32:02 AM
Hi! I'm getting this error when trying to export (to anything pdf, excel, tiff...) a report with a subreport included. It's a linked subreport (with that I mean it takes two parameters from the main report as inparameters) The subreport is really simple and I have even tested with an empty ...more >>

Report Service error
Posted by Yan at 6/3/2005 10:45:01 AM
Hi, I installed the SQL Reporting services with MS SQL 2000 database server, implemented the form authentication custom security extention, every thing worked just perfect, because some other issues, I tried to modify the URL Root in RSReportServer.config file, from http://<servername>/Report...more >>

Reports (Manager) website errors with 404 and 500
Posted by Keith Powers at 6/3/2005 10:23:01 AM
Deploying reports works, Running ReportServer URL yields deployed reports directory and reports can be run. The Reports Manager website does not run. The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X Error header followed by The request failed with HTTP status 404: No...more >>

Default Value for a Queried Parameter
Posted by pl at 6/3/2005 10:21:03 AM
I have created a report parameter with a query for the list of available values. This works well and you are able to see the values and select the one you want and see the correct report lines. When I try to assign a not-queried value to the default value the report preview acts like there i...more >>

Securing Reports over the web
Posted by Marvin at 6/3/2005 8:56:06 AM
I have an application written in classic asp. I can create a form that posts to the report server, but how do i authenticate the user accessing the reports. I can't use windows login because the user already logs using our application login(uses session cookie after authentication for page a...more >>

report viewer vs SOAP API
Posted by Foober at 6/3/2005 8:53:47 AM
The situation is... I have written my own little "report viewer" using the SOAP API, but it renders slower than the report viewer, and paging (i've tried both the "count <HR> then rerender" method, as well as the hidden text field method) is a real pain in the butt. The reason why I've gone w...more >>

Detail in Table shifts report
Posted by sangred at 6/3/2005 8:16:07 AM
Hi, I work for a paryroll company and we are using rs to print checks from. The fields on the report need to be fixed so the micr does not move. When the detail gets filled in on the tables though it shifts everything down and up (Like the micr at the bottom of a check) depending on how m...more >>

Passing Parameters to the Sp from the Reports.
Posted by CCP at 6/3/2005 8:08:02 AM
Hi, I have 5 columns in a table.Based on the column number i need to display the column header.Any ideas how to get this done in RS?? Any Help Please. Thanks,...more >>


DevelopmentNow Blog