all groups > sql server reporting services > may 2005 > threads for thursday may 26
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
Email Subscripions Question
Posted by Brian Ward at 5/26/2005 6:19:37 PM
I would like to do a email subscription but the Email option doesn;'t show up
in the delivery methods.
What needs to be enabled to allow this option?
Cheers Brian... more >>
Make row in table shrink or collaps
Posted by moondaddy at 5/26/2005 5:16:38 PM
How can I make a row in a table shrink or collapse when there's no data for
that row? I have a table with several detail rows in it. the bottom row
has 2 cells. the first one if for a label and the second one is for the
data.
cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees",... more >>
Iif Functions
Posted by Nat Johnson at 5/26/2005 5:04:02 PM
In a table im populating I have to leave a data cell blank depending on the
value retrieved.
eg. if the breed type is deer leave the cell blank.
Do i use an Iif function for this or not. And if so how do I write it.
Total sqlnewbie here.
I have this so far.....Iif(Fields!Breed.Value ... more >>
parameter limiting
Posted by scraejtp at 5/26/2005 3:05:22 PM
I have a few required parameters listed at the top of a report. I want to
make it where when one parameter is chosen in the drop down menu, the other
parameter(s) limit their choices accordingly. I can't seem to find a way to
do this though.
Any help would be great. Thanks.
... more >>
Migrating reports from one server to another
Posted by vRam at 5/26/2005 2:48:07 PM
What is the best way to move a folder in reporting services from one server
to another. The folder contains reports, data sources, images, and
subscriptions.
I dont want to move the entire databse.... more >>
Show data for CURRENT YEAR only
Posted by pmud at 5/26/2005 2:34:03 PM
Hi ,
I have a very simple question. I want to show data in my report only for the
current year. How to do that? n my query , I did , WHERE
Year(OrderDate)=Year(Now) . But it gave me a syntax error.
What is the correct syntax for this?
Thanks
--
pmud... more >>
Subreport Headers and Footers not displaying
Posted by John Supplee at 5/26/2005 12:06:02 PM
Is there anyway to get the headers and footers to diplay? Also is there
anyway to have the page count reset for every interation of a subreport being
called.
Thanks,
John... more >>
Expression for Running Total
Posted by bak at 5/26/2005 11:41:32 AM
I want to write an expression where the running total should be
calculated if the previous value for a column(invoice code) is not
equal to the current value for the invoice code.
The expression should be something like this:
iif( current invoice code is not equal to the previous invoice
co... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ReportServer Service stopping
Posted by Kmistic at 5/26/2005 7:05:01 AM
I have the ReportServer service set to automatic, but on a daily basis it
seems to stop. This causes my report subscriptions to not fire. My log file
ends with the following:
aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries,... more >>
[BC30469] Reference to a non-shared member requires an object reference.
Posted by Siew Fai at 5/26/2005 7:02:52 AM
Hi, I have a custom assembly which I would like to store state between
calls.
In RDL, the following was declared:
<Classes>
<Class>
<ClassName>MyNamespace.MyClass</ClassName>
<InstanceName>MyInstance</InstanceName>
</Class>
</Classes>
<CodeModules>
<CodeModul... more >>
hidden rows
Posted by pcalv at 5/26/2005 2:05:03 AM
Hi
Hope someone can help.
I'm trying to hide a row based on 2 criteria.
If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value,
True, False) it works but as soon as i add another criteria e.g.
=iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and
Fields!VisitType.... more >>
ADO error (syntax error or access violation)
Posted by Marco van de Kraats at 5/26/2005 12:00:00 AM
I made a union all between two query's in I've built all of the queries in
query analyzer without any problem but in reportingssvcs I get a ADO error
(syntax error or access violation) Does any one know why?
... more >>
Conditional Statement in a Group
Posted by Warren Patterson at 5/26/2005 12:00:00 AM
Hi,
This probably has a simple answer.
This is what I am trying to do on a report , I am trying to get a count of a
condition where IsUnderInvestigation = "yes" where the report is grouped by
"TEAM"
Dataset:
ID Name Team IsUnderInvestigation
1 John X ... more >>
Sort order on Columns of a table
Posted by James Woo via SQLMonster.com at 5/26/2005 12:00:00 AM
Hi -
I have a tabular - drill down report :
Person Subject Period $
- Person1 Skill1 2005-04 2500
skill2 2005-05 300
skill3 2005-01 400
+ Person2
+ Person3
+ Person4 ... more >>
Unable to communicate with report server - PAM
Posted by Pamela Mitter via SQLMonster.com at 5/26/2005 12:00:00 AM
I have installed Reporting Services and I get this message:
Unable to communicate with report server. Please verify that the report
server is operational.
Any ideas how to fix this? I need to get this fix ASAP. Thanks.
--
Message posted via http://www.sqlmonster.com... more >>
How to have Child list Data Set refer to Parent List Field or Textbox name?
Posted by Wayne Snyder at 5/26/2005 12:00:00 AM
I have a parent /child relationship... and 2 data sets - one for each... I
have a Parent list, and a child list embedded within the parent list...
I need to have the data set for the child return all of the rows associated
with the particular parent item on each page, but get the error saying t... more >>
Hide empty detail sections
Posted by Franc v/d Westelaken at 5/26/2005 12:00:00 AM
Hi,
I'm building a report that displays a tree structure with the content
of some nodes of the tree (as detail). Some nodes don't contain any
info, thus the detail section is empty. How can I hide the empty
detail section in the report ? Now it displays always an empty row,
but I want to shri... more >>
|