Jump to Bookmark in reports

Hi,

Please tell me how to implement the "Jump to Bookmark" in reports,
I mean to say, i have to move to another area or page in a report.
Please provide a sample for the same.

Thanks and Regards

Altaf Nizamuddin

Add bookmarks to connect the chart and the data matrix (optional).

Enabling bookmark navigation from chart data points to the data matrix involves two steps. First, define the bookmark IDs within the data matrix. Second, define the jump to bookmark navigation action on the chart data point.

To add bookmarks in the data matrix, right-click the group header of the order year row group and select Properties from the context menu. In the Textbox Properties dialog box, select the Navigation tab and define the Bookmark ID expression by using an expression that generates a string: =CStr(Fields!OrderYear.Value). This provides our bookmark jump targets.

Open the Chart Properties dialog box and edit the data point properties. On the Action tab, select Jump to bookmark, and use the same expression as was used for the bookmark ID.

http://msdn2.microsoft.com/en-us/library/aa964128.aspx

sql

JSP + Reporting 2005

Hi,
whats the best way to implement a Java Servelet/JSP to use reporting
services 2005?
I dont want to use the anonymous access,
is there a way to do this?a kind of proxy like this...
http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
but with RS 2005
greetings
MauroMauro,
Check out this lab: Implementing SQL Server Reporting Services with a Java
EE Application-Building a Reporting Services Solution Virtual Lab
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
Reeves
"Mauro SB." wrote:
> Hi,
> whats the best way to implement a Java Servelet/JSP to use reporting
> services 2005?
> I dont want to use the anonymous access,
> is there a way to do this?a kind of proxy like this...
> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
> but with RS 2005
> greetings
> Mauro
>
>|||tnks veeeery much!
gretings
Mauro
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> escribió en el
mensaje news:E7113029-9686-474C-BF7E-8F37A01D4ABE@.microsoft.com...
> Mauro,
> Check out this lab: Implementing SQL Server Reporting Services with a Java
> EE Application-Building a Reporting Services Solution Virtual Lab
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
> Reeves
> "Mauro SB." wrote:
>> Hi,
>> whats the best way to implement a Java Servelet/JSP to use reporting
>> services 2005?
>> I dont want to use the anonymous access,
>> is there a way to do this?a kind of proxy like this...
>> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
>> but with RS 2005
>> greetings
>> Mauro
>>

Joins in Crystal Reports

Hi,
I'm newbie in Crystal report. I've a query which i'm unable to implement in CR. Eventhough the query looks simple because of the join condition I'm struggling . Pls help me to implement the join condition. I run the query in DB2

select sum(bank_ledger_bal_amt),calendar_date
from table_a a
inner join table_date b
on a.bank_acct_eff_dt <= b.calendar_date
and a.bank_acct_disc_dt > b.calendar_date
where month_id = 'feb'
group by b.calendar_date
order by b.calendar_date
;

Thanks,
JashUse the add command of Crystal and paste in your SQL query in there.
GJ|||Sorry I didnt get what do you mean|||In the Database Expert there is an option to select "Add Command" there you can type out your sql. Crystal will let you know if there is an error in your SQL.
GJsql