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 > july 2004 > threads for friday july 30

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

Make a folder available to everyone
Posted by Joe Bourne at 7/30/2004 8:08:55 PM
What would be the easiest way to make all the reports in a RS folder available to everybody who can access the Report Server website, whether or not they have NT accounts? Joe...more >>


Purchasing And Licensing
Posted by Brian Parker at 7/30/2004 6:31:01 PM
If we own two standard edition SQL Server licenses that we can use for Report Services and a SQL Server running on another server, how does the report server recognize I have a valid license? The setup doesn't ask for any sort of license key... we don't want to install SQL server on our actual rep...more >>

Row Num in matrix
Posted by battula at 7/30/2004 4:47:46 PM
I am using Matrix in my report. I have One Row Group (ProductID) and 7 Static rows. Expression for my ProductID Group is =Fields!ProductID.Value How can I set the Page break so I can accomodate 4 Row Groups (i.e) 28 lines on one page and then goto next page. Any Suggestions. ...more >>

is it possible to create one RDL file that consists of main report and subreport?
Posted by erdi at 7/30/2004 4:07:14 PM
is it possible to create one RDL file that consists of main report and subreport? ...more >>

Report Format
Posted by Koneru Vijay at 7/30/2004 4:03:48 PM
Can i add any new type of Output format in the export report select box other than PDF,Excel etc which r give in dropdown.If yes please help me. Regs Vijay ...more >>

Seperating Catalog and Server (why?)
Posted by creative NO[at]SPAM mailcity.com at 7/30/2004 3:08:19 PM
In a network load balance architecture - Scenario 4–Multiple Report Server Computers Connect to a Remote Report Server Database in a Web Farm Configuration I have gone through several white papers and newsgroups - and they all say - "for reliability and scalability"... What's the real be...more >>

No Page Break within SubReport
Posted by Milu at 7/30/2004 2:39:02 PM
I have a main report which includes 4 sub-reports. One of the sub-report shows the details based on selected parameter values and at that time all other sub-reports are hidden. When I run the sub-report as a seperate report, it shows page breaks correctly but when I display it from the main report, ...more >>

Using the One-time Schedule option not working
Posted by tim.trujillo NO[at]SPAM gmd.com at 7/30/2004 1:07:43 PM
I am trying to use the one-time schedule option in Schedule Detail section and the subscription never appears to run. I can get the Hour option to work. Does anybody have any ideas? Thanks Tim...more >>



Subscription logon failure
Posted by Richard Wrench at 7/30/2004 12:49:44 PM
If anyone has a e-mail subscription that works, please tell me what you did, security-wise, because I get logon failures regardless of what I try, and I am convinced that SQL security accounts do not work with subscriptions. What is going on here? Regards Richard ...more >>

Printing landscape problem
Posted by VC at 7/30/2004 12:33:03 PM
Im trying to set up my report for a landscape view. I have changed the PageSize in the report properties to 11in, 8.5in. I made sure the size of the body is less that the pagewidth - the left margin - the right margin. When I do a print priview i get the error "index was out of range." If i chan...more >>

