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