Group Tree VS 2005

[brews]

In my reports a group tree is not a desirable nor needed feature. It can eliminated if the report is opened in CR9 which creates some dialog because of an earlier version. But under 'Report Options' there is a check box to 'Create Group Tree'. But all that does is eliminate the data in the group tree. More dialog when VS2005 is updated. Must be a spot in vs2005 but I can't find it. Only stuff I see are showgrouptree and showgrouptreebutton = t/f

Secondly, in my reports I use a concantenation for city, state and zip like:

SELECT RestName, Address, IIF(City<>'',City & ', ' & State & ' ' & Zip) AS CityStZip, Phone, State
FROM Restaurants ORDER BY State, City, RestName

There is a random size gap between State and Zip even if this is used

IIF(City<>'',Trim(City & ', ' & State & ' ' & Zip)) AS CityStZip

Some records have the correct spacing.

Any ideas would be great.

Thanks

 

[brews]

Placing the Trim before state solved that problem

IIF(City<>'',City & ', ' & Trim(State & ' ' & Zip)) AS CityStZip

Ideas on the first would be helpful.

Thanks

 

[Turkbear]

Hi,
And if you set both those group tree settings to False, what happens?

In VB code, the Viewer object has attributes and one of them is related to the tree:

'after creating Viewer object, do
With Viewer
  .reportSource = reportDocument
  .HasBooleanSearchButton = False
  .HasCrystalLogo = False
  .HasRefreshButton = True
  .IsDisplayGroupTree = False
  .HasPrintButton = true
  .PrintMode = 0 ' disable activeX Printing - set to 1 to enable (may require plug-in is set to 1)
  .IsOwnPage = true
End With

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[brews]

In the CR version (10) that I have with vs2005 the only attribute that is available of those you list is reportsource. Which version are you using?

 

[Turkbear]

Hi,
This was in both 10 and XI but I did not use the VS included version -
Sorry...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[brews]

A lot of the software tag-a-longs do something similar to entice the user to buy their full bore program. Don't know that it is worth it to me at this time.

Thanks for the help.

 

[Turkbear]

Hi, Look at the examples here

http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/devsuite.htm

click the left menu for the :
Crystal Reports .NET SDK

and look at the samples and API guide..
Under this heading:

Tutorials and Sample Code..Tutorial: Customizing the CrystalReportViewer Control..Report and Toolbar Elements of the CrystalReportViewer control

there is info on various attributes you can set...

Hope it helps..





To Paraphrase:"The Help you get is proportional to the Help you give.."