all groups > sql server reporting services > january 2006 > threads for monday january 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
rkeymgmt question
Posted by Prashant Kumar [MSFT] at 1/30/2006 9:24:37 PM
Hi,
This question pertains to Reporting Services 2000.
As per
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp,
after doing a rskeymgmt -d, I need to perform 4 steps. I understand 1. 2 and
3 in the article.
Can someone help me with the 4t... more >>
Query from within Excel
Posted by Preacher Man at 1/30/2006 4:56:27 PM
I have a need for some query help and I will try to explain my situation.
Thanks in advance for any help.
I have an Excel spreadsheet that has two different sheets. One one sheet
called "Data" I have created a query that pulls AP Invoices from from a SQL
database. In the results of this q... more >>
Creating ODBC link within SELECT statement
Posted by Preacher Man at 1/30/2006 4:43:57 PM
Is this possible. To explain myself, here is my situation. I created an
Excel Spreadsheet that uses an ODBC link to a SQL database. In order for
anyone to use this file on their PC, that same ODBC link must be setup. Is
their some code I can use within a Select Statement that will allow me... more >>
report server no longer sends emails
Posted by Stacey at 1/30/2006 4:15:37 PM
We had to change the administrator password recently. So I took the
opportunity and created a sql user (yes.. it is domain admin) and moved the
sql and reporting services to run under this user instead of administrator.
Since this time, my report server doesn't send out the reports via email. ... more >>
Culture Settings Problem
Posted by Ed Allison at 1/30/2006 4:00:04 PM
Hi everyone,
My name is Ed Allison. I am very new to reporting services (about 2 weeks,
in between working on a lot of other stuff), and have had no luck attempting
to track down a particular problem.
I am running Visual Studio 2005 and Reporting Services 2005 on Windows XP
(fully servi... more >>
How to implement floating headers and/or columns
Posted by Ashok G at 1/30/2006 3:35:27 PM
Hello,
I have read in a number of Powerpoint presentation from MS folks that we
have the ability to implement floating headers and/or column, similar to
freezing panes in Excel.
Could somebody please point me to the article/link that explains how to
implement this?
Thanks in advance ... more >>
Same report - two different directories?
Posted by Scott Baker at 1/30/2006 3:10:14 PM
Is it possible to reference the same report from two different directories?
Please advise.
Thanks,
Scott A. Baker
OraSure Technologies, Inc.
... more >>
Does SSRS support sProcs that return multiple tables?
Posted by JDP NO[at]SPAM Work at 1/30/2006 12:19:54 PM
I'm porting an ASP.Net report(s) to SSRS.
I have an sProc that returns meta-data about the result set in table(0) and the
actual data in table(1).
How do, or can I display table(1), the second table in my result set?
TIA
JeffP....
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Extra white space in table
Posted by Mathias at 1/30/2006 11:53:08 AM
I've got a table with a header, group, and detail row. The detail row
is collaspable however when it's collasped there is several lines of
white space between the parent groups. How do I get rid of this white
space?
Thanks in advance for the help
... more >>
multiple prompts problem
Posted by bosstan1 NO[at]SPAM gmail.com at 1/30/2006 10:45:53 AM
I have a report with multiple prompts.
Every prompt based on separate stored procedure with default value
"All".
If I'm running it via Report Designer everything works fine.
However, if I'm trying to run it via Report Manager only one prompt
display default "All" ,
all other prompts do not hav... more >>
Batch Printing
Posted by Curtis at 1/30/2006 10:07:05 AM
I have a report called Report1 that has 1 parameter called Parm1 and there
are 296 choices for Parm1. Is there anyway to create a batch job to run
this report for all 296 choices and send to .PDF?
... more >>
How to calculate distinct count per group?
Posted by ob at 1/30/2006 9:06:51 AM
I have Department group and want to count
how many distinctive customers we have in each of them:
I placed this formula in group footer
:=countDistinct(Fields!Customers.Value,"Department")
but it shows me total number of customers in each row.
Oleg
... more >>
checkboxes and exporting to PDF
Posted by jagb at 1/30/2006 12:00:00 AM
How do you mange to create checkboxes on your reports?
Since there is no builting support for checkboxes, I have tried using:
Windings font:
=IIf(Fields!MyBooleanField.Value=False,ChrW(&h006F),ChrW(&h00FE))
that would give me the empty square and the ticked square (when previewed
in dhtm... more >>
|