Jump to Report ..... Help

I have a main report with 4 charts. I set each chart to jump to a report
with it's detail. The main report is in the main folder of the directory and
the 4 reports are in a subdirectory call "details". I am getting the
following error when I view the reprorts in the report manager:
The item '/PPE Test/<customer>/AvgIdleTime' cannot be found.
(rsItemNotFound) Get Online Help
The path should be /PPE Test/<customer>/Details/AvgIdleTime but I can't seen
to get it to work. I have used the same directory structure in VS.NET when
designing the reports and they work correctly there. How do I specify the
correct path in VS.NET so that it will be correct when it gets to the report
manager?You can set the path for the hyperlink in the properties of the chart object,
I believe.
This can be absolute of relative to the current report (I prefer absolute at
this moment in time for RS, but relative in standard webs).
"bugfish69" wrote:
> I have a main report with 4 charts. I set each chart to jump to a report
> with it's detail. The main report is in the main folder of the directory and
> the 4 reports are in a subdirectory call "details". I am getting the
> following error when I view the reprorts in the report manager:
> The item '/PPE Test/<customer>/AvgIdleTime' cannot be found.
> (rsItemNotFound) Get Online Help
> The path should be /PPE Test/<customer>/Details/AvgIdleTime but I can't seen
> to get it to work. I have used the same directory structure in VS.NET when
> designing the reports and they work correctly there. How do I specify the
> correct path in VS.NET so that it will be correct when it gets to the report
> manager?|||Thanks Logical...
I know where to enter the path in the report designer. I just don't seem to
konw the syntax to make file paths work.
I have edited the rdl code and can get the drill down to the detail folder
working, but report manager still insists on looking in the same folder for
the charts when I try to jump back up to the chart.
Any help on the syntax would be great.
"Logicalman" wrote:
> You can set the path for the hyperlink in the properties of the chart object,
> I believe.
> This can be absolute of relative to the current report (I prefer absolute at
> this moment in time for RS, but relative in standard webs).
>
> "bugfish69" wrote:
> > I have a main report with 4 charts. I set each chart to jump to a report
> > with it's detail. The main report is in the main folder of the directory and
> > the 4 reports are in a subdirectory call "details". I am getting the
> > following error when I view the reprorts in the report manager:
> >
> > The item '/PPE Test/<customer>/AvgIdleTime' cannot be found.
> > (rsItemNotFound) Get Online Help
> >
> > The path should be /PPE Test/<customer>/Details/AvgIdleTime but I can't seen
> > to get it to work. I have used the same directory structure in VS.NET when
> > designing the reports and they work correctly there. How do I specify the
> > correct path in VS.NET so that it will be correct when it gets to the report
> > manager?

Joining summary data with detail data

I know similar questions have been asked but I wanted to try my luck that my issue is somehow different.

I am querying a database which has detail information (sales transactions) and is grouped by customer. I also have a table with one record for each customer with some historical sales information (summary information). The requirements for the report are to have the sums of the sales for each customer along with the historical data for that customer in the same row in the table. I haven't found a way to do this using one dataset and from what I've read, the current version doesn't support joining multiple datasets over a grouping field (customer).. or at all.

Any one have ideas?

In an ideal world, you would think that you could use SSRS to create the summary information from the detail information. That being said, I have a similar situation where the summary data is not exactly the same information. My summary data is counts by month of eligible accounts. The detail is counts of various rewards by month. I end up having information that looks like

Jan Feb Mar Apr May Jun
Elig 10 12 10 11 8 15
Reward 1 2 1 3 4 1 0
Reward 2 3 3 2 3 2 3
Reward 3 4 1 2 1 0 4

The way I did this was to use a UNION query with constants into a matrix report.

SELECT 0 'Level', 'Elig' Reward, Month, count(*) amt from SummaryTable Group By 1,2,3
UNION
SELECT 1 'Level', Reward, Month, count(*) amt from DetailTable Group By 1,2,3
Order by 1,2,3;

This way the Eligible data (SUMMARY) was at the top and the detail followed.

R