Hi, I've got a crosstab which is showing orders per week and summarizing by month, I want to be able to compare each month's summary to the previous month's summary to do some conditional to do some conditional highlight i.e. if one month's summary is greater than the previous month's, then it...
Hi, I've created a report which connects to a SQL Server 2008 SQLExpress database instance. The report is running fine from the designer, but when I upload it to Infoview, it's giving me an error. I've set up a identical ODBC connection on the machine that the Crystal Enterprise Server is on...
Hi, I've need to connect to a remote SQL Server instance that is not currently on our network. I've managed to get all the relevant ports open (1433) and can ping and telnet to the server. Is there any way to connect to this SQL Server instance via ip address in Crystal Reports?
Thanks.
CR...
Hi, I've need to connect to a remote SQL Server instance that is not currently on our network. I've managed to get all the relevant ports open (1433) and can ping and telnet to the server. Is there any way to connect to this SQL Server instance via ip address in Crystal Reports?
Thanks.
CR...
Hi, is it possible to change the vb code behind a asp.net page once it has been deployed without having to do it in the designer and rebuilding it and having to deploy the whole project again?
Thanks
Hi, I've got some data coming into a Crystal Report (v11.5) and basically the Year field is an integer and the Month field is formatted via the stored procedure as "Jan", "Feb", "Mar"...etc. I've created a bar chart and have set the OnChange values to the Year field in ascending order and then...
Ok, so I'm new to object orientated programming - so I've got a custom class which I've created, within this class I've got some Public properties. Now, say I've instantiated that class in my code behind a page and set the values for the properties, how can I reference those values in the code...
Hi, I've written an ASP.Net application which can read the file properties of a .pdf file, namely from the 'Summary' tab. I've moved a number of these pdf files to a machine running Windows Server 2008 and now these properties have disappeared. How do you get access to these properties within...
I've managed to get ASP.NET to open a local pdf document directly to the browser using the code below. However, I'm trying to do the same thing with a pdf document on my local file system (i.e. C:\test\acrobat.pdf), but I keep getting an error saying that the file does not exist. ASP.NET, IIS...
Hi, am using classic ASP and am trying to execute a stored procedure using ADODB. I'm using a command object and assigning parameters to it, however the stored procedure isn't accepting values from the parameters if they're derived from variables, if I key in the value of the parameter...
Hi, I've got a report that includes the fields 'Updated','Added' and 'Deleted'. These fields are populated with either a 1 or a 0 depending on they're true or not. I'm trying to group the data together in Crystal Reports so that all the rows that have the 'Updated' field set to 1 together and...
I have a table which is meant to contain a certain number of duplicate rows, however due to an error in the flat file which gets imported to populate this table, I've ended up with some duplicates, so for example an entry which should have 19 rows, now has 38. I need to delete just 19 of these...
Hi I'm having a problem viewing Infoview and the Central Management Console. I've just installed Crystal Reports Server XI R2 on a Windows 2003 Server with .Net version 2 and when I go to Infoview or the CMC I get the message "page cannot be found". I can however, get to the pages using the...
Hi, been really struggling with this one - I've got a few records that are listed in time order and by company ID, I need to group them together by company and consecutive minutes to total up the count of minutes, so that if there's an entry for 3 consecutive minutes, the first record of the...
Hi, I've got a report that shows instances of an occurrences by minute, hours, day - what I'm trying to do is, if there is a group of consecutive minutes, to sum these up, but only if they're consecutive - any ideas on how to do this? I'm trying to avoid cursors if I possibly can!
Thanks
Can't seem to get Opera to print a particular frame. The following code works in IE & Firefox:
(tr's the frame name)
parent.tr.print();
have tried:
top.frames['tr'].print();
and:
parent.frames['tr'].print();
but nothing works, just prints all frames, one on each page. Anybody had any...
Is there a way to use a formula to set the 'Detail' section to 'Show' when it has been set as 'Hide(Drill-down OK) - could this formula be run by a link on the report?
Thanks
I've designed a report in the Crystal Reports designer which incorporates several charts in the 'Stacked bar chart' format. When I view the report in the designer, I can hover over a stack section and a pop-up display shows information for that stack i.e. the value. However, when I view the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.