Search results for query: *

I am a serious new guy to rpg programming on an iSeries all i really want to do is have a simple insert statement run in an sqlrpg le program. I am planning on moving SQL to a stored proc later but i just wanted to learn the basics first. C/Exec SQL C+ SELECT * FROM MYLIB/CUSTMST C/END-EXEC I...

I talked with the guys at business objects and they advised me to not play with the CMS tables. After looking at the tables in depth I agree. They have pointed me into another direction they have some developer SDK's which i can use to create my own program to do essential what I am looking for...

What table would it be in CMS?

I have a table with a list of users and passwords in a SQL Server DB. These users are in no way connected to LDAP,NT,AD. I need to import users into Crystal Enterprise XI as enterprise users. I do not know where the Crystal Enterprise Users and are stored and what table.( i am using a SQL server...

How i fixed this, well i didn't really fix anything. I just didn't have any proir knowledge of Business Views and how to use them. I was looking for some help on where to start but i figure it out by setting up my database connections, using the data foundation next, the use business element...

I solved this one on my own.

I am trying to figure out how to dynamically prompt the user for something like the Following. (The prompting is used to handle our organization hierarchy at any point in time) They user will pick a date and company level like WHOLE COMPANY,EXECUTIVES,DIVISIONS,REGIONS,STORES this will filter...

AAAAAAh i figured it out i'll just use the MAX function, I am brain dead today

I have two tables that join with a Contract table with PK_Contract_ID to another table with Contract Detail with FK_Contract_ID which has a one to many. What i want from the detail table is a date field. Everytime a customer makes a payment the detail table gets a new record of the payment...

lbass, thanks for all your help. i'll give it a try and let you know how things work out. cheers, Michael

lbass, I'm not sure if i can do that to get what i want in the total column in my Stored Proc. this Is my proc Below that returns my result set for my crystal report. Select COUNT(*) as STILLOPEN, Keep_DR_ID,WeekNumber, COUNT( CASE when (KWID.WeeksOpen =...

I am using Crystal 8, and my data looks like so before i create my cross tab. Week Contracts %Open 1 1500 100 2 1000 66 3 800 53 4 400 26 5 200 13 Now my Week 1 # of contracts is my total contracts the formula is...

Thanks for all the helps guys, I was making a very stupid mistake in one of my stored procs Instead on using a between join for temporal data i was just executing a stored proc from with a while and crystal really didn't like it. thanks again for the help.

Because the weird situation this report required i had to build some helper tables to get things in the format in need from my T-SQL. My stored procedure looks like this: BEGIN EXEC dbo.Keep_Agr_IDs @Number = @Week END BEGIN EXEC Keep_Data END BEGIN Select * FROM Keep_Table_ALL END...

lbass, Thanks for the help. What i have done to get weeks following week of i used a bit SQL in a stored procedure to grab all of my contracts for whatever week and the following with a DateAdd function here is my SQL, it returns whatever week number from my original date. Like this: Select...

lbass, Yes i'm talking about weeks following the week that contracts are opened. and yes there are separate date fields for closed and opened. Michael

I have a report where i need to show total Number of Contracts for a particular week. Lets say week ending 6/10/2005 and for that week i can get the total Contracts i've all computed the total number of contracts opened that week which are still open at the end of that week. But what i need...

rac2, Thanks for the help i'll give it a try and then let you know. Sincerely, Michael

I'm working on a project in which i need to check a trend for contracts and show the precentage of contracts still N weeks away from the week the contract was opened. I enter a begin date and End Date to select my Range. Then for Week Date In my range I count the total number of Contacts, Count...

unarayan, How did you get your report to span n Weeks? I am trying to figure out how to get my report to give me (N) Weeks from week Ending. It seems like you somehow know how to span like that. Sincerely, Michael