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 2006 > threads for tuesday october 17

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

How to display 1 as 1.0
Posted by ad at 10/17/2006 9:15:43 PM
I want to display 1 as 1.0 in localreport. How can I do? ...more >>


totals on created fields in report builder
Posted by rob at 10/17/2006 5:06:02 PM
I am using SQL report builder. Using a table format. I have create some fields which are computations of other fields. However, I cannot get subtotals or totals on these new fields. -- Cheers Rob...more >>

Using data from 2 databases in 1 report
Posted by Anthony J. Biacco at 10/17/2006 3:56:29 PM
Is there a way I can pull and use data from 2 different databases/datasources in a single report? esp. with the databases being Oracle. Thanx, -Tony ...more >>

Security
Posted by Joe at 10/17/2006 2:07:58 PM
Having problems with getting security to work right. Want NT security to work. Scenario - I create a report and DS and deploy it with Windows Integrated Security - but for some reason it only let's me view it and not other foks that are in same role as me. In fact, I can only get reports ...more >>

SQL Reporting services (2005) versus Crystal
Posted by Mike at 10/17/2006 2:07:02 PM
I was wondering if SQL Reporting services is a viable replacement for Crystal Reports? We currently use Crystal Reports 11 with our application and distribute the runtime files to our customers. Over have of our customers use MSDE instead of the full licensed copy of SQL. For our next version,...more >>

View Report Viewer
Posted by Mike OKC at 10/17/2006 1:27:01 PM
How do I view the REPORT header? I can see the PAGE header and footer, but not the REPORT header and footer. ...more >>

How to query entire recordset by default when report contains unnamed parameter
Posted by bcumminsr NO[at]SPAM yahoo.com at 10/17/2006 12:31:52 PM
Thanks in advance for reading this post. Due to having to use the OLE DB provider I cannot use named parameters. Therefore, I am attempting to return all of the records when the user first submits the report and then allow the user to change the parameter to filter the data. My problem is wh...more >>

can a textbox hold the value of more than 1 field? maybe use funct
Posted by Rich at 10/17/2006 12:31:02 PM
Hello, My question is if a textbox in a report can contain values from multiple fields from the data source: txt1.value =Fields!txt1.Value & "-" & Fields!txt2.Value & "-" & Fields!txt3.Value If this is doable, what is the method/correct method? I can add multiple fields to one tex...more >>



Total of Totals on multiple pages
Posted by Elmo Watson at 10/17/2006 12:04:09 PM
I have a report that gives me a total of the items on each invoice - the thing is, it reports multiple invoices (even over 100 of them) How can I add up each of the Page totals for a Full total (=Sum(??????)) Ideas? ...more >>

Upgrading RS2000 Reports to RS2005
Posted by Sajal Kumar at 10/17/2006 8:18:01 AM
Dear RS Experts, In upgrading the 2000 reports in 2005 Reports Manager, i was able to upload the rdl file. But it did not bring its data source with it. I do not see any option to upload the old datasource. do they have to be created fresh for each report and linked to the report? that is w...more >>

Reporting Test Web Environment
Posted by Stuart at 10/17/2006 8:15:01 AM
Has anyone come up with a way to deploy reports to a test environment without purchasing a new server and a second copy of Reporting Services? I would like to have second website with a copy of our live site for testing purposes but we don't have the resources or the demand to warrant a secon...more >>

Set default report language and default TargetServerURL
Posted by JH at 10/17/2006 7:52:03 AM
Hi all, I am using SQL Server 2005 Reporting Services and Visual Studio 2005. By default my Report Language is English (United States). I have to change this EVERY time I do a report to English (United Kingdom), otherwise my dates don't format correctly. I can't for the life of me find a w...more >>

Login failed for user '(null)'
Posted by Dan D. at 10/17/2006 6:40:02 AM
Using RS2005 and SS2005. I am able to connect through a browser to server/reports and run a report. However, another person is not able to run the report. She gets the error: Cannot create a connection to data source 'dataSource1'. Login failed for user '(null)'. Reason: Not associated with a ...more >>

Linking reports
Posted by chris.j.stubbs NO[at]SPAM gmail.com at 10/17/2006 4:10:11 AM
Does anyone know if it is possible to link two reports together? For example, if you have a report showing customers with the number of orders they have placed, can you then link to another report showing details of the actual orders. Hope this makes sense. Chris ...more >>


DevelopmentNow Blog