Viewing 15 posts - 76 through 90 (of 139 total)
perhaps you should be passing a string...
In similar cases I have been driven to writing this in a stored procedure:
where (charindex(','...
November 22, 2006 at 2:04 am
You could check the length of the text and if over a certain length insert a hyphen, line feed and a few spaces.
November 9, 2006 at 1:47 am
So the correct answer is False, not True. Give me my points!
October 26, 2006 at 2:30 am
these are types of relationships between tables. You need to base your report on a view which links the tables appropriately, i.e. as many to many or many to one.
October 17, 2006 at 1:50 am
you could try adding just one visible parameter where the user types in the value of the column and then add a 'jump to report' link on the column heading...
October 5, 2006 at 2:00 am
you can either pass the parameters to a stored procedure on which you base you dataset or use the parameters, e.g. with IIF, to build an SQL string in Report Designer.
September 15, 2006 at 3:04 am
you can edit ReportingServices.css in the ReportManager/Style folder on your server. I've done this to add the company logo and alter the colours. You can also change the text at...
September 15, 2006 at 3:01 am
the user needs to have local adminstrator rights to load the control
September 14, 2006 at 1:43 am
probably easiest to include the corresponding count() in the SQL for the main report via a left join to the appropriate table.
July 24, 2006 at 9:00 am
We never even considered this! I'm pretty sure the answer's no.
July 14, 2006 at 3:13 am
you do of course need to replace 'localhost' with the name of your report server...
June 28, 2006 at 1:23 am
One thing Management Studio can't do is edit table-valued functions from SS2000 databases. I have to go back to EM for that.
June 26, 2006 at 1:54 am
Countries in the European Union have had 'Data Protection' laws since 1998 to combat the misuse of personal data. The reason the US has not had this, as it was...
June 19, 2006 at 6:15 am
I have a similar problem of a report firing off before all the parameters have been filled in and then complaining (rsParameterError) that some of them aren't filled in! It...
June 14, 2006 at 5:24 am
I always use as the default for a parameter
=datetime.today.addmonths(-1)
for the date this time last month for instance. There are similar methods for days and years.
June 13, 2006 at 4:12 am
Viewing 15 posts - 76 through 90 (of 139 total)