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!!
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!!
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?
ASKER
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
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
http://www.exforsys.com/tutorials/ssrs/create-bookmark.html
ASKER
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..
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..
ASKER
DO u have any idea about displaying distinct fields in ssrs?
ASKER
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
SELECT DISTINCT Column1 FROM Table1
just put it in a table by itself, or assign to a parameter for user selection
ASKER
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.
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.
ASKER
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.
"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
=Fields!DateField.Value
ASKER
Is that the same for both fields?
Infact I tried that too.
Infact I tried that too.
ASKER
[rsInvalidExpressionDataTy pe] The Bookmark expression used in text box ‘FROM_EPOCH_TIME_CHANGE_BE GINS_2’ returned a data type that is not valid.
I am getting the above error
I am getting the above error
ASKER
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
example:
convert(varchar(10), DateField)
This goes into the stored procedure, view, or query that is in your dataset
ASKER
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.
ASKER
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_Beg ins)
FROM TABLE
WHERE FROM_EPOCH(Time_Change_Beg ins) >= StartDate
AND FROM_EPOCH(Time_Change_Beg ins) < EndDate;
END DISTINCTDATE;
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_Beg
FROM TABLE
WHERE FROM_EPOCH(Time_Change_Beg
AND FROM_EPOCH(Time_Change_Beg
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.
ASKER
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...
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks for spending time for me.
I got the solution without converting them to varchar
Anyways,
Thanks very much..
Thanks for spending time for me.
I got the solution without converting them to varchar
Anyways,
Thanks very much..
ASKER
Any body is there to help me!!
Every time I post a question I am not getting any response.
Please help me..