Are you trying to number the columns in order to just put a number in the column title? or some other purpose?

Generally, I would say just add a row_number over(partition...

Taking a punt - have you got "Persist Security Info=False" or no entry for "Persist Security Info" at all?

If you are using a matrix report, you will only have one cell per column group/row group intersection to set it up on....

If a BIGINT is ok, you could consider this:

convert(bigint,convert(varbinary,'00sim384'))

BUT this will only work for strings up to a maximum of eight bytes in length so if you really have those...

There are always exactly: 24 hours in a day, 7 days in a week and 12 months in a year ... whether we like it or not. Therefore, I don't...

Sorry, I don't know - the renderformat extension came in 2008 R2 I think...

asranantha (5/31/2013)

---

hi friends i have small doubt in ssrs.plz tell me how to solve issue

1)

I developed one report in ssrs with heading text box.everything is good while preview...

If you don't want them to be able to change it, just select "Hidden" in the parameters properties

Eugene, thanks for posting that QU solution.

I had always thought of QU as being a "Rolling Total" solution, and this has opened my mind a bit, so thanks again.

Of course,...

What is is doing is this:

1. Copy the data to a temp table (#results) and add a column called "selected" - preset to 0.

2. Loop while we have rows where...

Rather than just returning a count and not knowing which rows are being selected, I will return the full details of each selected row and a count. Once you are...

You might be able to put page navigation buttons on the report (clickable images) that call the same report with a specific page number and have the paging logic in...

It sounds like you are getting in a bit of a loop...

Take a look at this MSDN page.

Once you understand that, put an IF in your triggers to only fire...

Hi, can you let us know your expected output as Lynn requested - is it this:

+------------------------------------------------------------+

¦[highlight="#808080"] pmd_patient_id [/highlight]¦[highlight="#808080"] endcallcd [/highlight]¦[highlight="#808080"] eventid [/highlight]¦[highlight="#808080"] createdat ...

Do you really need your PodactID, CustomerID and PaymentDate to be nvarchar(MAX) data types? I doubt it - use the correct data type for these.

When you query an element value,...