Thanks for posting it, in fact went through the same issue couple of days back.

Thanks

Try checking the stored proc that returns the result set, run the sql profiler and see how the SP is running, look for any large table scans and see if...

Hi,

Is the detail report launched based on a hyper link action, like when you hover the mouse over user id you can click on it open the detail report? what...

Hi,

Based on what you have been stating here, it looks like you have 2 ways to execute the report, one is ALL USERS,ALL CLIENTS and the other option where you...

Having the PASS Summit on the east coast would be great for example if it were held in Atlanta,Orlando,New York. Folks like me could drive down and cut down on...

Hi,

If you trying to transfer data, you can use the Data Flow task to transfer data from table(s) in database to the target database.

you can run the sql in the...

Hi,

Do you have the answers for these. Also how is the performance of Merge and Merge Join on large datasets.

Thank you

Hi,

It is possible to have a master detail report in SSRS. For example i have a summary report. In the summary report when the user clicks on certain column values...

Hi,

When you created the package using import wizard, could you save the package to a file location and try opening it up in BIDS. While using the wizard, towards the...

Hi Lynn,

Thanks for the tips, really appreciate it. I guess i was coding for the specific instance. For the assignment i need to use the AS clause.

Here is the query,

In the result Ram has one class in feb as per the data...

SELECT teacher,

Jan=SUM(CASE WHEN DATEPART(m,Date)=1 THEN 1 ELSE 0 END),

Feb=SUM(CASE WHEN DATEPART(m,Date)=2 THEN 1 ELSE 0...

Hi, I agree with the previous reply, there are limitations on how we can dynamically show/hide parameters on reports in SSRS.

Thanks for the reply. I am getting an error at the definition of docXML itself, i get squiggly lines under the XmlDocument, at the Dim Statement. When I do DocXML....

Hi,

Is the size of attachment too big that it exceeds the sending limit. What if for testing purposes send the results to a text file and try sending the e-mail

Thank...

Thank you for the information and suggestion.