Formating issues when exporting to excel

I have several columns in a report that have conditional formating. If
the criteria is met the data in the row is supposed to be green,
otherwise it is black. When I export this to excel, excel looks at the
format of the first row and then sets the formating for all the cells
to that color. Is there a way to make sure excel formats each
individual cell correctly?Also noticed that when i export the report when i run the report
through Visual Studio it exports it correctly. Is this a version issue
with RS?|||Hi, I have the same problems to set the color for each cell. Do you find the
solution? If does, please post back. Thank you.
"acahn@.planetmagpie.com" wrote:
> I have several columns in a report that have conditional formating. If
> the criteria is met the data in the row is supposed to be green,
> otherwise it is black. When I export this to excel, excel looks at the
> format of the first row and then sets the formating for all the cells
> to that color. Is there a way to make sure excel formats each
> individual cell correctly?
>|||Hi Jim,
I have not figured out the problem. I'm hopeing that when we migrate to
reporting services for 2005, that it fixes the issue...
"Jim Pan" wrote:
> Hi, I have the same problems to set the color for each cell. Do you find the
> solution? If does, please post back. Thank you.
> "acahn@.planetmagpie.com" wrote:
> > I have several columns in a report that have conditional formating. If
> > the criteria is met the data in the row is supposed to be green,
> > otherwise it is black. When I export this to excel, excel looks at the
> > format of the first row and then sets the formating for all the cells
> > to that color. Is there a way to make sure excel formats each
> > individual cell correctly?
> >
> >

Form to create formula

Is it possible to create a form / pop up table for users to input criteria to search upon.

I am trying to set up a template to search, for example, for serial numbers where {contsupp.contact} = "serial number" (with other set criteria)is it possible to have this set up for users who are not familiar with crystal reporting so that they are prompted to insert a serial nuimber #1234 in a field which then populates the "serial number" area and runs the search?If you create a parameter field, you can set it in the select expert as the field you want (so, for example if you have serialnumber as a field, the parameter field (?serial) would be set up to use that field and then in the select expert you would select
{whatevertable.serialnumber}=?serial

Then, the crystal viewer will pop up a parameter select form automatically.