Search results for query: *

Hi all, I would like to know if this is doable: Date parameter: Begin Date Date parameter: End Date If begin date is 2/1/2013 and end date is 2/5/2013, I would like the report to group the following: group header: 2/1/2013 record 1 record 2 group header: 2/2/2013 record 1 record 2 ...

Hi experts, I would like to not suppress the last group footer 2b on each group so it can act like a group footer 1 when I do a manual sum. Now Group footer 2a (group by name) Group footer 2b Group footer 2a Group footer 2b Group footer 2a Group footer 2b Become July Group footer 2a Group...

Hi, Is there a formula where I can convert total days into year and months? For example, the total days are 2176, and it is approx 5 years and 10 months. Thanks

You are right. I didn't specify it clearly. I already removed all the borders and format from each subreports, and I suppressed all sections within the subreports. This is where I'm having some formatting issues. Since there will always be a value coming from those subreports and those...

Hi, I have a report which linked with 7 subreports. Basically, group header 1a has all the subreports embedded and the data from the sub-reports are passed to the formulas I created on group footer 1a. The subreports itself are suppressed, but not the group header because if I suppress the...

Hi, Can a master report be sorted from the number value that is passed from a subreport? OR if I have a multi-instance table and I have grouped by unique ID. I've created a runningtotal to totalup the value within the unique ID and I need to use that number to subtract from another value...

Thank you so much. It works perfectly!! =)

Is there another way of doing this that could pass the page number over to a summary directory report without using a subreport? My purpose is that the master report consist of different sorting with many formula and the user would like to get a directory report with a page number from the...

Hi, If I have a master report with page number on each detail and I would like to create a summary directory page for that report. How can I pass the page number from master to my subreport? Thank you.

Hi, I am using Crystal 10. Is there a way where I can keep group together from running a Cross Tab? I do not want a group to split between pages in a cross tab. Thanks!

Sorry. It's 10G Enterprise Edition Release 10.2.0.4.0

Hi, I'm using CR 10 and Version 9 for Oracle. Thanks

Hi, Does anyone know how to link tables with 2 different data types? One is a string and the other is an integer. I got some information online that I can link in formula editor and change the data type through SQL. I never done it before so I have no idea where to go about this. Can anyone...

It works. Thank you very much! =)

I tried that and it worked. But now I have another problem. Main Report Group Header 1a- Subreport with Year, ID, rate Group Footer 1b- All main report fields along with 2 rate (1 rate from main report, 1 rate from subreport) I need to suppress 1a and 1b at the same time if the rate from main...

Hi, Does anyone know if I could use the data from subreport in my selection criteria on my main report? The reason I need to create subreport is because there is no direct linking. I need to create few formulas in my main report in order to link a different table and pull in the appropriate...

Yeah, but I cannot put dummy data into the excel file so I'm wondering if there is any better ways to do it besides sorting the column desc to show at the top everytime. Thanks

Thanks for your quick respond. There are around 6 or 7 items, so I'm wondering if that can be done automatically via cross tab built-in functionality.

Hi, Is there anyway to create the following Cross Tab report ItemA ItemB ItemC SubTotal(ItemB+C) Total Total% Jan 1 2 3 5 6 5/6=83% Feb 2 3 4 7 9 7/9=78% Thanks

I have a problem when I run Crystal report from an excel file where the field from excel would become blank if the value of the field is not at the top. For example, an excel would contain 20,000 records and if the first value of the excel field is at the bottom, then when crystal report runs...