List Control Properties
Posted by rwiethorn2002 NO[at]SPAM yahoo.com at 7/30/2004 11:45:14 AM
I saw this posting below, and I just want to be clear. I have a data set with one Column, but many rows. I would like the data to display horizontaly, then wrap to the next line. My data is actually displayed in through Image controls. Im pulling the images from an external path, on the web (htt...more >>

Report not exporting full file
Posted by moondaddy at 7/30/2004 11:42:42 AM
I'm using RS sp1 and have a report that's 50 pages long and has 1000 thumbnail images in it (it serves as a products catalog). When I export as a PDF or tif, only half the data is exported so in the case of the PDF it cant open because it says its corrupt, and in the case of a tif, it will open...more >>

Email Attachment Corruption
Posted by Stuart Finley at 7/30/2004 11:13:02 AM
I have a subscription to a report that delivers an Excel attachment. When delivered to my outlook mailbox, no problems. Same report attachment delivered to my hotmail account is corrupted. Results are the same with the CSV option. Is this related to the problem with lotus mail servers?...more >>

Terrible Things Afoot - Stopping Data-Driven Subscriptions
Posted by Lazerath at 7/30/2004 10:55:54 AM
Hello, I seem to have done something terrible. I had a long running data-driven subscription processing and had at least two hours of remaining processing left, so I attempted to find a way to stop the process. Is there a way? What I did was delete the row out of RunningJobs, but that seems to...more >>

installation.
Posted by Killer at 7/30/2004 10:37:38 AM
GOOD MORNING, I HAVE INSTALLED THE MSSQL RPT SVC ON A SQL SERVER BUT HOW CAN I DESIGN A REPORT? I DON'T HAVE VISUAL STUDIO .NET ON THE SERVER ,IS A PROBLEM? ...more >>

Install SQL RS on Domain Controller (PDC)
Posted by tjhazel at 7/30/2004 10:27:02 AM
I am attempting to install Reporting Services on a Windows 2000 (SP4) Primary Domain Controller. The initial issues I was experiencing were permission related. The TBP\IWAM_XXX account required changes to the Domain Security Policy. We made the changes as instructed in the Knowledge base article....more >>

Rendering HTML in Detail Textbox on Report
Posted by epopo NO[at]SPAM attbi.com at 7/30/2004 10:22:14 AM
My application collects some information using the FreeTextBox web control, which allows the user to paste HTML, word documents, etc... The user has requested custom SQL Reports to display the data, instead of the html reports that I created. Problem is that the data stored as an HTML string d...more >>

Two reports in one PDF?
Posted by burt_5920 NO[at]SPAM yahoo.com at 7/30/2004 10:13:09 AM
I want to use the RS object model to pass parameters to two reports, then render them in the same pdf. My users don't want to receive 20 separate PDFs each day. Is there a way to do this? Any help is greatly appreciated. Burt...more >>

how to simulate the Export button in the HTML viewer - to make a file copy of current viewing report
Posted by Guo, Lianghong at 7/30/2004 10:09:13 AM
I created a Windows report viewer and use the RS HTML viewer to view a report. In order to print the report, I added two buttons in to the viewer, one button is for Print-Preview and the other is for Print. For various reasons I decide to use Acrobat Reader as the print/preview tool. I know...more >>

Referencing a text box
Posted by ashvsaod at 7/30/2004 9:55:47 AM
Hello, If I have a text box with the following value : =Sum(Fields!Sales.Value) Can I then in another text box write something like: =textbox30.Value + textbox50.Value Is this possible? ...more >>

Printer Delivery Extension cutting off data
Posted by popnfresh NO[at]SPAM shaw.ca at 7/30/2004 9:50:08 AM
I have added the Sample Printer Delivery Extension to my report server, and am able to print most of my report, but not all. When the report is printed, data is 'chopped' off (not printed). Currently, if the report spans 3 pages, the 1st and 3rd page are printed (the second page is skipped). If ...more >>

Installation issues
Posted by steve at 7/30/2004 7:57:42 AM
I am attempting to install SQL RS and I am getting the error "Instaliing WMI registration Error -2147221164" I had just upgraded my PC from Windows XP Home to Windows XP Pro. I suspect this is not a SQL RS issue, but maybe someone knows something about a solution. ...more >>

newline in pdf lost
Posted by Nicki at 7/30/2004 6:23:02 AM
I'd like to format a textfield with newline. In Preview everything looks ok. After exporting to pdf all newlines are gone. I use the following text inside the textbox: +++ =controlchars.Newline & controlchars.Newline & controlchars.Newline & controlchars.Newline & First(Fields!NameKunde.Value,...more >>

Dynamic Select list in Stored Proc
Posted by Frans-sa at 7/30/2004 4:31:03 AM
I have the following script where the select parameters is dependent on the "component" parameter list being send via the stored proc. Therefore the number of parameters returned by the proc is dynamic. These fields therefore do not show in the .Net design to be added to the report. Need some adv...more >>

Problem with custom assemblies
Posted by m.herrmanns NO[at]SPAM fme.de at 7/30/2004 4:09:56 AM
Hello! How must I change the config files that my assemblie will work on the Reportserver? Lokal in VisualStudio.net all works fine. But on the server nothing happens. Please one tipp for me. Michael Herrmanns...more >>

A stupid SQL RS question
Posted by bhai at 7/30/2004 3:35:11 AM
Hello everyone, I am newbie to SQL RS and just got it installed on my laptop. I wanted to know if the following is possible with SQL RS or do I need to use a thrid party tool. Here is what I want to do: I have a search website where users can query certain (SQL) databases and genera...more >>

Installing report server (urgent)
Posted by Keenz at 7/30/2004 3:27:02 AM
I try to install report server in my computer. The problem is I want to install it not in my default web site (my default web site is stopped). I want to install it in another web site in my computer but the installer doesn't recognize my web site. If default web site is turned on, the installation ...more >>

Mail Delivery - Corupt attachments
Posted by Mario Spicar at 7/30/2004 2:49:03 AM
When I configure Mail Delivery in RS sending mails with links works fine, but when I want that also report is attached in mail I get corupted files. There is no difference if it's PDF, Excel or TIFF. Delivery to File Share is working fine and all files are readable. I use LotusNotes SMTP servic...more >>

Search within generated report
Posted by May Liu at 7/30/2004 2:47:04 AM
Other than Document Map, is there any built in searching function within the generated report ??? e.g. The generated report contain more than 100 records. Then I would like to locate a particular record by inputing search values in textbox....more >>

How to align image in table cell
Posted by moondaddy at 7/30/2004 12:12:30 AM
I have a report that serves as a product catalog and the main content are thumbnail images of the products with a SKU number on top of each one. All of the table columns are 1 inch wide, but the images vary in width and often are .5 inches wide or even less. By default all the images are aligne...more >>


DevelopmentNow Blog