all groups > sql server reporting services > october 2006 > threads for thursday october 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
New Template, open exsisting, any way to call reporting wizard now?
Posted by Jason at 10/26/2006 7:04:42 PM
Any way to load my new template, and then call wizard? seems wizard is
not accessable if after I start with open existing item.
Can anybody recommend and easy to follow book on on reporting services
2005?
dumb question, say I have a grouping report like this
group
detail detail... more >>
Local reports with ADO.NET Dataset help
Posted by Brian Vallelunga at 10/26/2006 6:18:34 PM
I'm trying to use a local report in a Windows Forms application that
uses an ado.net dataset. The trouble is that I'm trying to figure out
how to access data within related tables. If the dataset has a table
called Customers with two records in it, how do I go about displaying
the data from ... more >>
Reporting Services Mode
Posted by Chuck P at 10/26/2006 5:59:01 PM
I need to do an asp.net application that has reports and Forms Authentication
(no windows authentication). I have absolutely NO need for centralized
reports or load balancing.
On my last project I used sql05 reports within asp.net vs05 on a win03/32bit
server and used LOCAL reports.
The... more >>
Summing a calculated column
Posted by Elmo Watson at 10/26/2006 4:27:54 PM
In my report, one column is a calculated column based on two others
ColumnA - Quantity
ColumnB - Cost
Then, Column C multiplies Column A * Column B
=Fields!Quantity.Value*Fields!Cost.VALUE
That part works just fine
But - I need to (not in Footer), create a cell, that sums up all the valu... more >>
Using UNION in MS SQL vs Oracle
Posted by Peter Manse at 10/26/2006 3:31:02 PM
In SQL, this works beautifully:
SELECT 'All' AS RootName, ' All' AS SortValue
UNION
SELECT DISTINCT RootName, RootName AS SortValue
FROM dbo.APP_OnlineReportingRoots
ORDER BY SortValue
It adds the word "All" to both the RootName ans SortValue columns of the
results which I then use for ... more >>
Is there a way to iterate through the Parameters collection in a r
Posted by Chris G. at 10/26/2006 2:48:01 PM
SSRS 2005
I would like to be able to write a function which takes a reference to the
Parameters collection in the report and then iterates through the collection
to dynamically build a string which outputs the prompts and values for all of
the visible report parameters.
The only problem ... more >>
Subscription problem when using Analysis Services as the datasource
Posted by Ryan at 10/26/2006 2:00:25 PM
Hello,
I've searched this newsgroup and others using google groups and was unable
to find a solution to the below problem. I am hoping someone from here can
help me out.
I've created a simple report in MS Reporting Services 2005. I've created a
shared datasource to a Microsoft Analysis s... more >>
Open URL in New Browser
Posted by ME at 10/26/2006 12:11:43 PM
My report has a table that when I click on a cell it jumps to URL and open
it in the same browser window. How to open the URL in a new browser instead
of current browser window?
Thanks.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSRS and Excel
Posted by Murali at 10/26/2006 10:58:01 AM
Hi,
I have a report that displays appromiately 100,000 rows. But when I export
the report in to excel file, it gives an error because excel sheet cannot
exceed 65,000 rows. Documentation says I need to use pagebreaks. Does anyone
what exactly I need to do inorder to have the report data dis... more >>
subtotals and parameters questions
Posted by Roberto Peña at 10/26/2006 10:56:08 AM
Hi,
I'm working on a report using RS2000 where I have the following questions:
1- How do I change the expression for a subtotal? Let's say I need to change
the agreggate function, average instead of sum for example, I dont know if
this is even posible. Now, what I really would like to do is se... more >>
RS2K Install Problem ASP.NET
Posted by Todd Lemen at 10/26/2006 10:16:02 AM
I am installing RS2K3 on a WinXP box running IIS. Error message indicates
ASP.Net not registered with IIS. Have run aspnet_regiis -i from the
%windir%\Microsoft.Net\Framework\v1.1.4322 folder, same message occurs.
Suggestions?... more >>
Sort on Matrix Row
Posted by Peter at 10/26/2006 9:06:02 AM
Hi folks, I have a Matrix report as below:
Adult Members child Members
TX 30 40
AL 10 20
MA 55 11
If I want the row order like AL, MA, TX, what are the steps to achieve.
Ple... more >>
help with charts
Posted by aggiechick717 at 10/26/2006 7:10:39 AM
I can't figure out how to turn off the document mapping of my report. I
have two charts on my report and that is it. Any ideas?
Thanks in advance..
Missy
... more >>
URGENT: Group page count
Posted by Kyriakos at 10/26/2006 12:37:01 AM
Many of us like to be able to create reports that will count the pages per
group.
For example:
I have a 10 page report with 2 clients.
Client No 1 has 3 pages, while client no 2 has 7 pages.
I would like to create a field (at the page footer) that will count the
pages for each client (i... more >>
|