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 TouchToneTommy 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: *

  1. scouser

    report not showing data from fields - blank report!

    Earme Actually, I never did get to fix the problem because it rectified itself eventually! Strange that....! Have you tried getting the program to flag up the error meesage number? Is there any error message? Shirley
  2. scouser

    CR seems to conflict with my program that also has CR - why?

    hi Thank you for you response. Our company is using version 8 and the users are also using version 8. A blank page is produced. We have added code to the Visual C++ program to return an erorr message but all we get is an error code of 0 which does not provide us with much information
  3. scouser

    CR seems to conflict with my program that also has CR - why?

    Hi all I have asked this question before but still have not solved this problem - so I apologise for bringing this up again! OK, to cut a long story short. My company has developed a piece of software that outputs Crystal Reports. However, on certain OS e.g. Windows 98 and NT (but it is OK on...
  4. scouser

    does CR (or it's associated files) conflict with itself?

    will do - we are still investigating this and waiting for the user to respond :) Thanks for all your help so far!
  5. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken Yes, it seems to affect the reports that has subreports. The other reports that do not have subreports are running OK. Shirley
  6. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken Yes, we checked the version of the dll's as well. 3 of the dll's were updated and they remained after the uninstall and generated the report with no problems. Shirley
  7. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken Assuming the module program is correct, there was no change in the list active dll's before and also after installing and unistalling CR. So, it is not the dll's after all! Thank you for the article. I will need to go through the list to see what the software conflict may be...
  8. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken My colleague used the module to check which active .dll's were used before installation, after installation and after removal. However, these tests proved inconclusive. The dlls that were updated during installation remained after installation but the reports worked (after...
  9. scouser

    does CR (or it's associated files) conflict with itself?

    Thanks Ken - I never knew that this handy utilty exists!
  10. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken It is a commercial app and both the user and our company use version 8. And we used version 8 to test the CR. There is no conflict with Windows 2000, only Windows 98 and NT as far as we are aware. Shirley
  11. scouser

    does CR (or it's associated files) conflict with itself?

    Hi Ken Thank you for your reply. Error message was "Print Job 0" - were the error code is 0 and "print job" was hard coded. As you can see, the error code does not really shed any light. When the reports are run, it is always done through the application as parameters...
  12. scouser

    does CR (or it's associated files) conflict with itself?

    Hi We have developed some software with Visual C++, on Windows 2000 platform which has a lot of reports. However, we have discovered that if Crystal Reports software is installed on a Windows 1998 or NT machine it causes certain reports with sub reports not to run. When the CR program is...
  13. scouser

    Newbie asks how to back up or reduce transaction log

    Hi I am quite new to SQL, using all the online help seems to give me theory but not a simple answer to a simple question! How do I back up the transaction log as this is stopping me from doing any work on SQL! What is the name of the transaction log, is it visible? Where can I find it...
  14. scouser

    CrossTab - HELP - as I cannot use sum...........!

    Thanks for your help! I will try using case in the query designer
  15. scouser

    CrossTab - HELP - as I cannot use sum...........!

    hiya I also forgot to show you the SQL I used, I need to save the view, but the query deigner does not support the "SQL CASE contruct", but it does run.....only two subjects being crossed here in the example. SELECT [Pupil Name], MAX(CASE WHEN tblSubject = 41 THEN ks1_level ELSE...
  16. scouser

    CrossTab - HELP - as I cannot use sum...........!

    Hi Thanks for your response. Yes, there is a table that matches subject code with the subject name e.g. 41 = reading, 42 = Comprehension. I was thinking of using an alias? Yes, I would need to show all subjects (7), I was limited by space in the example:) And if a pupil does not have a...
  17. scouser

    CrossTab - HELP - as I cannot use sum...........!

    Hi Terry Thanks for your reply. I only have just started SQL (from an Access background). Any help would be appreciated. The data is like this (the subject is actually as a code number but will be assigned the actual subject name). I think the matter is complicated by the fact that the...
  18. scouser

    CrossTab - HELP - as I cannot use sum...........!

    Hi there, Can anyone help me? Yes, I know there are a lot of answers regarding 'crosstabs' for SQL but I cannot use these examples as I cannot simply sum the columns as I have strings as well as numbers in my data. Is there anyway I can get around this without using third party software? I...
  19. scouser

    hide / suppress graph legends and zeros?

    hello there Is it possible in CR8 to conditionally hide/suppress the graph legend? Also, can you hide bars with 0 value? (I have the value showing outside the maximum at present?) Can anyone help - thank you in advance Shirley

Part and Inventory Search

Back
Top