Crystal Reports missing columns  Topic is solved

Support for Crystal Reports within Jiwa.

Crystal Reports missing columns

Postby DannyC » Wed Apr 05, 2017 1:04 pm

I have a really weird problem.

I have a view in SQL. Been there for years.
A few years ago I wrote a report which reads the data from that view.
It is basically looking at IN_Main, and the view gets the custom field data so that each row is a single product, and the columns are each custom field. Not too complicated.

Today I got occasion to check the report because the client reported that the report is not displaying the custom fields data.

In Crystal, when doing a 'verify database', the columns are missing from the Database Expert, Links tab as if they are not in the view at all.
And when running the report within Jiwa, doing a SQL trace reveals that the columns are not even getting referred in the SELECT statement.
It is like Cystal can no longer see those columns.
I have done a grant_all_user_tables just to be sure permissions are OK. This is in version 7.0.157 but I don't think it's a Jiwa problem - I think it may be more Crystal related.

It's bizarre so the above may seem like waffling rubbish so if there is anything unclear I am happy to clarify!
User avatar
DannyC
Senpai
Senpai
 
Posts: 635
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 29

Re: Crystal Reports missing columns

Postby Scott.Pearce » Wed Apr 05, 2017 1:11 pm

Are you doing a "Set datasource location" before the "verify database"?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Crystal Reports missing columns  Topic is solved

Postby lennykp » Wed Apr 05, 2017 1:34 pm

Hi Danny
The new customsettingvalues.contents has type varchar(max). Crystal 2013 doesn't like this type. I've experience this before. when I create a view for a specific custom field, I just return the Contents field and invoiceid, when I add this view to the crystal report, I can see the invoiceid field but no "Contents" field.

I normally do view to convert the contents to varchar(254). Then I can see the Contents field in the report.

Lenny
lennykp
I'm new here
I'm new here
 
Posts: 4
Joined: Fri Aug 22, 2014 12:20 pm
Topics Solved: 1

Re: Crystal Reports missing columns

Postby DannyC » Wed Apr 05, 2017 1:55 pm

Lenny gets the prize. Thanks!
User avatar
DannyC
Senpai
Senpai
 
Posts: 635
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 29

Re: Crystal Reports missing columns

Postby Mike.Sheen » Wed Apr 05, 2017 8:35 pm

lennykp wrote:The new customsettingvalues.contents has type varchar(max). Crystal 2013 doesn't like this type.


Oh dear... DEV-3068 comes back to bite us again!

DEV-5894 created to look into this.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron