Search results for query: *

Yes I did but it just isnt working. Are you sure the formula is correct?

I am sorry, b2 is c1, i typed it wrong. This is the formula with replacement: =INDEX(assortiment_excel,MOD((ROW()-1),ReportRows)+INT((ROW()-1)/ReportRows)*ReportRows*ReportCols+INT((COLUMN()-1)/SourceCols)*ReportRows+1,MOD(COLUMN()-1,SourceCols)+1) I have no idea why it works for you but not...

1. this is the formula: =INDEX(Source,MOD((ROW()-1),ReportRows)+INT((ROW()-1)/ReportRows)*ReportRows*ReportCols+INT((COLUMN()-1)/SourceCols)*ReportRows+1,MOD(COLUMN()-1,SourceCols)+1) 2. values : A1 2 // named range SourceCols A2 30 // named range ReportRows A3 2 // named range ReportCols...

Hello, I have been away so didnt have time to respond. This is what I did: sheet1: column A = itemid column b = itemname sheet2: A1 = your 3rd formula (it gives me an error at Source,Mod) sheet3: A1 = SourceCols (also name of named range) A2 = ReportRows (also name of named range) A3 =...

Thanks Skipvought for helping me with a solution. Only problem is I cant get it working. Could you help me step by step how to make this formula work and what should be edited?

The data changes as I change a paramater, wich will happen alot. It must have a connection with my database , thats why I want to use Excel to retrieve always the latest data without editing the page. Thats why I am looking for a query/excel solution. I am afraid Word wont do the trick

I am importing the query trough external sources -> ms query . (translated from dutch) I am using Excel 2007.

the list I have is max 4 pages. Isnt there a way to split the query in 4 parts like you are suggesting, but then add the queries like this: page 1 A1 row 1-30 D1 31-60 page 2 A1 row 61-90 D1 91-120

Hello, I am making my way from Crystal Reports to SQL reporting services. I am trying to build a report in Visual Basic. I encounter 1 problem. I have a list with 2 fields, itemid and itemname. The list is small and in Crystal Reports I had the option to format the page to multiple columns, so...

I cant edit my post. I mean Visual Studio 2005, not Visual Basic.

Hello, I am making my way from Crystal Reports to SQL reporting services. I am trying to build a report in Visual Basic. I encounter 1 problem. I have a list with 2 fields, itemid and itemname. The list is small and in Crystal Reports I had the option to format the page to multiple columns, so...

Hey, I am trying to import an SQL query into an Excel worksheet. Everything works fine, only problem is that it is a very long list and only the left side of the page is used, the whole right side of the page is empty. I am looking for a solution so the list will go first from the left side...

The usual format that I want to use is <item name> - <packaging> / <brand> but sometimes I dont have all that for an item field. Thats why I think its better to add some formula that if the field isnt complete in that format it will show in another unsorted categorie so I can add that later.

At the beginning of the report.

Hello, I have another question in reference to my previous topic : Splitting Records in 3 groups. I am trying to make a price list in Crystal Reports. I used to make the price list in excel where I would type it all manually, but now I want to do it directly from the MS SQL database so I dont...

Lbass , other variations could be : <item name> / <Brand> <item name> <item name> - <packaging> I need to add some kind of formula where it states that it should display these and all other possible variations under some sort of unsorted group. That way I can add for example the brand and...

I switched the - and the / because I stated it wrong in the start post. First there is the / and then there is the -. I also removed the spaces around the " cause sometimes they are attacked right to eachother. Not every record has a hyphen and a slash so that could be the problem. Do I need...

There is the MS SQL server. Atm I am working with Saved Data.

Ok I am not at the office but tomorrow I try and let you know. Thanks for all the help so far.

If i put all 3 fields in Details section i get the right information x formula. But if I try to group formula 3 it doesnt work and it gives me that error message. It also highlights this formula: split(split({Items.Description},"/")[2],"-")[2] I am using Crystal Reports v11