Thanks for the reply Grant! I really appreciate it. So pretty much if I want to stick with using the linked servers then I need to incorporate the...

If the you want the user to make multiple selections you can use the join function in your parameter and change the parameter equation from parametername = Fields!name.value to...

You cannot suppress the select all option like you said since this is a built in function. What you could do is, go to the data tab, create a...

Hi Jeff,

I really do not know how to express my sincere appreciation for all your help. Thank you so much. I did not even have to do the...

Hi Jeff,

Thanks for the direction. I still am finding it difficult to understand how to do this. The deadline for this is today, is there anyway you can...

How can I merge the rows with the duplicate or common custnumbers, amounts and semesters?

e.g. row 4 and 5 have a common custnumber, amount and semester so i want to...

I used the highlight tool but for some reason it did not work...i just tried the other methods in the link you provided but neither of them worked either. ...

Great!. Glad to hear that 🙂 I hate to say but even though SSRS has more functionaloty than Crystal, it is still lacking some features.

I just ran into that same issue and I am using windows xp so I do not believe it's your OS. I believe this is a bug that Microsoft...

From what I gathered from your posting, this may be possible using a table on the fly.

declare a table @table

insert @table

select values from table1

insert @table

select values from table2

you can insert...

yes..you can do this by dragging another table from the toolbox unto the form. As far as refering to any fields from the individual tables you can by calling...

convert the date time to varchar values and trim the extra data off. e.g 2008/09/31

if you convert it, say, CONVERT(Varchar(12),receiptedyear) you should get 09/31/2008.

After getting that, trim all the leading...

That sounds very simple if I were not using a temp table for the tblStudent data.

I created a temp table and dumped all the tblStudentdata in there.

Where my problem is...

Okay. This is the whole story. We have a crystal report that uses two different stored procedures but both stored procedures have the same parameter name. We...

how can i go about using multiplr? please help.

also, the data from the secong stored proc needs to be used in the first stored proc table. FYI

thank you