all groups > sql server reporting services > june 2005 > threads for wednesday june 15
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
Border Disappears
Posted by Lisa at 6/15/2005 2:52:09 PM
When I write an expression for the visability of a cell, I am finding that
the border disappears when Hide = True. I don't really want the cell to
disappear, just the text contained within it. And I want the border to always
show up.
Any ideas how I can make this happen?
Thanks,
Lisa... more >>
Reporting services and microsoft exchange on the same computer
Posted by Dale at 6/15/2005 2:50:10 PM
could u say if there would be a problem with reporting services and
microsoft exchange running on the same computer ... more >>
Gradient background
Posted by Elmer Miller at 6/15/2005 2:21:50 PM
Does anyone know how to create a gradient for the background of a row. I
know I can create a gradient bitmap and use that, but that seems like an
inefficient way to go and may hurt performance. Any ideas?
... more >>
Automatic PDF/TIFF generation and saving?
Posted by Teros at 6/15/2005 12:28:06 PM
Ello folks...
Question for you all - I'd like to make a call from a webpage (asp or aspx)
that will call up a report with a given set of parameters, format it as a pdf
or tiff file, and save it to a location. Any ideas?
I know I can use the /ReportServer/ instance to directly call the rep... more >>
SQL Server 2005 - SQL Reporting services
Posted by scarri at 6/15/2005 12:09:15 PM
Do you know, with Visual Studio 2005 and SQL Server 2005,
if I could use an item in the header section refers directly to a field.
Thanks
Sebastien... more >>
multiplue UI Report Tables using exact same dataset ?
Posted by D Witherspoon at 6/15/2005 11:42:04 AM
Is there an easier way to manage the table UI element on the report. For
example in my report I have a table for the header info and the data, the
data uses maybe 10 columns and we could be perhapps adding more columns
(fields) to it in the future. The header uses 4 columns. It's a pain
b... more >>
pass data between two datasets
Posted by Ramani at 6/15/2005 11:01:06 AM
Is there anyway i can pass data between two datasets
ex:
dataset 1 has
select empid, fname,lname ,salary from employee
dataset2 has
select userid ,total/(dataset1.salary) from anothertable
here i want to use a value from dataset 1 in dataset 2.
Thanks in advnce... more >>
Geenral convention for naming the reports
Posted by J-T at 6/15/2005 10:33:21 AM
Is there a good convention for naming the reports?Our clients like to see
friend names for the reports like Fiscal yeay summary,....... and we'd like
to use names like rptFiscalYearSum,........Is there some one who can give me
some suggestions on this.
Thanks
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Use other Software as VS .NET?
Posted by MarkusPoehler at 6/15/2005 10:31:03 AM
Does there exist another possibility to develop RS Reports than using VS
..NET? I could enter XLS into notepad, yes :) but maybe anything more
comfortable??
I have to know this for a study...
Thanks... more >>
Printing directly to Printer from WinForms using Report Services
Posted by 2TheMax at 6/15/2005 10:29:11 AM
Even with Service Pack 2 (with or without RSClientPrint.dll) am I to
understand that we still can't print from the Winforms platform/environment
directly to a printer, it MUST go through a web page and then from a web page
go directly to a Printer (of course with RSClientPrint ActiveX control,... more >>
Reports Stop Responding
Posted by Luke at 6/15/2005 10:17:06 AM
Does anyone ever have an issue where reports stop responding and you
have to restart IIS and the Report Services to get the reports to
respond again? I notice that this happens when a report runs too long.
Does anyone know of a fix? I am still on SP1 waiting for our QA
department to allow us to ... more >>
Create Cached Copies of All Reports
Posted by Joel Rumerman at 6/15/2005 10:13:28 AM
Hey all,
Cmon folks! There's got to be somebody else who is trying this!
I have a report that is setup to be cached for 24 hours. I have also setup a
data-driven subscription to dump all possible variations of the report to a
file share in hopes that the first user to hit the report will n... more >>
Capturing ODBC user name at runtime
Posted by bwschiek NO[at]SPAM hotmail.com at 6/15/2005 9:49:02 AM
Hi:
We are using SRS to report from a DB2 database running on AS400's. It is
working very well.
Pushing ahead, we want to capture information on when certain reports
(actually letters) are generated. The reports prompt for login credentials
at run time. These DB2 database credentials ... more >>
Data Source file on Reporting Services server question
Posted by Mike at 6/15/2005 9:40:01 AM
In the Reporting Services Manager, when the user selects the folder where the
reports reside there is a file that contains the connection string
information along with a user name and password (Data Source).
Is there a way to keep the file from being selected by the user ?
Thanks.... more >>
Navigation problem
Posted by bamboo at 6/15/2005 9:25:02 AM
I have one report that uses "navigate" to another report through the data
region field. This works fine in the development environment (i.e. visual
studio), but when I deploy the reports and try it online on the live
environment, the 2nd report does not even open - i.e. goes to 2nd report
s... more >>
Custom Assembly Using System.Web.Security.FormAuthenticationTicket
Posted by Nate at 6/15/2005 9:11:20 AM
We have created a custom assembly that creates a
FormAuthenticationTicket object. When calling the custom assembly from
an expression for "Jump to URL", the preview returns "Invalid URI: The
hostname could not be parsed" error message.
The FormsAuthenticationTicket is in System.Web.Security, w... more >>
Matrix column titles problem
Posted by Edgar at 6/15/2005 8:42:08 AM
Hi,
I hope anyone can help me with a problem I've been struggeling with for some
days now?
I have a matrix that should look like this. It has a couple of static
columns at the beginning and variable ones (week numbers) at the end
-----------------------------------------------------------... more >>
mailto and picking a field for the subject line
Posted by Jeff Metcalf at 6/15/2005 7:59:04 AM
I've put a hyperlink on a report to send a message to the support center
concerning service calls that are overdue for closure. How can I assign one
of the report fields as the subject of the mail message? For instance, if
the user clicks the 'Send Mail' link, the subject of the mail is "Cal... more >>
Sharing Parameters between reports
Posted by anandr at 6/15/2005 7:24:02 AM
I have two different reports that share the same set of parameters.
I created the first report, report 1, with the parameters. I create a
link/image in Report 1 body that would invoke Report 2 (using navigation
action property). Now whatever criteria (parameter values) the user had
supplied t... more >>
Stored procedure - DataSource
Posted by Suresh at 6/15/2005 6:27:01 AM
Hi,
I am very new to Reporting Service. I have a report wherein the data is
being pulled from a stored procedure. I am able to design the report to point
the report to the stored proc, but I am not able to see the fields that are
referenced in the stored proc. What do I have to do to see th... more >>
How Do I create report from ssis package?
Posted by Swapna at 6/15/2005 6:09:01 AM
Hi,
I have developed a SSIS package which finally lands the data into DataReader
Destination.
How do I genarate a report from this datareader?
What shud be my Dataconnection string?
How to Access that Data?
Plz reply asap.
Swapna
... more >>
AS/OLAP data with RS
Posted by /jerome k at 6/15/2005 2:32:02 AM
Hi,
I'm totally new to reporting services (but worked with mdx/asy2k). Tried
today to build RS reports to an AS database. First, is it true you have to
make a whole mdx query (as in mdx sample application) to create the query
string/dataset ? No help or wizard ? Second, is there a way to get ... more >>
WebServices and Subscriptions
Posted by Bryan Avery at 6/15/2005 2:01:05 AM
I have really two questions to ask, I am writing my own front end and using
WebServices to extract the information I need from the Reporting Server.
I have all the Catalog information and it works well.
But how do I get the Subscriptions information out? I would like to pull
out the infor... more >>
permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are ins
Posted by Bryan Avery at 6/15/2005 1:41:05 AM
I am trying to read the WebServices to gather information about the catalog.
When I run the application from my development box and reading from the
Reporting Services server for the Catalog all run fine.
But when I transfer the application (asp.net) to the server it fails with:
System.We... more >>
Using filters in matrix and/or table
Posted by Kamil p at 6/15/2005 1:02:02 AM
I'm working on reports, which base on queries retrieved with store procedure.
Report consists of list of customers with different types of products sold
to them.
I'd like to present in a matrix only customers with for example product with
code 1.
When I had tried to use "filters" option ... more >>
Dynamic columns in RS reports
Posted by Razvan Popov at 6/15/2005 12:00:00 AM
I have to design a report that will have a dynamic number of columns, in a
dynamic order.
For example: items and a selection from their attributes
ITEM Attr 1 Attr 2
Attr3 Attr 4
I1 5 Realy large text
...................... more >>
Sum Function
Posted by Kiran at 6/15/2005 12:00:00 AM
Hi,
I am working on reporting service and I don't know much about crystal =
reports.
I have got a formula in crystal report like this inside a group(this =
group is grouped by ID)
Sum(Employees.Salary,Employees.ID)
Can anyone tell me what is equivalent formula in reporting service and ... more >>
|