Report with mulpitle Charts

[icanmakeiteasy]

Hi friends, help me to get multiple reports i have created two crystal reports, one using 'bar chart' and second using 'pie chart', i have implemented in two different web pages, then the result is exported to two individual pdf files... now, user asking me to build the two charts in one pdf file only, in 2 pages :( how can i ?? do some needful friends...

icanmakeiteasy

[T M Gray]

Combine the two PDFs using a .Net PDF manipulation library like iTextSharp.

[icanmakeiteasy]

Location_id Parent_id Location_name
29 3 Rahway, NJ (Time Zone:EST)
3 0 United States
30 29 126 E. Lincoln Avenue
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd
31 30 Rahway
32 3 West Point, PA (Time Zone:EST)
11 6 One Merck Drive
12 11 Whitehouse Station
33 32 770 Sumneytown Pike
34 33 West Point
35 0 United Kingdom
36 0 Germany
37 36 Munich
38 37 85540 Haar
39 38 Lindenplatz 1
40 0 Japan
41 40 Tokyo
42 41 Chiyoda-ku
43 42 Kitanomaru Square
44 43 1-13-12 Kudan-kita-Room 1425-E
45 0 Singapore
46 45 #10-03/10 Parkview Square
47 46 600 North Bridge Road-188778
48 3 San Francisco, CA
49 48 Sirna-SF-314
50 0 Brazil
51 0 Italy
52 51 Rome
53 52 VIA PONTINA KM 30, 600
54 0 Canada
55 54 16711 TRANS-CANADA HIGHWAY
56 55 Montreal H9H 3L1
57 48 1700 Owens Street, 3rd Floor - 94158
58 3 Boston, MA (TimeZone:EST)
59 58 33 Avenue Louis Pasteur
60 59 Boston

question is how to get United States child location?
relation is,
United States ID is 3,
so find out all the parent_id with '3'
ex:[North Wales, PA (Time Zone: EST)] parent_id is '3' location_id is '5'
now if any location's parent_id is '5', then that is also UnitedSates children

3 0 United States
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd

how to get all the locations under 'United Sates'

icanmakeiteasy

[kiranu eepuri]

U can try this ------------------ DECLARE @Location_ID INT SELECT @Location_ID = 3 ;WITH ret AS( SELECT * FROM Locations WHERE Location_ID = @Location_ID UNION ALL SELECT t.* FROM Locations t INNER JOIN ret r ON t.Parent_ID = r.Location_ID ) SELECT * FROM ret

[icanmakeiteasy]

DECLARE @Location_ID INT
SELECT @Location_ID = 3

;WITH ret AS(
SELECT *
FROM Locations
WHERE Location_ID = @Location_ID
UNION ALL
SELECT t.*
FROM Locations t INNER JOIN
ret r ON t.Parent_ID = r.Location_ID
)

SELECT * FROM ret

icanmakeiteasy

[icanmakeiteasy]

Error here Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'WITH'.

icanmakeiteasy

[icanmakeiteasy]

function asdf() {
getScrollHeight();
var obj = document.getElementById("popup");
obj.style.display = "block";
obj.style.top = getScrollHeight();
obj.style.left = 200;
}
function getScrollHeight() {
var h = window.pageYOffset ||
document.body.scrollTop ||
document.documentElement.scrollTop;

    return h ? h : 0;
}

icanmakeiteasy