Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show SQL Query has 'NULL' as a Parameter in Crystal 9

Status
Not open for further replies.

CanoWermz

Programmer
Apr 24, 2006
6
US
Hello again Crystal Gurus!

My particulars:
Crystal 9
2 tier PeopleSoft 8.49 Financials
Oracle 11g

This is an existing report that works in production and I am trying to make some changes. When I do verify or anything database related to run the report, I only get to enter the last 2 of the 9 prompted values. What gives? Is it my connections? I tried searching the forum and the web but no luck.
Hopefully someone has seen this before.

I see this on Show SQL Query:

{CALL "HFIN9876"(NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2011', '6')}

That is the correct query name. All those NULLS should have values. How do I fix this?

Thanks again for the assist.

BG
 
Disregard my request. A co-worker fixed it.
I still don't know what I did wrong or how he fixed it, but it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top