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 2005 > threads for friday july 29

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

barcode missing when printing from reporting services
Posted by John230873 at 7/29/2005 5:59:05 PM
I am using a barcode font 39 to generate barcodes in some reports. If I reader the report and save it to a excel spreedsheet and print then the report prints fine with the barcode. If while I am in the browser I use the reporting services print engine the barcode comes out as the numbers ie...more >>


The operation has timed out
Posted by Oleg Bulay at 7/29/2005 4:43:28 PM
Hi When I run report, it times out after about 4 minutes. When I run stored procedure this report is based on, it takes about 10 minutes to run in Query Analyser. My Datasource has setting: Connect Timeout=6000. What should I check? Oleg ...more >>

excel formatting problem... could this be a bug?
Posted by Jeff at 7/29/2005 1:38:01 PM
Okay, I'll try my best to explain this..... I have a table on my report. Above the header for 5 of my columns, I need to place a cell that spans all those columns. It looks like this: ---------------------------------- | h | --------------------------...more >>

value displays in one page of header only - repost
Posted by Cory at 7/29/2005 11:54:03 AM
Hi. I'm resposting the question because I haven't been able to get (or figure out) an answer. Thanks for reading. I am using ReportItems in the header of a report to reference a data field in the body of the report. Often the data in other fields can be quite large (20 to 100 pages when r...more >>

Event Model supported in SRS?
Posted by Keith at 7/29/2005 11:51:03 AM
I probably already know this answer, but I'll ask it anyway. Can we respond to RS event within RS? ===================== Thanks! Keith p.s. Get off the couch and exercise!...more >>

excel vs. pdf - is it possible to eliminate header?
Posted by Cory at 7/29/2005 11:49:03 AM
I have a report that has images etc. (company logo) at the top which works fine when rendering to pdf. However I'd like to elimiate this stuff when rendering to xls. Is that possible? Thanks. --Cory...more >>

Expressions in Height property of a Table
Posted by Rlane at 7/29/2005 11:21:19 AM
Is it possible to use an expression to set the Height property of a row in a Table? If so, show me an example. ...more >>

rs.render (programmagically the fastest way to printer HELP)
Posted by trint at 7/29/2005 11:19:44 AM
I have written a c# app that renders in real time the RS Reports in an 'EMF' memory stream straight to the printer. Would it be faster to stream them to a file and then send to the printer??? Streaming straight to the printer is VERY slow! Thanks, Trint ...more >>



2005: Publishing (not exporting) Report in Excel format
Posted by Machelle at 7/29/2005 11:06:18 AM
My end users want me to post 2 versions of my 2005 Reporting Services reports. One that when they click on it automatically opens in Excel w/o grouping...sort of a data dump. Then a second that is grouped, formatted and pretty. I know that I can have them export the report once run into E...more >>

Group header printed unnecessarily on page because no rows below
Posted by McGeeky at 7/29/2005 10:09:10 AM
I am using a table with grouping - but found that the group header was printed at the bottom of the page (when exported to PDF) with no rows below it. The following page printed the group header again with the rows. Is there a way to stop that behaviour? Example... Page1. Group Header ...more >>

8gb of log files - how to i stop ?
Posted by scott at 7/29/2005 10:05:09 AM
Hi, Reporting services has been running for a couple of months. I noticed today that I had 8GB of log files. Is there anything I can do to stop so much being logged ? i don't really need it. Thanks Scott ...more >>

Reporting Services/MS Analysis
Posted by Kerri at 7/29/2005 9:46:09 AM
We are trying to find a service pack that will allow us to connect from reporting services to MS Analysis services. Does anyone know what service pack we need? ...more >>

Is there a way that I can pass the html syntax as is in the textbox value?
Posted by steve kwon at 7/29/2005 9:01:03 AM
Hello, Is there a way that I can pass the html syntax as is in the textbox value? Currently it displays the whole html syntax in the report. <a style="text-decoration:none;color:Black" href="#" onClick="javascript:void(window.open('http://www.google.com','_blank'))" TARGET="_t...more >>

Dataset built using Oracle stored procedure and User!UserID field
Posted by MSOracle at 7/29/2005 8:45:02 AM
I have report with report parameter as "Regions".This parameter dropdown needs to get populated based on User!Userid global variable.To achieve this I have Oracle stored procedure "GetUserRegions (userid, cursor OUT )" How can I build Dataset based on this stored procedure and pass User!User...more >>

Adding Users
Posted by Ben at 7/29/2005 7:51:06 AM
I am trying to set up my report services so that a "power user" for a specific set of reports can go and add the users that they want to have access to the reports. However, the only way that i find this works, is if i also grant the "power user" access to sql server enterprise manager to cre...more >>

Report Manager/Viewer Help!!!!!
Posted by OriginalStealth at 7/29/2005 7:35:03 AM
The parameters box in the report view displays in tabular format if you have at least two parameters. Can I change this in anyway so it displays in columan format. Current display 1. parameter box 2. parameter box 3. parameter box 4. parameter box Can I change it to d...more >>

Is it possible or Is it too much ?
Posted by RP at 7/29/2005 7:34:02 AM
Hi, This is what i want to do. Is it possible ? I have a report1 with a textbox button - and a table with 10 rows. when the user clicks on the textbox button - it should open another report - report2 - IN ANOTHER BROWSER. report2 takes filter values and has a close button - when close butto...more >>

sproc, temp tables, dynamic columns (PIVOT)
Posted by tutor at 7/29/2005 7:16:02 AM
hi folks I have a dynamic pivot table sproc I've written, which I'm trying to include as the data source for a new report (familiar with how to execute a sproc as the datasource). I don't seem to be able to get a query string into the Report Wizard that's acceptable. (Next step is how t...more >>

HELP matrix export to excel ERRORS
Posted by MJ Taft at 7/29/2005 7:14:03 AM
I have 2 matrix reports a summary and a detail. The summary report exports fine to excel but when my customers drill to the detail matrix from the summary and then try to export to excel ... they get this error ==> "Exception of type Microsoft.ReportingServices.ReportRendering.ReportRende...more >>

404 error in the report manager
Posted by Jagan at 7/29/2005 6:46:13 AM
hi, I have installed the reporting serivces, the report server is working fine, But when i try to view the report manager, http://<servername>/reports it gives a error message "The request failed with HTTP status 404: Object Not Found. " I have seen the virtual directories and the rswebappl...more >>

report manager is not working--urgent
Posted by Jagan at 7/29/2005 6:32:59 AM
hi, I was working on reporting services and when i opening the report manager in the browser, it is giving me error the error is the request failed with HTTP status 404: Not Found and the reportserver it working fine. I have seen the rswebapplication.config and the 2 virtual directories also...more >>

Single Column to Multi Column Help
Posted by Scott Duckworth at 7/29/2005 6:31:46 AM
I'm working on a report that one of the parameters is a list of state names. (Actually the parameter is a state ID but I have a query that retrieves the state names.) This list can be 1 state of all 50. They would like the list of states listed on top of the report. How can I do this in a mu...more >>

Ways for using .Net Assembly within a Reporting Services report
Posted by Domenico at 7/29/2005 5:26:05 AM
Hi! How can we use .Net assembly to reference within a report? We know two ways to reach this: - registering a custom library in the global assembly cache utility; - coping our custom library in the bin folder of Reporting Services server. Is it possible to reference directly a class? Consid...more >>

Conditionaly hiding rows in a table in a single datagroup
Posted by Chris Hoare at 7/29/2005 3:17:02 AM
Hello, I have a report which takes data from a stored procedure and then reveals some text on a row depending on whether or not a bit is true. The data coming from teh stored procedure is a single row for a contact, and it displays a number of rows in the report. When we run the report i...more >>


DevelopmentNow Blog