all groups > sql server reporting services > july 2006 > threads for wednesday july 19
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
What to use instead of a Subreport?
Posted by Christian Nein at 7/19/2006 9:59:27 PM
Hi,
I have a report containing 2 datasets:
- dataset 1 containing ProductGroups
- dataset 2 containing the Articels contained in the ProductGroups
Both datasets are 1:N-related by the ProductGroupID (1 product group
contains N articles)
I want to display each product group with a list of ... more >>
Row Total In Table
Posted by Joe Delphi at 7/19/2006 7:30:58 PM
Hi,
I have a table in my report (not a matrix) that displays 50 rows by
6 columns - fixed, no grouping requirements. The user wants to see the
total of both the vertical column (easy) and also the horizontal row - not
so easy.
First I tried this expression = SUM(Fields... more >>
Select All Option in parameters
Posted by Reddy at 7/19/2006 7:26:01 PM
I know post of you know the answers to my question. Here is my question.
Select All option works fine in my report parameter but when I unselect
select all option and select multiple value it wont work.
example:
Select company,Comp_Id, state, city from company_info
where (Comp_Id in (@r... more >>
Using Multiple Data Sets in a Report
Posted by Chris Taylor at 7/19/2006 4:54:57 PM
I was asked this question today by someone wanting to have multiple datasets
in a report. Such as
--Main report
- GL Account Header
- sub report data
- GL Account header
- sub data
- sub data
We are making a ton of SQL calls to execute this report and it takes f... more >>
New Folder button missing
Posted by DBA449 at 7/19/2006 11:15:02 AM
After installing reporting services we noticed that the New Folder button is
missing as well as the contents tab. This has worked on several other systems
that we installed. We referenced reporting services by typing in the browser
http://localhost/reports.
Any ideas on why or how to diagnose... more >>
height and width of the graph to be dynamic
Posted by venkat.oar NO[at]SPAM gmail.com at 7/19/2006 11:09:58 AM
Hi,
I am using a "simple column"graph. on the Y axis, the Interval property
is set as 100, the problem what i am having is if there are more # of
plots on Y axis, the intervals all overlap on each other.
Is there any way we can set the height and width of the graph to be
dynamic?.
--Ven... more >>
Where are the Report Files on the IIS Server?
Posted by ME at 7/19/2006 10:26:29 AM
I am looking for the RDL files and the RDS files on the IIS server but can't
find it. Let's say someone created a report project on his laptop, didn't
put it in VSS. Now if he leaves the company assuming there is nowhere we
can find the RDL files and RDS files, where can we look for them on ... more >>
Report Server is not responding for XP2 sp2 and SQL Server 05 Dev
Posted by adam at 7/19/2006 9:23:01 AM
I am encountering this issue when I try and go to the Report Server url
http://localhost/reports
I get the message:
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version."
I get the same message when... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Export to Excel
Posted by Gaurav at 7/19/2006 8:23:01 AM
Hi,
I am new to reporting services. From the HTML toolbar, if i try to export to
excel... i get the entire report. eg. if i have 3 sections in the report
s1 - header
s2- data
s3 - footer
all 3 of them are exported to excel.
I want to export only the data section (s2).
Is that possib... more >>
Windows Mobile
Posted by Nick at 7/19/2006 7:03:02 AM
Is it possible to run reporting services reports from a windows mobile
browser. I can access the report server and it tries to render the reports
but only the header section up to the parameters. No report body. Is this
just a problem of the reporting services /pocket IE or some setting I can ... more >>
SSRS needed for BI Studio or .NET control- ReportViewer.....
Posted by Peter at 7/19/2006 6:37:01 AM
I have three questions as below:
1. Is a SSRS needed for BI Studio to develop a report ?
2. Is a SSRS needed for the ReportViewer control in a .net application?
3. When a window form using a reportViewer to host a report, is it much
more efficient when processing a heavy-duty report because th... more >>
|