I need to figure out how to name reports exported from SSRS (PDF format specifically) according to a dynamic variable that will change on every report.
Does anyone know how to do this?
i have use a sort formula in an array
in short array is
SORT
S = by style
V - By Value
P = By Profit
if i choose S (by) STYLE it sorts by style but numerically.
eg
Rocks...
My team is in the process of defining a new app that will be implemented in .NET, and need to identify the reporting tool to use. Currently Active Reports .NET and Crystal Reports are the fro...
Hi,
I had a problem with reporting services not starting and I thought reinstalling it would be the answer as I had no better advice. Unfortunately the info I got did not mention backing u...
Hi,
I have a textbox with the value:
=Fields!CustomerSsn.Value
Example output:
12345678
How can I split the string and put "-" in between?
F.ex. like this:
1234-5678
Thank yo...
Hi,
I have multiple datasets in my report. ie DataSet1, DataSet2.
I have Created a Calculated field called "CaclField" in Dataset1.
In expression for "CaclField" I am putting the expres...
I'm trying to create a report to show an individual and their giving history. When I add the field for their gift amount & gift date, it's only showing the first one & I want a list of ALL g...
Hi there,
I've got several reports setup on SSRS and I access them from an excel based application by simply passing the URL. Something like the following:
http://<ServerName>/Reports/Page...
I have heard a lot of SQL reportings and would like to get into it.
Any expert out theres can give me an overview of what is SQL Reportings and some sample of how to start using it.
Thanx
hi Experts!
the report is in landscape and i want to change it to Portrait.
Under the Report Properties, Layout, set:
A4 Landscape - Width 7.5119in, Height 8.25in
and in the Soluti...
I have a Reporting Services report executed from a vb.net Web app that ignores all the parameters passed to it and prints all the records in the table. The Stored Procedure retrieves the corre...
i have a {Customer.Emailaddress} feild.
some entries are invalid not complete or blank.
I would like to select ONLY any entry that in this field that CONTAINS the "@" symbol.
this sho...
i want to do some calculation on the base of current date..e.g. to calculate late year dates....
model.table.date= (to_number(extract(year from sysdate ) )-1
I know im camparing year with ...
Hi -
I have a typical report with several datasets and parameters that the user can select. Within the report for organization, for example, the user can select from (A,B,C,D) or all or a c...
Hi,
I'm new to Business Intelligence development studio. I'm trying to create a report that looks like this:
Record sets:
id lag_days grp_type
1 3 ...
I need to use a resource file to populate the lables in a SQL Server 2005 Report Server report.
I have looked in several places and cannot find a useable example, or even someone saying t...
Hi there,
All my reports on SSRS run off stored procs on the database. For parameters which have been defined as DATETIME (in the Stored Proc) I find that if I use a datetime picker (define i...
I dont know if this is even possible but i need advice and direction. In reporting services I would like to be able to present different fields based on a users input. For example I need to gi...
Hi Experts,
I've this function:
Public DateRangeMsg(byval MyStartDt as Date, byval MyEndDt as Date) as String
IF MyStartDt = CDate("01/01/2008") Then
Return "Count For Previous Mo...
hi there:
I'd like to copy some parameters from one report into another, is there any way to do this?
Also, is there any way to set up the layout for the report as landscape?
Thanks
...
I created a stack bar showing the No. of staff from 3 differnet Country.(CountryA, Country B,Country C)
I used the data lable with the stack bar for each country.
My issue is: In case {NO. ...
i need a few dynamic .rdl reports in a slideshow .. need some tips how to do this .. perhaps there is a program that can do the job
thanks in advanced
This is minor but a very annoying issue in a SS Reporting Services report-
Inside a table, I need to format a meeting time as such: 8:00AM- 5:00PM.
As it is now, I have an extra space after ...
We have made a 2 node cluster on windows server 2003
We have required to add these services on existing cluster
thanks,
Hi,
I've developed a small application in Access 2003, and I'll be enhancing in the future. I'm connecting to a SQL 2005 database in the backend.
For the moment, I've been creating reports...
