RDL

Hi
I currently use SSRS2005 and I develop reports, for use in our company. My
question is, I was wondering if it is possible to embedd some sort of tag,
which holds version information, since some of the reports that we develop
go through several iterations and it would be useful if we could have some
sort of tag, instead of altering the filename everytime.
Kind regards
Ricky
(SS2005/SSRS2005)On Jun 22, 2:51 pm, "Ricky" <r...@.msn.com> wrote:
> Hi
> I currently use SSRS2005 and I develop reports, for use in our company. My
> question is, I was wondering if it is possible to embedd some sort of tag,
> which holds version information, since some of the reports that we develop
> go through several iterations and it would be useful if we could have some
> sort of tag, instead of altering the filename everytime.
> Kind regards
> Ricky
> (SS2005/SSRS2005)
This is a long shot; but, you could try using a hidden parameter field
and setting it to a static value of some sort. Otherwise, you would
most likely be able to automate the file renaming process in a custom
application based on a timestamp of some kind. Sorry that I could not
be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hey Enrique
Thanks for the posting, no need to apologise, I thinking along the same
lines of using somesort of hidden object in the report itself...
Kind regards
Ricky
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182576891.242395.75490@.n60g2000hse.googlegroups.com...
> On Jun 22, 2:51 pm, "Ricky" <r...@.msn.com> wrote:
>> Hi
>> I currently use SSRS2005 and I develop reports, for use in our company.
>> My
>> question is, I was wondering if it is possible to embedd some sort of
>> tag,
>> which holds version information, since some of the reports that we
>> develop
>> go through several iterations and it would be useful if we could have
>> some
>> sort of tag, instead of altering the filename everytime.
>> Kind regards
>> Ricky
>> (SS2005/SSRS2005)
>
> This is a long shot; but, you could try using a hidden parameter field
> and setting it to a static value of some sort. Otherwise, you would
> most likely be able to automate the file renaming process in a custom
> application based on a timestamp of some kind. Sorry that I could not
> be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 23, 9:15 am, "Ricky" <r...@.msn.com> wrote:
> Hey Enrique
> Thanks for the posting, no need to apologise, I thinking along the same
> lines of using somesort of hidden object in the report itself...
> Kind regards
> Ricky
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1182576891.242395.75490@.n60g2000hse.googlegroups.com...
> > On Jun 22, 2:51 pm, "Ricky" <r...@.msn.com> wrote:
> >> Hi
> >> I currently use SSRS2005 and I develop reports, for use in our company.
> >> My
> >> question is, I was wondering if it is possible to embedd some sort of
> >> tag,
> >> which holds version information, since some of the reports that we
> >> develop
> >> go through several iterations and it would be useful if we could have
> >> some
> >> sort of tag, instead of altering the filename everytime.
> >> Kind regards
> >> Ricky
> >> (SS2005/SSRS2005)
> > This is a long shot; but, you could try using a hidden parameter field
> > and setting it to a static value of some sort. Otherwise, you would
> > most likely be able to automate the file renaming process in a custom
> > application based on a timestamp of some kind. Sorry that I could not
> > be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Let me know if I can be of further assistance.
Best Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique, you've pointed me in the right direction, which helps .
Kind regards
Ricky
s
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182644372.225176.28640@.g4g2000hsf.googlegroups.com...
> On Jun 23, 9:15 am, "Ricky" <r...@.msn.com> wrote:
>> Hey Enrique
>> Thanks for the posting, no need to apologise, I thinking along the same
>> lines of using somesort of hidden object in the report itself...
>> Kind regards
>> Ricky
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1182576891.242395.75490@.n60g2000hse.googlegroups.com...
>> > On Jun 22, 2:51 pm, "Ricky" <r...@.msn.com> wrote:
>> >> Hi
>> >> I currently use SSRS2005 and I develop reports, for use in our
>> >> company.
>> >> My
>> >> question is, I was wondering if it is possible to embedd some sort of
>> >> tag,
>> >> which holds version information, since some of the reports that we
>> >> develop
>> >> go through several iterations and it would be useful if we could have
>> >> some
>> >> sort of tag, instead of altering the filename everytime.
>> >> Kind regards
>> >> Ricky
>> >> (SS2005/SSRS2005)
>> > This is a long shot; but, you could try using a hidden parameter field
>> > and setting it to a static value of some sort. Otherwise, you would
>> > most likely be able to automate the file renaming process in a custom
>> > application based on a timestamp of some kind. Sorry that I could not
>> > be of greater assistance.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> Let me know if I can be of further assistance.
> Best Regards,
> Enrique Martinez
> Sr. Software Consultant
>

