We would like create a job that would do that following
Create over a 1000 pdf files from a report. So for one company a pdf file would print. It will take 1 to 4 seconds to generate a report. I would have to name the pdf file based on which company and company id its print for. The stored...
Using Crystal 8
I would simply like to display 1.27 as 1.2
In Crystal, the decimal is dependent on the round. So if I set the decimal to 1.0 the round goes to this.
I tried set the number to text (totext(1.277,1) but it shows the $ sign - anyways to remove the dollar sign when doing a totext...
Issue - using Crystal viewer 9 in an application. The reports are created with Crystal 8.0. The export button was working fine until Crystal 8.0 was loaded on the system. Cyrstal 9 view comes up but and the report displays fine but when you click on the export - nothing happenes. Is there an...
I have a formula which is used for grouping, charts and also cross tabs.
numberVar BusSec := {@DateDiff1};
IF
BusSec < 3600 THEN '1- < 1 Hour'
ELSE IF
BusSec >= 3600 and BusSec <=28800 THEN '2- 1 To 8 Hrs'
ELSE IF
BusSec > 28800 and BusSec < 259200 THEN...
I have Crystal 8.0 and am using its Web Component manager to create reports that run off the web. I just downloaded the latest Active X viewer and am having the same issue. The viewer only exports to a .rpt file. #1 I dont want it to export to a .rpt file in the first place but do want it to...
I have a bar chart which displays the average for each individual- now I want to display an average line for the group. It's simply a straight line. I can do this for line charts but cant seem to do it for bar charts (as requested by user) Anyone know if there is such a chart within crystal...
I have had problems with my logon scripts in the example aps pages provided by Crystal Decisions. Getting error on the server in attempting to access the data source. Heres the string I use:
userid = "YOUR_DATABASE_USERID"
password = "YOUR_DATABASE_PASSWORD"...
We have been given the green light to start producing web reports. We have Visual Studio 2003 and Crystal Reports 8.0. These reports will be running off a SQL server. The reports will be used for in house intranet as well as limited internet. My questions are:
* Does anyone know of a good...
We have been given the green light to start producing web reports. We have Visual Studio 2003 and Crystal Reports 8.0. These reports will be running off a SQL server. The reports will be used for in house intranet as well as limited internet. My questions are:
* Does anyone know of a good...
This is what I made last week for the exact same problem works great. Have it set up so you can test in any report:
// use this to text forumla- later remove TestDate (and currentdatetime if apply)and enter the field name(s)
datetimevar TestDate := datetime(2002,12,01);
numberVar BusSec :=...
Thanks Rosemaryl but unfortunately they connect via citrux and then the report is ran. The dabase user is a universal login. Thanks though!! Will keep plugging away.
Is there a way I can pass a NT login name into a report. I want the report to run for each specific user so they wont have to enter their loging name into a parameter (this would allow each person to view other people's data) Any ideas would be helpfull
Actually this is how I am summing up the open calls in the report. The problem is in chart it is summing the totals per week and not adding the previous totals:
Example
Week 1 - 24
Week 2 - 10
Week 3 - 5
What I Want the chart to do is
Week 1 - 24
Week 2 - 34
Week 3 - 39
I have a running...
I want to display a running total in a chart for each week but the only way I can place a week in is "On Change of" which means the running total is reset each week. The running total us simply showing sums of open calls by week and needs to grow each week (as more calls are opened...
Hey all ...need some help in what I thought would a pretty simple running total. Need to do a running total of open calls (which would be considered a backlog).
Group1: Week Week 1
Group2: Team CC
Group3: Emps Smith 20 cases 10 open 3 closed
Jones 21 cases...
Sorry! Knew I should have been more descriptive. The owner will pass in a begin and end date parm. The sproc returns the open/closed dt, then 1 or 0 for new call, closed call,and still open call and tech name. The group is by date time and returns weekly values, and by tech. I placed the...
Group1: Weekly
Group2: Tech
Fields: New calls that week, closed calls that week and backlog.
Backlog are any open calls from previous weeks.
I am importing the data from a stored proc which has dates and 1's for New calls 0 if no, 1's for closed calls 0 for if no. Summarizing is simply...
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.