all groups > sql server reporting services > august 2005 > threads for wednesday august 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
Printing
Posted by Kerrie S via SQLMonster.com at 8/17/2005 8:33:09 PM
Hi all,
After I have deployed me reports to the report manager and try to print them
out regardless if I do it from the manager itself or export them to pdf or
even excel, I sometimes have blank pages throughout my reports. I know if you
change the margins and page format that it is suppose to... more >>
Empty Report manager page
Posted by Stijn Verrept at 8/17/2005 6:00:47 PM
When I go to http://localhost/Reports I see the page (subscription,
home, ...) but I don't see any tools nor reports.
I have anonymous authentication set to off in IIS for that directory,
and only have integrated authentication turned on. I logged in with
administrator account.
Is there an... more >>
Formatting within a Textbox possible??
Posted by Arkiliknam at 8/17/2005 5:06:02 PM
Hi all.
Have been coming accross this same issue more and more. I am needed to take
in some HTML and print it in a TextBox so that we can render a PDF with
custom formatting.
Up until now, I've written some custom code that replaces known HTML tags
with ascii characters or line breaks, e... more >>
OK button is not working on file upload page
Posted by Edman at 8/17/2005 4:53:01 PM
Hi everybody,
I hope than somebody can help me to fix my reporting services server.
I can upload reports on my reportin services server i dont know why but when
i press the OK button nothings happend everything is working bit i need to to
ulpload to new reports but i can't...
maybe if sm... more >>
Conditional Coount
Posted by C a r l o s - A n t o n i o at 8/17/2005 4:41:55 PM
Hi,
how do I condittionally count the result of a field. Like count if of
something like that...
thanks...
... more >>
Count Null Values
Posted by C a r l o s - A n t o n i o at 8/17/2005 4:15:54 PM
Hi
How do I count Null and non null values in reporting services....????
Thanks
Carlos Antonio
... more >>
Displaying the available values for a parameter from the database
Posted by pmud at 8/17/2005 2:28:03 PM
hI,
My report has 4 report parameters: @manufacturer , @brand, @Start Date,
@EndDate .
I want the @manufacturer , @brand to hsow the drop down list with distinct
values from the db. Now when in these 2 report parameters I do , Available
Values as Non Queried and the Value and lable a... more >>
Problems with Custom Delivery Extension
Posted by NO[at]SPAM at 8/17/2005 12:51:06 PM
I am working on putting together a custom delivery extension (fax delivery)
based on the built-in File Share delivery extension.
Most of the functionality I need already exists in the File Share delivery
extension so I used the Lutz Roeder's .NET Reflector to disassemble the
ReportingServic... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problem Viewing reports in Report Manager
Posted by Jon at 8/17/2005 12:42:05 PM
I have successfully installed the sql server reporting services on a windows
2003 server. I have been able to deploy several reports to the report
server. I have even been able to schedule a report to execute and send out
via email every morning of the week.
Here's the problem. When I ... more >>
Intergrating SQL Server Reporting Services into an ASP.NET app
Posted by Brendan Reynolds at 8/17/2005 11:58:51 AM
I'm trying to integrate SQL Server Reporting Services reports into an
ASP.NET app (SRS 2000, ASP.NET 1.1). I know how to do this using direct URL
addressing, but this exposes in the query string parameters that should not
be exposed. Each user is associated with a school, and should see only... more >>
Subscription disallowed if more than one parameter
Posted by jcomba at 8/17/2005 11:48:49 AM
I'm running SR SP2 Standard Edition on Win 2003 with the DB local. It
appears that I can only create subscriptions on reports that use no more than
one parameter. At this piont all of my reports use the same shared data
source with credentials stored in the server. All reports with 1 or 0
... more >>
Production server error
Posted by fassmann NO[at]SPAM gmail.com at 8/17/2005 11:31:27 AM
Hello,
I have reports that have embedded code from a custom assembly.
In design, they work fine. When I deploy them and run them via the
Report Manager on production I get the following error in the cells
where I have this code running:
"Error in method xxxxxx - Request for the permission of ... more >>
Allow anonymous access?
Posted by Stijn Verrept at 8/17/2005 11:23:07 AM
I've been trying with lots of different settings but to no avail. Can
someone tell me what I need to do to allow everybody access to report
XYZ? Both settings required on IIS and RS.
Thanks in advance!
Stijn Verrept.... more >>
Data Set returns but Report doesn't display
Posted by patty at 8/17/2005 11:02:03 AM
I'm returning a data set from a stored procedure. When I go to preview the
report I'm getting an error: An error has occured during report processing.
Invalid attempt to read when no data is present. I made a minor change
(added a parameter) to the stored procedure that wouldn't impact the... more >>
Request for a feature for MS Reporting Services GUI
Posted by Roy Assaly at 8/17/2005 10:39:30 AM
Dear Microsoft,
You know when click "View Report" and that cute green circle comes on
reassuring the user that it's working? Well I would like something
similar to that for when you're selecting cascading parameters.
Let's say you have Country, Province, City as parameters for a report.
... more >>
EDITING DATA when report is displayed
Posted by pmud at 8/17/2005 9:29:06 AM
Hi,
Is there any way that when users view the reports, then they can also EDIT
the data in the report ao that the new updated data goes back to the db ?
--
pmud... more >>
VS.NET Required for Reporting Services Server install?
Posted by Budman at 8/17/2005 9:11:05 AM
When I start the install for Reporting Services Enterprise Ed. on a W2K3
server, it says I cannot proceed without first installing Visual Studio .NET.
I've seen some posts that say I only need to install VB.NET, but I'm still
curious as to why need to install any development tools on a server... more >>
Display RTF String
Posted by Afaq at 8/17/2005 9:05:11 AM
Hi,
I have a rtf string saved in a SQL Server Db which i want to display on the
report. The string is forumlated as:{\rtf1\ansi\ansicpg1252\uc1 aaa}
Is this possible in SSRS? If yes then kindly provide some help on the
implementation.
... more >>
limit export formats
Posted by mollyp at 8/17/2005 8:58:36 AM
Hello,
I was wondering if anyone knows of a simple way to limit the formats that a
user can export to (e.g. not allowing certain users to export to Excel)? Are
there any permissions settings that can be altered?
Thanks much,
... more >>
Distinct document map labels
Posted by Heather M at 8/17/2005 8:36:55 AM
Here is what my document map tree looks like know....
Plant 1
Product Type 1
Product Code 1
Plant 1
Product Type 2
Product Code 1
Plant 1
Product Type 2
Product Code 2
Plant 1
Product Type 2
Product Code 3
What I would like the tree to look like is.... more >>
Multiple datasets
Posted by KimB at 8/17/2005 8:26:33 AM
I have an area of my report that needs multiple data sets to be used to
populate the area. I keep getting the error "Report item expressions can only
refer to fields wtihin the current data set scope". Does anyone know how to
make the area allow me to use one data set in one row and one in dat... more >>
Error in a Sinmple Function
Posted by pmud at 8/17/2005 7:58:09 AM
Hi,
I am using the following Code in the Report Properties. This function
displays the manufactuere logo when brand parameter is null and when brand
is not null it should display the brand logo.
Function ImageDisp(byVal a as String)as String
Select Case a
case ""
return
... more >>
A Template for Reports???
Posted by lwoodyiii at 8/17/2005 7:55:53 AM
Hi,
Does anyone know how to create a template for reports that can be
linked to every report. Changes in the template would then be
automatically reflected in every report connected to the template.
This is a similar paradigm as a css style sheet. There is a
description of way to do this in "... more >>
|