Link to home
Start Free TrialLog in
Avatar of Mounikaa
Mounikaa

asked on

Bookmark in ssrs

Hi,

I need to display bookmark for date fields which are having data for the upcoming month.

Can you please help me regarding this.

Please let me know if you have any questions.

Its urgent!!
Avatar of Mounikaa
Mounikaa

ASKER

Hello..

Any body is there to help me!!

Every time I post a question I am not getting any response.

Please help me..
I don't understand what you want to display.  Are you listing a bunch of dates and want to change the appearance of ones that have data to for that date?
Can you tell me bookmark syntax?
and how to use that
I want to display the bookmark for dates. i.e. listing bunch of dates that have values in report
Try this page and see if it helps out ... I assume that you are speaking of the Bookmark property
http://www.exforsys.com/tutorials/ssrs/create-bookmark.html
 
I have to create a bookmark as per the link.

But, have you worked on ssrs 2008?
I am not seeing bookmark id where I have to give the expression to jump to specific portion of the report.
please help me!!

LET ME KNOW IF U HAVE ANY QUESTIONS..
DO u have any idea about displaying distinct fields in ssrs?
Please reply...
Somewhere on the report there has to be a place to select the date that you want to jump to. Where is this place going to be ... In the parameter bar at the top?
Distinct fields in SSRS are pretty simple ... create a dataset
SELECT DISTINCT Column1 FROM Table1
just put it in a table by itself, or assign to a parameter for user selection
Hi aelliso3,

Thanks for the solution for the distinct.

That workes for me.


For the bookmark one:

I have created 2 different list reports in the same report.
One is for only distinct dates
other one is for the report with all the data.
I have to create a bookmark so that I can jump from distinct dates report to another report according to the dates.
i.e. if I click a date in one report, I have to go to the specific location in the second list report.

Hope you understood.

Please help regarding this.
I believe that I know what you are trying to do, but you kind of have to trick the system a bit. I do not believe that you can put bookmarks on a datetime datatype field. However, you can convert that to a varchar field in your SQL query. On the list that you would select the date from, Right click and go to TextBox Properties --> Action and select Go To Bookmark then select the bookmark field to use. On the list that has the date that you want to jump to, select the box that has the field in question, and in the properties window, you'll see an option for Bookmark. In there, select the Date field that you want to use.
what is the syntax for setting bookmark?

"Bookmark" & field.value

Was the above one correct?

I think I need to give sam esyntax at both places.

Please correct me if I am wrong.

you should be able to select it all in the drop down list ... but it would be
=Fields!DateField.Value
Is that the same for both fields?

Infact I tried that too.
[rsInvalidExpressionDataType] The Bookmark expression used in text box ‘FROM_EPOCH_TIME_CHANGE_BEGINS_2’ returned a data type that is not valid.

I am getting the above error
Can we apply bookamark on group?
Well ... like I said before ... you cannot use a date as a bookmark. It's one of those strange quirks about SSRS, so you'll have to handle that in the query ...
example:
convert(varchar(10), DateField)
 
This goes into the stored procedure, view, or query that is in your dataset
can you give me the exact syntax to convert the date fields?

if you can supply the query that drives the report, then that shouldn't be a problem.
CREATE OR REPLACE
PROCEDURE DISTINCTDATE

(OUT_CURSOR OUT SYS_REFCURSOR )
as

 CurrentDate DATE;
StartDate DATE;
 EndDate DATE;
 
 BEGIN
 
 CurrentDate := TRUNC(SYSDATE);
 StartDate := CurrentDate +1;
 EndDate := CurrentDate +31;
 
  OPEN OUT_CURSOR FOR
 SELECT DISTINCT FROM_EPOCH(Time_Change_Begins)
      FROM TABLE
      WHERE  FROM_EPOCH(Time_Change_Begins) >= StartDate
 AND FROM_EPOCH(Time_Change_Begins) < EndDate;
 END DISTINCTDATE;
Sorry ... I forgot that your datasources are Oracle and I do not know that syntax ... The best advice that I can give is to post that code to an Oracle thread and see if someone knows how to convert the date to varchar. Judging by the error that you are getting, I think you got the SSRS part correct.
I have one more doubt.

Will my report work if I convert date to varchar?

Coz, I need to get data for upcoming month. So I 've used date fields here.

Will my report going to give data if I convert them to varchar?

Please let me know...
ASKER CERTIFIED SOLUTION
Avatar of aelliso3
aelliso3
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

Thanks for spending time for me.

I got the solution without converting them to varchar

Anyways,

Thanks very much..