cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with sap report create

Former Member
0 Kudos

i  had create a sql database but when i create in vb it show me multi starting point then no column name shows

Accepted Solutions (1)

Accepted Solutions (1)

former_member205840
Active Contributor
0 Kudos

Hi Michael,

Have you tried creating a free hand SQL, by converting data type to varchar() and join them ?  I think writing SQL may solve your problem.

Note ; you need to use 'Add Command' option to create report using free hand SQL.

Thanks,

Sastry

Former Member
0 Kudos

i had add comman to this but when it filling data all double

former_member205840
Active Contributor
0 Kudos

It could be a join issue, try to change join type.  Also in Crystal reports -- Database Menu--Select Distinct option click on that and see..

Thanks,

Sastry

Former Member
0 Kudos

i think now it show me all data by group

i just need what i wan

former_member205840
Active Contributor
0 Kudos

Hi Michael,

Even you can insert a group on any field by going in Insert Menu-- Group -- and select the field on which you want to create a group.

Thanks,

Sastry

DellSC
Active Contributor
0 Kudos

For more information about using commands, please see my blog post here:  .  There are some tricks to getting it to work right.

-Dell

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Michael,

nvarchar(max) fields are not available in the 'Links' tab. You can't use such fields to Join other tables.

-Abhilash

Former Member
0 Kudos

This i change to nvchar500 then done but why when ifilling data follow by label text it show me all data not the 1 i select