Recent content by Duckie66

Hi, Thank you all for your answers. Actually I have BOEXI installed too as I have tested it for a while. I guess the BIAR archive is the one bleuys is pointing at. Creating that kind of archive file could be the easiest way to get some kind of snapshot what do I actually have in my repository...

Hello, Is it possible to get all the report objects published to the CE10 database dumped somehow? I mean that the report objects would be back in .rpt format and they could be e.g. uploaded again to the server in case of disaster etc. I guess that this could be done somehow with the ce java...

Hi, I'm using CE 10 with IIS 6. Is there any possibility to change report parameter values via .ASP? For example, if there were one parameter raport in Enterprise, it would be possible to show that one report as two different versions via .asp - files. And there wouldn't be need to modify...

Synaps, thank you for your answer. My data is based on hours so record count will be large - I have to just accept that. But now I'm going to continue with on-demand subreport. One q conserning that: Is it possible to use drill down menu with subreports? For example, in this case, would it be...

Hi, I have an instance performance problem that I'm hoping someone can help with. I'm using CE10 with RAS, database is MySQL 4.1. I have scheduled about 30-40 reports to run daily overnight. This is done by 3 Report Job Servers and instances are ready in the morning. The smaller instances...

Ok.. It seems that my grouping is still unclear. Week 1 - Monday - Tuesday - Wednesday Week 2 Week 3 ... ... Week 52 <-- that would be status if there were more than one year. So every year is shown in its own bar in a graph. There can't be more than 52 weeks (actually more than...

Ok, I'm sorry my terrible English.. Let's try again :) Those solutions that you gave earlier worked just fine. I just wondered how to include to running total the earlier years too. If looking on week 3 for example, it would show sum from previous 52 weeks (until week 4 / 2003). It would be...

lbass, your assumptions were correct. I'm been busy for a while and therefore I couldn't answer. Today I tried your formula and it worked just so nicely. You wondered my report design - I have a week & day groupings only. So there are several years in the database but I want to group them...

Thanks lbass, running total really carry forward the value. I'd like to change that #week1 to #weekno-1... So the value in the running total would be always from the previous week - So week 8 would be compared to week 7 etc. Is that possible? And you seem to handle these tricks so I have to...

Hi, I'm using CR9 with MySQL4.1. Current grouping: - Week 1 - Monday - Tuesday - Wednesday - Week 2 - Monday - Tuesday ,i.e based on week number and dayname. I need to show the development percent from week 1's data in week 2 header ((week2 - week1)/week1*100). The problem is...

Hi, I'm using Crystal Enterprise 9 & RAS on IIS6. I'm connecting to my reports via .asp and I'm calling Interactive Viewer there. Is it possible to set the drilldown-tree open when loading the page? So tree would be already open when the page appears on screen. I know the sources of the...

Hi, As subject says, I'm trying to retrieve the last distance of specific raport dynamically. The reports are scheduled and that part is currently working well. But the problem comes when there are more than one instance because my .asp retrieves only the first and oldest one. I'm using the...

Hi, I'm using Crystal Reports 9 & RAS on IIS6. I'm publicing my report with interactive viewer. Is it possible to set the drilldown-tree open when loading the page? So tree would be already open when the page appears on screen. Is there any setting to do that? -Duckie

Hi, I'm using Crystal Reports 9 & RAS on IIS6. I'm publicing my report with interactive viewer. Is it possible to set the drilldown-tree open when loading the page? So tree would be already open when the page appears in asp. Is there any setting to do that? -Duckie

Hi! I'm currently authenticating users in with my PHP script. Usernames and passwords are red from the sql-database as well as users homedirectories. I want to use one shared login-page for all the users and then redirect them to their homedirectories. I'm using IIS 6.0 (Windows Server 2003)...