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 Chriss Miller 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: MisterMo
  • Content: Threads
  • Order by date
  1. MisterMo

    using with Y (select * from ....) issue

    Hi guys, this one has stumped me for a couple of days now. this is the query WITH Y AS (SELECT * FROM V_WB_SUMMARY_SALES where DECK = :PLOC) select 'First' as F1, SUM(DL_PRICE) AS TOT_SALES from Y WHERE NOT CW IS NULL union select 'Second' as F1, SUM(DL_PRICE) AS TOT_SALES from Y WHERE CW IS...
  2. MisterMo

    Page refreshing for every parameter change

    Hi Guys, Is there a way to stop the browser refreshing any time you select a parameter? this is not too bad when you only have 1 or 2 parameters but I have many reports with lots of parameters and my beloved users (Bless them) are not too happy with the screen refreshing every time. did I...
  3. MisterMo

    Huge Master.db 49 gig mistery

    we've had problem with our production database and after some investigatigation I notice the the master.db is very big. I have also noticed that 3 of our production tables are in the master.db schema with a disproportionate amount of records compared to the original one eg. our production...
  4. MisterMo

    Page Break after Number of records

    I need a page break after a tot number of records Any Idea on how I could achieve this Thanks -Mo
  5. MisterMo

    This Stored Proc works in SQL 2000 by fails in SQL 2005

    could someone give me a clue of why I get a conversion error in SQL 2005 set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO --Created by Mo for POS Informes ALTER PROCEDURE [dbo].[XLRSP_DailyProductionByShift] @TerminalId varchar(200), -- (till in Restaurant, Supermarket, Bar.....) @StartDate...
  6. MisterMo

    DateTimePicker's coneverting to US dates...... Why

    hi guys SSRS 2005 I am trying to use date parameters for my reports, but for some reason the parameters are changed to US format any time I run the reports I have checked the regional setting on my machine which is running as a server and all seems fine there. does anyone have any idea on how...
  7. MisterMo

    Licencing Issue

    I have built a small class that uses Crystal engine and Crystal Shared classes to convert existing templates reports to acrobat files. This file is pretty small and does not use any of the fancy stuff that can be found in crystal enterprise am I in breach of licence rights by using such file...
  8. MisterMo

    Concurrency issue

    Very new to C# here is the code using System; using System.Collections.Generic; using System.Text; using System.Text.RegularExpressions; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using System.Threading; namespace Acumen.Reports { public class...
  9. MisterMo

    Is there another way to distribute reports other than CE

    I was wondering if there was a cheaper(free)way to do this without breaking the law. Even if this mean having to write your own code. Any ideas or helpfull comment are welcome. -Mo
  10. MisterMo

    Response Time between two dates....with a twist

    Here is the story so far: the user can enter request at any time, however Start time and Response time are only calculated between office hours eg. 9 to 5. response time can be a matter of minutes, hours or even days which will be converted to hours and minutes I did some work with Ken Hamady...
  11. MisterMo

    ReportClientDocument Vs ReportDocument to export reports

    I am trying to export my reports directly to PDF because with RAS you can only view the reports in HTML format and to print they have to be exported first. I am currently using the ReportClientDocument object and everything works just fine, I do need the ReportDocument object to set the export...
  12. MisterMo

    Subreport with Stored Procedure asking for parameters

    Hi guys, This is the question Using CR10 and SQL2K I have a report which use a SP with parameters there ia also a SubReport.. well 2 actually, and they both use a SP with a single parameter each. I have tried various type of linking such as {subreport.Parameter} = {MainReport.Parameter} or...
  13. MisterMo

    View Reports with ActiveX instead of DHTML with RAS

    Hi guys, I can't seem to be able to find any reference in how to set this one up. I am using CE Embedded 10 (RAS) on W2K platform. I have managed to find how to print directly to local printer without having to export to Acrobat files but I would much prefer to ActiveX Viewer. Private Sub...
  14. MisterMo

    CE10 Embedded how to make it work with ASP.NET?

    Hi guys, Due to relative little experience in both CE and .NET I am having the following issue: I am trying to run my reports with CE10 Embedded, and of course all the fancy stuff that you can get with CE Professional is not there. I was wondering if anyone has a sample code to call a report...
  15. MisterMo

    Odd Behaviour when passing parameters in CE10

    Hi guys, I wonder if you have ever encountered this problem: I have published a report in CE (CE10 Professional) and depending on which way I use to retrieve it I end up with all commands useless????? This is the code used to pass parameters to the report which render the report useless: * *...
  16. MisterMo

    0 Concurrent Access Licenses? after installation

    Hi guys, I am having a bit of troubles accessing CE10 after installation. this is the error I get any time I try to logon to the CMC' All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your...
  17. MisterMo

    Concatenate multiple fields if value is not null using IF

    Hi guys I am trying to buld a formula to display only fields with values, I remember in the past (V7), using the if statement with no problems. but for some reason I can't make it work anymore this is the formula stringVar x; x := '' ; if isnull({SPD.MonAMStartTime})= false then x...
  18. MisterMo

    ASP pages and ADO recordset paging routine not working correctly

    Dear all, I have written a routine that retrieve records from the main database using ADO with ActiveX file. This routine is designed to give me the number of pages with a given search based on the number of records I choose to view per page. In my case I want my routine to get 20 records at...
  19. MisterMo

    Printing asp pages with page break and hiding needles information

    I have pages with very long tables and I would like to print them holding the table headers on every page and if possible have some sort of page break when the number of records is greater than a A4 page can hold. I also would like to know if there is a way to avoid printing stuff like URL...
  20. MisterMo

    can i change registry entry using ASP and create a client.CreateObjec

    before I get started whit this idea, does anyone knows if is possible to create client side objects to edit the registry. Probably is just a bad idea, but you never know unless you ask thank for your help Mo Life is like a box of Chocolates..... So is Microsoft

Part and Inventory Search

Back
Top