Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tjw2006
  • Content: Threads
  • Order by date
  1. tjw2006

    Difference between two summaries in a Crosstab

    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...
  2. tjw2006

    Compatibility

    Hi, does anyone know if Crystal Reports Server XI (R2) can run on Windows Server 2008? Thanks
  3. tjw2006

    Compatibility

    Hi, does anyone know if CR XI R2 can run on Windows 7? And also if it can report on and connect to a SQL Server 2008 database? Thanks
  4. tjw2006

    ODBC connection error in Infoview

    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...
  5. tjw2006

    connection via ip address

    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...
  6. tjw2006

    Connecting via IP address

    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...
  7. tjw2006

    Changing code on the fly

    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
  8. tjw2006

    Bar chart order by Year & Month problem

    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...
  9. tjw2006

    Custom Class property sharing

    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...
  10. tjw2006

    Extended File properties problem

    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...
  11. tjw2006

    Opening remote binary document

    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...
  12. tjw2006

    strange ADODB problem

    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...
  13. tjw2006

    Help with Grouping

    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...
  14. tjw2006

    Deleting just some duplicates

    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...
  15. tjw2006

    .Net on Crystal Reports Server XI R2

    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...
  16. tjw2006

    Need a query to group by consecutive minutes

    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...
  17. tjw2006

    Sum of minutes

    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
  18. tjw2006

    Printing a frame from Opera (v.9)

    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...
  19. tjw2006

    Show Detail

    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
  20. tjw2006

    Stacked bar chart - pop-up

    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...

Part and Inventory Search

Back
Top