Crystal Reports Group box vs SQL Reporting Services Bookmark box

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Group box vs SQL Reporting Services Bookmark box

Author	Message
petermeadit Newbie Joined: 30 Nov 2006 Location: Australia Online Status: Offline Posts: 6	Topic: Group box vs SQL Reporting Services Bookmark box Posted: 30 Nov 2006 at 2:45am
	Hi, My name is Peter Mead. I have started a job where they have a bunch of Reports written using SQL Reporting Services. My job is to convert these reports in to Crystal Reports to be used in an Enterprise Reporting methodology. The first problem I have is that SQL Reporting Services viewer has a Bookmark box down the left hand side. This Bookmark box looks like a Group box but does not function in the same way. SQL Reporting Services designer allows for the creation of any definable bookmark to be placed in this Bookmark box. How can I replicate or emulate this Bookmark box? Thanks in Advance,
	Peter Mead : www.petermeadit.net
	IP Logged


BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 30 Nov 2006 at 11:24am
	Hi Peter, Unfortunately I haven't seen a bookmark feature in CR. Can you tell us why your company is switching from SSRS to CR? This would be very helpful for people who are debating which reporting platform to use. Thanks, Brian
	IP Logged

petermeadit Newbie Joined: 30 Nov 2006 Location: Australia Online Status: Offline Posts: 6	Posted: 30 Nov 2006 at 2:35pm
	Hi Brian, SSRS is the company’s preferred reporting package. However some clients of the company will only accept reports that are developed using Crystal Reports. The team manager has fully developed a suit of reports in SSRS and they want to replicate as much as possible. Another feature that I have tried to replicate is the ability to add Clickable Expandable/Collapsible Regions within the report. These sections have a +, - to click on and then the section dynamically expands/collapses to reveal/hide the content within the report. Any ideas how this behavior could be replicated? Thanks,
	Peter Mead : www.petermeadit.net
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 30 Nov 2006 at 3:40pm
	You can create groups and the group can either be hidden or visible. When the user clicks on the group header it can expand the group detail to be visible. Usually groups are based upon report data, but you can mimic a fake group with formulas to simulate what you are looking for. Not sure if this helps, but report parts let you break up a report into different objects and then treat each object seperately. You can view these objects without looking at the rest of the report. You can also use report objects to add navigation to a report (similar to your bookmarks?). Here is a link to a PDF file which gives you more info on Report Parts. http://support.businessobjects.com/communitycs/technicalpapers/cr9_report_parts.zip.asp
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 30 Nov 2006 at 5:14pm
	Crap. I just typed in a whole bunch of stuff and my browser lost it (and I need to run). Damn. Anyway, the short of it is to right-click on an object and select Format. Then click on the Hyperlink tab and click help. After some digging it tells you the steps for linking to other places in your report. I haven't done this before, so I need to study it as well. HTH, Brian
	IP Logged

petermeadit Newbie Joined: 30 Nov 2006 Location: Australia Online Status: Offline Posts: 6	Posted: 30 Nov 2006 at 6:08pm
	I feel like I need to go in to more depth with these two main topics so I have started two new topics one called ‘Expandable/Collapsible Regions within the report’ and the other: ‘Linking to other places in your report’. I’d love to continue the discussion on these topics. Thanks so much, Peter Mead
	Peter Mead : www.petermeadit.net
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum