Search results for query: *

Hi All.. I thought this is a simple problem but then I just realize that I cannot do it. Need to know if I am missing something here or is there a possible way of doing it. Problem: I have a summaries of group headers: Eg. Grp 1 - 2000 Grp 2 - 4000 Grp 3 - 1000 Grp 4 - 5000 I need to...

Hi All, I have been reading many post about passing parameter values into a Stored Procedure but doesn't seem to find a way to do it. Can someone please point me to the right direction? I am looking into using a passing parameter values into a stored procedure. My actual problem is this...

Hi All.. I have been using Crystal Report for a while, and I must say this forum has helped me a lot in my troubles or challenges. However, this next challenge I have is something I have no experience at all and am trying to grasp the concept on how to do it. As mention above, it is...

Hi All. I have a Crystal report where it is taking it's data from a stored procedure of SQL Server 2000. Problem is now that when i deploy the report, I would also have to deploy the stored procedure separately. This basically would cause version issues and possible problem if one forgets...

Hey guys, I have been searching high and low for a solution. I hope you guys can help me on this. Here is the case: 1 table with duplicate SSN TableName: CustInfo Name SSN CustNO Flag ----------------------------- Ali 1120 78643 Ali 1120 98732 Sammy 345 36791 John 09212...

Hi guys, I need an easier way to copy and edit a DTS. Currently I have a DTS with probably about 50 SQL task. Each task of course has SQL statments. Every time, I have a new customer, I have to go into every of this single task and change the name of the DB that I associate them with. this...

I have a very weird data transformation problem.. I have been using a DTS to transform a text file into a table. The Text file usually has about 700K records. It seems to be doing fine everyday, except today when it transforms only 345K records. However, if I do repeat this process manually a...

Hey guys, I am a newbie with DTS and I hope you can help me with this problem I have. I am running a about 4 sql statements on a few tables to check the integrity of the tables. These statements are basically checking for duplicates and some other conditions. Let me mention that the data was...

Guys, I need your help in giving your 2 cents with my report here. I figured that I have to do a manual cross tab report of over 300 formula fields. Please take a look and let me know if there is a more efficient way of doing this report. ACTIONS/HR...

Guys, I would like to create a summary on the report footer and based on the details, I want to automatically have the right summary. This is basically what I have in my details. Not using any grouping. Item No. Invoice No. Product Type 1 1234 Type1 2 5466...

Guys, I have been surfing around for this question and did not seem to be able to find it.. This is my script in my xsl.. <msxsl:script language="VBScript" implements-prefix="user"> <![CDATA[ Function theDate(NODE) thedate = NODE & "January" End Function ]]> </msxsl:script> And...

Hey guys, I have a question here which seems easy enough yet, I could not put it together after reading the posts here. I need to create a report as such. Report is group by Item ID and I was trying to use running totals for the counts below. # of Items today # of Items MTD # of...

I have a problem with running totals. Actually I have also tried using summary totals and it still produce the same result. Running out of ideas what to troubleshoot. Group by ID No. of Items where status=2 101 320 107 120 108 90 110 800...

Crystal Ver 10 Microsoft SQL Server Guys, I really need help here, I have read through the forum and have believe that I did everything but I still could not produce the report. 2 tables with outer Join Link : Table Item and Table Acct Report is group byItem ID and displayed in the Group...

I have 2 problems here but are somehow related in CR9. 1) How do I set my running total field to display zero, if it did not total up any values? 2)In a formula, I have {#RT1} + {#RT2}. However, if either one of this field's value is null, my formula result will be null as well. How do I get...

Hey guys, I look through the forum and can't seem to find a possible solution to my problem or at least I am not sure of how to work it. CR : Version 9 DB : Proprietory Objective: To display report data in multiple columns. Sample data: account Acct Amt 10410321 100.00 10410321...

Using Crystal Report 9, I am looking for a way to simplify this process, if there is any. I have one sub-report, group by Days. I have to link this sub-report with various other Main Reports which will have different condition to link the sub-report.Let me try and paint a picture here...

Hi. I am using CR 9 and am looking for an alternate way of displaying a part of my report. Let me explain the scenario. I have 40 fields.. Price.TP1, Price.TP2, Price.TP3..Price.TP40. I would like to display a summary count and a summary amount for each of them. Display will be such as...