RDA problem with SQL Server 2005

My company just converted to SQL Server 2005. I have a pocket PC application, developed with Visual Studio 2003, that is now giving me an RDA problem.

Two tables push fine but the third gives me the error:

"ERR: Push for Table Events: System.Data.SqlServerCe.SqlCeError: The OLE DB data type information in the SQL Server CE columns does not match the information in the SQL Server columns for the RDA table. [Client type, Server type,,Table name,,]"

This is despite dropping all the tables and doing an RDA pull from the database. I don't see anything different on this third table than the other two.

Any suggestions would be appreicaed.

Correct error handling should tell you which data type are in conflict from the error parameters collection, see http://msdn2.microsoft.com/en-us/library/ms174079.aspx|||

My error parameters are as follows:

Error Paramaters

(0)=""

(1)=""

(2)=""

NumericError Parameters

(0) = 0

(1) = 0

(2) = 0

Can anyone help me understand if this is of help!

|||This is obviously not very helpful at all! Could you try to make a "Create table" script of the problematic table, so we can see how it is defined.|||

I'm not sure what you mean by this script, but here is my table definition out of Sql Server 2005:

Event Number(PK, varchar(13), not null)

TransfectionNumber (FK, varchar(13), not null)

type (nvarchar(1), not null)

HHDeleteDate(smalldatetime, null)

Note(nvarchar(255), null)

Keys

PK_Events

FK_Events_Transfections

I pull this table, and all the others, using RDA so the definition should be coming over fine.

I use similar column definitions on other tables without problems

Thanks,

Ron

|||

With some further testing, it's possible my problem is occuring because of the name "type" in the table. Is there a way to change the name in the SQL CE database easily. Otherwise, I'll need to reenter data captured over the last week.

Ron

|||

That sounds like it, Ron. '

SQL CE's SQL syntax does not allow you to rename a column.
You must save the column data, drop the column, add the new column, and restore the old data in the new column.

Some of the tools from www.primeworks-mobile.com will also be able to help you.

Rate Table - Need Help To Display Data Horizontally

Hi everyone. I need help creating a query for a transportation company. I am trying to querying a table of rates that stores it's values vertically and want to display the information horizontally.

Below is an example of sample data from the table. One column in the table lists all the different cities that a group of breakpoints apply to; another lists the different weight breakpoints; and the third contains the corresponding rates for each weight break. See example below.

Weight Range
(not a field in the database
just added to describe meaning
of breakpoint column) City Breakpoint Rate
0 -100 A 100 $100
101 - 200 A 200 $200
201 - 300 A 300 $300
0 -100 B 100 $100
101 - 200 B 200 $200
201 - 300 B 300 $300

I want to display the information horizontally
City 0-100 101-200 201-300
A 100 200 300
B 100 200 300

The only other twist is that different companies have different weight breaks and they are all stored in the same table. For example Company ABC's rates have the following weight breaks.

Weight Range
(not actual field
in database) Breakpoint field Rate
0-100 --> 100 $100
101-200 --> 200 $200
201-300 --> 300 $300

Company XYZ can have breakpoints such as the following.
0-50 --> 100 $100
51-100 --> 200 $200
101-150 --> 300 $300

If creating one report to accomodate both companies is not possible then I could also create seperate reports for each company. Any help or suggestions would greatly be appreciated. Thanks in advance.i would suggest that you do this in the application layer|||I agree with r937. Don't make your SQL statement too complicated, because it will be a pain in the butt to fix or change things later. It would be way easier to loop through the results and place each value in a cell in a table. By doing this you can also do some error checking for bad data before you display.

Good luck
Hope it helps|||This is essentially a "table pivoting" problem.
It's not clear from your example but I'm assuming that the number of output columns can be larger than 4, depending on the input data.
In that case, only recursive SQL (using "WITH", i.e., CTEs) will help you. (Or maybe your SQL engine has a built-in PIVOT functionality ...)

See http://tinyurl.com/6wugk for a related problem (with solution).

H.t.h.