How to make hyperlink in crystal report + asp.net

[wilang]

Hi all,
i have some problem when using crystal report in asp.net.
Before this,i never use crystal report.
i am still newbie in CR.

My master report format like this

Type | January | February | March
========================================
xxxx |1500 | 0 |1500
yyyy |1800 | 1200 |1230
zzzzz |1200 | 0 |1400

this report have detail report . the detail report will contain details of month and item. Like xxxx in January,xxxx in February...
i 've made some detail report for Master report. The problem is,i don't know how to call Detail report from master report.
i want my report can call some sub report in new page when i clik some number in my report. so when i clik number 1500 in Column January,the report will call another report dan pass some parameter like 'xxxx' and 'January'.
is this possible in Crystal report?
i have search ,but still not find a clue. can some one give me clue? because i never use CR. this problem make me confuse.

[gep13]

This isn't quite implemented as a new window, but certainly, this is part of the solution:

http://csharpdotnetfreak.blogspot.co...in-aspnet.html

Hope this helps!!

Gary

[danasegarane]

Yes its possible.
1.Right Click the Column with 1500 and Choose format field option
2.From the Insert menu.. Select Sub Report
3.Create report using Report Wizard and give a valid name
4.Check the OnDemand report check box

[gep13]

Good stuff.

I knew there must have been away, but I haven't really played with CR

Gary

[wilang]

i will try it first. hope it can be solution for my problem.

[wilang]

Weks....
it failed. because when i call master form contain master report, it always appear some text box, ask parameter for detail report.


still research....

[danasegarane]

Weks....
it failed. because when i call master form contain master report, it always appear some text box, ask parameter for detail report.


still research....

Post the steps you done..

[wilang]

ok. I will explain my step:
1. i am using visual studio 2008 and using crystal report in visual studio 2008.
2. first i choose menu crystal report -->insert-->subreport.
3. appear some menu ,i choose crystal report in project, i choose report name and i check on-demand subreport (similiar to hyperlink) and i click Ok. the hyperlink appear.

the problem is i don't know how to pass parameter for detail report when i clik the number in master report.
i search but still don't find it.

[danasegarane]

1.Right Click the Sub Report and Choose the Change Sub Report Option
2.Form the pop up select the Appropriate fields
3. In the attached screen shot , If the user click the Order ID , that will display the Order Details.

[wilang]

i have try it, but i confuse because the detail report need 2 parameter.
1.Type,2 Month.

parameter Type,i can link from master report. But parameter Month, i cannot find in my master report because my master report structure like pivot table.

[gep13]

Can you provide full details on the report structures that you are using?

Gary

[danasegarane]

i have try it, but i confuse because the detail report need 2 parameter.
1.Type,2 Month.

parameter Type,i can link from master report. But parameter Month, i cannot find in my master report because my master report structure like pivot table.

You can supply two parameters. For the second parameter create one parameter Field and pass value to that parameter

[wilang]

hi all,

the structure my detail i want like this when i clik number 1500 in month January. i forgot to tell you, the report detail need 3 parameter (sry ,i forgot the third parameter) :
1.Type
2. Month
3. Year

so when i retrieve the detail report,i will select table and filter by type,Month, and Year
the "detail report" will be like this :

type | date | transaction
======================================
xxxxx |2010-01-23 |10000
xxxxx |2010-01-26 | 500

hehe2x!!

the problem is,in my master Report, there is no month value,because my master report does not have month parameter.

to make easier i already make some query table for u to try:
hope from this,u will know why i can't pass parameter month to detail report

--1 create table
create table trans
(
type varchar(20),
Tgl datetime ,
Value numeric
)

--2 insert table
insert into trans values ('xxxx','2010-1-23','200')
insert into trans values('xxxx','2010-1-24','400')
insert into trans values('xxxx','2010-1-25','300')
insert into trans values('xxxx','2010-1-26','500')

insert into trans values ('yyyy','2010-1-23','100')
insert into trans values('yyyy','2010-1-24','400')
insert into trans values('yyyy','2010-1-25','200')
insert into trans values('yyyy','2010-1-26','400')

insert into trans values('zzzz','2010-1-24','300')
insert into trans values('zzzz','2010-1-27','800')
insert into trans values('zzzz','2010-1-28','600')


insert into trans values('xxxx','2010-2-23','200')
insert into trans values('xxxx','2010-2-24','0')
insert into trans values('xxxx','2010-2-25','0')
insert into trans values('xxxx','2010-2-26','500')

insert into trans values('yyyy','2010-2-23','100')
insert into trans values('yyyy','2010-2-24','400')
insert into trans values('yyyy','2010-2-25','0')
insert into trans values ('yyyy','2010-2-26','400')

insert into trans values('zzzz','2010-2-24','300')
insert into trans values ('zzzz','2010-2-27','0')
insert into trans values('zzzz','2010-2-28','600')

insert into trans values('xxxx','2010-3-23','200')
insert into trans values ('xxxx','2010-3-24','440')
insert into trans values('xxxx','2010-3-25','550')
insert into trans values('xxxx','2010-3-26','500')

insert into trans values('yyyy','2010-3-23','100')
insert into trans values('yyyy','2010-3-24','400')
insert into trans values('yyyy','2010-3-25','60')
insert into trans values('yyyy','2010-3-26','400')

insert into trans values('zzzz','2010-3-24','300')
insert into trans values('zzzz','2010-3-27','770')
insert into trans values('zzzz','2010-3-28','600')

--3 my query for master report
select Type,( select sum(Value) from trans b where b.Type=a.Type and month(tgl)=1)as 'January',
(select sum(Value) from trans b where b.Type=a.Type and month(tgl)=2)as 'February',
(select sum(Value) from trans b where b.Type=a.Type and month(tgl)=3)as 'March'
from trans a
where year(Tgl)='2010'
group by Type

sry if my image does't match with query i give to you.