Report of Reports

I have a report listing all my available reports.
On that report I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line.
Is that possible? It looks like the navigate tab can only take a static
reference to a single report.so build a standard report that queries against the SQL Database Named
'Catalog'
-Aaron
Jim Breffni wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.|||It is possible to drillthrough different reports. Your 2nd and the 3rd
sentence are contradictary. correct me if I have understood wrongly..
ie. you said
in 2nd
I would like to click on a line and automatically
drillthrough/navigate to a particular report for that line
in 3rd
Is that possible? It looks like the navigate tab can only take a
static
reference to a single report.
Amarnath
"Jim Breffni" wrote:
> I have a report listing all my available reports.
> On that report I would like to click on a line and automatically
> drillthrough/navigate to a particular report for that line.
> Is that possible? It looks like the navigate tab can only take a static
> reference to a single report.sql

Report not Aggregates

Is there anyway to do a simple line chart that compares 5 fields? For
example, X axis shows fieldA, fieldB, fieldC, etc where Y axis is the value.
I'm having such a hard time with this, the report keeps wanting to take the
Sum or Count (aggregate) of fields. The values don't need summed, they're
already contained in the fields. Please help.
Thanks,
RyanHello Ryan,
I would like to know how you use the SQL Statement to get the dataset.
Also, please give me some sample data.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||2 Tables
table_items
item_id (PK)
item_name
table_values
value_id (PK)
year
actual_amount
item_id (FK)
SQL statement used for the dataset (for years 2002-2004 for example)
(the embedded selects are because some items will not have a row for years,
this puts a 0 value in for those years)
SELECT A.item_id, A.item_name, ISNULL
((SELECT actual_amount
FROM dbo.amounts
WHERE (item_id = A.id) AND (year = 2002)),
0) AS [2002 Actual], ISNULL
((SELECT actual_amount
FROM dbo.amounts AS amounts_5
WHERE (item_id = A.id) AND (year = 2003)),
0) AS [2003 Actual], ISNULL
.....
ETC.
The SQL resultset looks like this:
item_id
item_name
2002 Actual
2003 Actual
2004 Actual
Each item (detail row) is displayed on it's own page. I want each item to
have it's own graph. Just a simple line graph in this example would display
on the X-axis 2002 Actual, 2003 Actual, and 2004 Actual.
Probably too much info for a simple problem but there it is!
Thanks!
Ryan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:HQcIY19CIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> Hello Ryan,
> I would like to know how you use the SQL Statement to get the dataset.
> Also, please give me some sample data.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Ryan,
I suggest you just use another dataset for the chart.
Since the chart is based on the dataset's column and you could not put
multiple columns into the X Axis, you need to use another dataset like this:
item_id, item_name, Actual value, Year.
So that when you put the Year into the X axis, you could get the result you
want.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hmmm, this looks good. The problem though is that the last year in the
chart is a different field. For example:
[2006 Actual], [2007 Actual], [2008 Budget].
The last year draws from a Budget field and not the Actual field.
Looks like this may not be doable. We did have the chart in Microsoft
Access. I may have them use that or see if there's any way to accomplish
this in Crystal Reports (I need something I can build into my VS project).
Thanks,
Ryan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7$yFzgvDIHA.5256@.TK2MSFTNGHUB02.phx.gbl...
> Hello Ryan,
> I suggest you just use another dataset for the chart.
> Since the chart is based on the dataset's column and you could not put
> multiple columns into the X Axis, you need to use another dataset like
> this:
> item_id, item_name, Actual value, Year.
> So that when you put the Year into the X axis, you could get the result
> you
> want.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Ryan,
If you are using VS 2005, you could use the ReportViewer Control to
complish this report in the WinForm or Web Form.
Reporting Services and ReportViewer Controls in Visual Studio
http://msdn2.microsoft.com/en-us/library/ms345248.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report line spacing issue

There is a formatting issue that I have come across.
The report has three groups and these groups have headers. When the report is populated most of the time it prints the result properly as expected, but sometimes at different number result records of the query I see that the main group header consumes an entire page and then skips to the next page. But in the next page I get the main group header and the data as it should be printed. After adjusting a page header (not the group headers) the report behaved normally for the same set of data, but fails when the result is changed again.
Any idea what I have done wrong or need to set (maybe a line size or something ) ?Often times when I have that problem, it's due to the "Keep Group Together" option.

Right click on the group name, and choose, "Change Group." Uncheck the "Keep Group Together" box, if it's checked. That might not be the same issue, but it usually resolves the problem with me.

Good luck!|||There is no 'Keep Group Together' checked in this case. I had it earlier and removed it also thinking that may be the issue.
The problem mainly is even if I tweek it a bit and get it to work with one set of data if fails for another one later.
Thanks very much for looking at the issue.|||So all your group expert 'keep group together' and your section expert 'keep together' for groups are unchecked?|||I am terribly sorry. I was all this time unticking the 'Kepp Group Together' check box in the 'Selection Expert' window when RMB and select the 'format..' option.
As I unchecked the check box in the 'Change Group Options' window it worked.
Thank you very much for the help.
By the way do you know why is there two options of 'Keep Group Together' in these two windows ?|||The one in the section expert keeps the section together, e.g. your group header has 3 sections and this keeps these 3 sections together.
The one in the group expert tries to keep the whole group together, i.e. the entire group header, footer, details inbetween etc.