Take a value from an specific attribute

[former_member618855]

Dear All,

I'm not Expert with CR 2016 and is the first time that I use.

I still create a Template from StoredProcedure Table with different SubReport and where I haven't the access at the single filed that I have need inside to the SQL DdataBase but I can take it from another table where are including all data.

So my question is, how can I take the Attribute Value that referring to an exactly Attribute?

Example: I have the AttrValue field where there are all value and the Attribute Field where included the description of the AttrValue field.

Ho can say at Crystal report to give me only the AttrValue of the Attribute "Draw"?

I have try to create a parameter with name Draw and where I have included the value "Draw" inside that, after this I have create a formule; if Draw parameter is equal to "Draw" then give to me the AttrValue but don't function.

I think that is a simple procedure but I haven't Idea how can I do..

Somebody can help me?

Thanks

Roberto

[former_member618855]

Dear Mrs. Dell,

for solved this problem I have opted to create a new field inside to the Database, after this I have update the table inside to CR and taken the single attribute without use any filter but now I have another problem that maybe you can help me.

If I have different parameters from different table, How I can set a specific parameters with the same value on a specific value attribute on another table?

Example:

I have a parameter "?design" and I want that this parameters is equal to "v_design" from another table. How I can do that? Is possible? Because I cannot connect the table from the database directly or the SubReport don't function correctly..

I have try to use the filter with "is equl to" but don't function....

Here attached you can find two picture regardign that.

Thank you

Roberto

[DellSC]

If I understand you correctly, you'll need to open the Select Expert in the subreport. Then you'll pick the AttrValue field from the list of fields in the subreport, select "is equal to", and then select the parameter from the drop-down list of values. This will filter the sub-report based on the attribute.

-Dell

[former_member618855]

Dear Christy,

I have try also this possibility but don't function.

I have try to put is equal to "Draw" and also is equal to "?Draw" parameter but nothing to do, don't function.

I have try also to select on dop-down the value that I have need but isn't mention, I can see on the preview of the Template but not inside of the dop-down (I think that there are most value and CR cut the data).

[DellSC]

You're running into a record limit in the drop-down list of values. There is a registry setting that can be used to increase the number of record read.

If you're on a 64-bit OS, you'll go to HKEY_LOCAL_MACHINE\ Software\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\, if you're on a 32-bit OS, you'll go to HKEY_LOCAL_MACHINE\ Software\SAP BusinessObjects\Suite XI 4.0\ in the registry editor. In either you'll then go to \Crystal Reports\DatabaseOptions\LOV - if this doesn't exist, you'll create it. Then you'll create a key called "MaxRowsetRecords" (this is case sensitive!) and set the number to something greater than 1,000, which is the default value. This is the number of records that Crystal will read when it's looking for distinct values for the list.

-Dell

[former_member618855]

Unfortunately I cannot modify the regedit on my PC because is protected by the company domain.

Do you know some other way?

I think there will be another way for create a filter without use the standard method.

Roberto

[DellSC]

Do you have access to run a query directly on the database - not through Crystal? If so, I would go to the Database menu, select "Show SQL Query", copy the query, and run it on the database to see whether it brings back any data there. My thought is that there might be something wrong with your joins that would prevent data from coming back in the query.

-Dell