Search results for query: *

Hi, I need to update a Scroll Area label (title) using people code. The scroll area already has a Page Field defined but not sure how to proceed. Any tips would be appreciated. Thanks.

Already solved my problem. Had to clear both the Appserver and Process Scheduler Cache :)

Just to add, I'm also getting the following errors: Unknown field HT_HOLD_DATE for property HT_HOLD_DATE (91,63) Can't register class (81,19) Would anybody know what the problem is?

I added a new property in a component interface. The problem is i'm getting an error now when i try to initialize the CI using %Session.GetCompIntfc(CompIntfc.RO_CAPTURE_CI) This line now returns NULL, which wasn't the case before the change. Am i missing something? I already "Validated for...

Thanks for your reply. Actually the reason why i wanted to use the Union is because i need COL4 populated even if the 1st Select doesn't return any records. It's not very pretty I know but that's the best i could think of since i needed a quick fix.

Thanks lbass. Was able to fix my problem using your suggestion.

Hi, I'm not very familiar with PS Query yet. I was wondering if it's possible to select constants/null values from a table? The reason i'm asking is because my query needs to look something like this: SELECT A.COL1, A.COL2, A.COL3, A.COL4 FROM TABLE A, TABLE B WHERE... UNION SELECT...

I have a follow up question. How can i do this in a subreport? I noticed that the logic you suggested, will put a reset formula in the page header. But there are no page headers in sub reports right? Is there a way to get around this? I was thinking of placing the reset formula in the page...

Hi Guys, I need to find a way to implement the following table but i'm not sure on how to go about this since i'm still very new to Crystal Reports. For example: NUM_CASES | JAN | FEB | MAR | ------------------------------ 8 | TN1 | TN1 | | ------------------------------ 7...

You were right, i noticed in datasource location for the subreport it had some invalid logon information in the Properties. I wasn't aware of that or actually didn't know exactly how to verify :) Still getting the hang of this so your help on this was much appreciated. Thanks.

Hi, Yes, the subreport uses a different data source (ps query) from the one in the main report. But they're both fetching values form the same database, so the login info should work for both data sources. Could it be that it's a PeopleSoft security issue? I created the query for the subreport...

I removed any bind variables in my query for the subreport and i'm still getting the same error. Does this make sense? Why would i receive this error even if the subreport doesn't require any parameters at all? Thanks for any help.

I encountered the following error when trying to run the report in PeopleSoft's Process Scheduler: "Unable to connect: incorrect log on parameters. %6 %7 %8 %9 (65,30)" It works fine when I previewed my report in Crystal Reports 9. I think it has something to do with the subreport that i...

Thanks for the link lbass. Shall try that out.

Hi, I'm new to Crystal Reports but have been assigned to implement the following requirement. The report lists Supervisors (Group Header) and their Employees (Detail). Now, the client DOESN'T want the following scenario: Having the Supervisor at the end of the page without any Employees, since...

I'm working on this project where i have to generate an id number. On my page, i use a SQLExec statement to get the max number of entries for this table. Then, i increment that number by 1 and that's how i ensure that the id is unique. I have to display this id in a scroll area, which is where...

Etom, Thanks a lot for taking time to reply. I tried it out and it works. =) Thanks again.

Hi, I'm a COBOL newbie and i'm stuck on what seems to be a simple problem. I'm currently using "SAMS teach yourself COBOL in 21 days", which uses MicroFocus code. But i use the free Fujitsu compiler with it. Anyways, the following code snippet doesn't behave properly: ... DATA DIVISION...