Problem with Query designing at reporting level

[Former Member]

Hi All,

I had created a query and started designing a crystal report.

But after designing the report, i came to know that some infoobjects are missing in the query.

So i went to query designer and added the corresponding infoobjects inorder, they could reflect while designing my crystal report.

But when i have reopened the report the field explorer is not showing the infoobjects which i have added newly.

In crystal reports what is the way to obtain those objects which are newly added to the query.

Even i have refreshed the field explorer many times but still it is not showing the updated objects.

But if i go creating a new report on the same query, there it is showing the added objects as well.

Only for the new report i could able to see the newly added objects in field explorer but not for the old report.

Please let me know the solution for this problem ASAP.

Best Regards

Jiten

[Former Member · Accepted solution]

Hi Jitendra,

Did my solution work for you ?.

Thanks,

KR

[Former Member · Accepted solution]

Hi KR,

Thanks for ur support...i could now update the field explorer and c the changes affected....

It is a gunshot aanswer.

Thanks & Best Regards

Jiten

[Former Member]

Hi,

From the Crystal Report designer, try the option Database - > Verfiy Database. That should bring the latest definition of Query into CR.

Hope this helps.

Thanks,

KR

[Former Member]

Hi Jitendra

As per the issue description, you have created a report using Command Object and new objects i.e. fields are not displaying in field explorer after modifying the Command Object with the new objects.

I would like to know the following information:

- Exact version of Crystal Reports Designer.

- The steps through which you have add the objects.

- Please search for SAP Note # 1215594 and follow the given steps to update the datasource location of a Command Object after rewriting the complete query with the new objects.

Hope this helps!

Thanks